SQl Server timestamp conversion

Asked Jul 27 '20 at 13:48

Active Jul 27 '20 at 13:48

Viewed 146 times

I am having a rows of data with the timestamp value as mentioned below:

Is there any possibility to convert them into proper datetime as dd/mm/yyyy hh:mm:ss?

I tried using cast but ended up with the below errors:

same error message for both the query,

Conversion failed when converting datetime from binary/varbinary string.

Conversion failed when converting date and/or time from character string.

asked Jul 27 '20 at 13:48

Dhairya Doshi

1

What does a value sych as `0x00000000120431EB` mean? How was it produced? – The Impaler Jul 27 '20 at 13:50
2

No - the datatype has no relationship to dates or times – SMor Jul 27 '20 at 13:50
2

https://stackoverflow.com/questions/8119386/how-to-convert-sql-servers-timestamp-column-to-datetime-format – Mike Lum Jul 27 '20 at 13:51
1

`timestamp` does not mean some kind of time. `timestamp` is a (deprecated) synonym of `rowversion`. You can't convert a `timestamp` to a date and time datatype, as it has nothing to do with dates or times. – Thom A Jul 27 '20 at 13:52
I got this value when i attache the database from a backup. – Dhairya Doshi Jul 30 '20 at 09:11