Datetime conversion

[lyudmila]

Is it posissible to convert string '62001' to datetime format? And how?

 

[SQLSister]

And what date would this be expected to convert to?

 

[lyudmila]

I may only guess! May be 1/6/2001 will work?

 

[SQLBill]

If you don't know what 62001 is supposed to be, how can we figure it out?

62001 could be June 2001, but it could also be June 20, 2001 (6/20/01).

-SQLBill

 

[checkai]

declare @x as datetime
SET @x = convert(datetime,left('62001',len('62001')-4) + '/01/'+ right('62001',4))

print @x

 

[checkai]

This would be if June 1, 2001 was the right answer....
but that's for you to figure out...

 

[Rhys666]

This could be a straight 62001 days since '01 Jan 1900' also. I agree with the very good knowledge of SQLSister and SQLBill and think you need to understand the meaning of 62001 before trying to CONVERT or CAST it to a date.

Rhys

Be careful that the light at the end of the tunnel isn't a train coming the other way.