• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

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
0
25112
Asked:
25112
  • 2
1 Solution
 
25112Author Commented:
i saw this on SQL R2
0
 
TempDBACommented:
DECLARE @a TIMESTAMP
SET @a = 0x000000000001A58C
SELECT @a

SELECT CAST (@a AS DATETIME)
0
 
Anthony PerkinsCommented:
You can't.  They are totally different animals.  Read up on them in SQL Server BOL.
0
 
25112Author Commented:
OK.. thanks for that
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now