asked
converting a string to Date
Hi, Can anyone please tell me how to convert this "0x0000000054FFA42E" to Date or date time or time. i have verified it with Isdate()
function.it has given "0" as output. is there any other way to convert this value to Date or date time or time. if you want you can add some constant value to it for conversion. Regards, Sql Server User
Yes it's possible, but I doubt I've converted it right declare @var varbinary(8) set @var = 0x0000000054FFA42E select dateadd(second,cast(@var as bigint),0) ----------------------- 1945-03-11 02:10:54.000 (1 row(s) affected) The point is I've no idea what that value is supposed to signify. In the example I've given I've assumed it is the binary representation of the number of seconds since 1 Jan 1900. But I doubt it. Can you give us some more information?
@kev Riley Is there any way to get that date to today;s date.
If you are saying that the value 0x0000000054FFA42E represents today's date (ignoring a time portion for now), then yes they will be some way of converting it back, but we need to know what the function is. Do you know how that value was generated from today's date?
Hmm..i dnt knw,hw that value generated from Date and which function they used for conversion.
14 People are following this question.
