How to retrieve DateTime from a Timestamp column in a table in SQL?

Question

I am using following query but it doesn't provide any meaningful output:

Select Cast(versionno as bigint) from BranchDetail

The value in Version column is like this : 0x000000000D2537F7

@TimSchmelter No its not. My columns has value like '0x000000000D2537F7' — Prakash Vishwakarma, Jan 28 '14 at 13:25
The hex value converted to a long and interpreted as a unix epoche timestamp yields `Sun, 26 Oct 2081 06:57:52 GM`. Would that be what you expected? — Ralf, Jan 28 '14 at 13:53

score 1 · Accepted Answer · edited May 23 '17 at 11:56

1

A TIMESTAMP has nothing to do with date and time. See this question. It is a ROWVERSION, not a date/time value.

edited May 23 '17 at 11:56

Community

answered Jan 28 '14 at 14:01

Paul Williams

1 Answers1