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?