Convert Time Stamp to Datetime in sql server 2005

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

General SQL Server Forums

New to SQL Server Programming

Convert Time Stamp to Datetime in sql server 2005

Author

Topic

sachin.hingole
Starting Member

15 Posts

Posted - 2009-01-16 : 02:22:48

Hi,

I want to convert the timestamp (I have took this column from the SQL server 2000 and want to convet that timestamp into date for SQL server 2005) column to the datetime is there any function or way to convert it into datetime

I have tried using cast and convert functions but its giving wrong output

Thanks in advance

Sachin Hingole

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-16 : 02:28:52

Do you have any example?

E 12°55'05.63"
N 56°04'39.26"

sachin.hingole
Starting Member

15 Posts

Posted - 2009-01-16 : 02:35:47

the time stamp column has the data as
0x00000000000067FB
select CAST (0x00000000000067FB as datetime )

Sachin Hingole

ashishashish
Constraint Violating Yak Guru

408 Posts

Posted - 2009-01-16 : 03:26:00

Wat Ur Expected Output.....
mean the output for me is when i run this query,,,,

select cast(0x00000000000067FB as datetime)

1900-01-01 00:01:28.730

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-16 : 03:32:44

Timestamp is NOT a datetime value. It is a "row version" number...

SELECT CAST(0x00000000000067FB AS BIGINT)

reveals the number 26619, which roughly means this record has been edited 26619 times.

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources