Would that work for a whole column of dates, or would I have to declare each on and convert them individually?

Okay, so If I cannot convert from that format, is their a way to hide the time from being displayed?

Thanks! I tried the Cast you mentioned above and it worked. Now the only thing is that it gives me the date in this format: 2010-12-03 00:00:00.000. All I need...

Actually I am trying to pull data out of our database for a report, but because the dates I need are in a text field, I really cannot do much...

The field is (text,null) and the data reads as such 3/19/2012.

When I try to convert it, I am given an error stating that text cannot be explicitly converted to...

Ah,I see. Well, thanks again for all the help, I'll give it go and see what happens:-)

Joe

So, I would have to create a temporary table, and then run my query?

Sorry to be a pain, but SQL is still somewhat new to me.

I guess my question is instead of declaring a specific date, would I declare the format, such as 'mm/dd/yyyy' ?

Joe

Thanks for the replies, I really appreciate it.

One question, and I'm still new to using SQL,

declare @Date varchar(10) = '12/3/2012'

declare @Time varchar(20) = '10:33:31 PM'

select CAST(@Date + ' ' +...

Hi,

I agree, I wished who ever initially set these up did so in a different way, but I have to work with it regardless.

The date and time are in 2...

Hi, thanks for the quick response.

Here's what I have to work with in these tables,

Table_1

HeatNumberID (PK,varchar(50),not null)

Start_Time (text,null)

Start_Date (text,null)

...

OK, now I feel dumb, but that was it, Thank you for the help:-)

Joe

Sounds Good,

Thanks,

Joe 🙂

Wow, that was exactly what I was looking for. Thanks for all your help. That gave a different way to think about how I'm going to put my overall query...

I will try CAST and see if that changes anything, thanks,

Joe