How to convert a Timestamp field value into a Datetime value

vivek4121

Hi All,

Can anyone help me in that:

How to convert a Timestamp field value into a Date time value in SQL

Thanks
Vivek

Slawek_Guzek

Hi,

The timestamp is NOT a date/time value. This is just ever-increasing big integer value, with no meaning behind it.

Slawek

xStepa

Hi, these datatypes are not equivalent - use BigInt instead.

SELECT convert(varchar, convert(bigint, RecordTimestamp)) as bigI_RecordTimestamp, * FROM ...

Slawek_Guzek

Hi,

The timestamp is NOT a date/time value. This is just ever-increasing big integer value, with no meaning behind it.

Slawek