HI! :shocked:
I tried to convert 0x01C3F0F5012D36E0, binary(8) to datetime
But
How can I do that?
thanks for allwhat does 0x01C3F0F5012D36E0 repesent in datetime as ?|||You can't convert it, it is bigger than the largest possible datetime:DECLARE @.dMax DATETIME
SET @.dMax = '9999-12-31 23:59:59.997'
SELECT Cast(@.dMax AS VARBINARY(8)), 0x01C3F0F5012D36E0-PatP
Friday, March 30, 2012
how can i convert binary(8) to datetime?
Labels:
0x01c3f0f5012d36e0,
binary,
convert,
database,
datetime,
datetimebut,
microsoft,
mysql,
oracle,
server,
shocked,
sql,
thatthanks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment