Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 TIME STAMP IN SQL

Author  Topic 

TMDOSS
Starting Member

33 Posts

Posted - 2009-02-18 : 10:36:26
from the timestamp Field how Can I read the Date/time
Its look like this 0x0000000000637FAB

thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-18 : 10:39:22
[code]Select convert(datetime,0x0000000000637FAB)[/code]
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-18 : 12:32:21
http://www.sqlteam.com/article/timestamps-vs-datetime-data-types
Go to Top of Page
   

- Advertisement -