25112
asked on
timestamp value in SQL Server
when there is a time stamp value of 0x000000000001A58C in a column in a table, how can we change it to 'proper' format..
example.. 2011-10-03 12:10:25.867
thanks
example.. 2011-10-03 12:10:25.867
thanks
DECLARE @a TIMESTAMP
SET @a = 0x000000000001A58C
SELECT @a
SELECT CAST (@a AS DATETIME)
SET @a = 0x000000000001A58C
SELECT @a
SELECT CAST (@a AS DATETIME)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK.. thanks for that
ASKER