How to convert a Timestamp field value into a Datetime value

vivek4121vivek4121 Member Posts: 165
Hi All,

Can anyone help me in that:

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

Thanks
Vivek

Best Answer

Answers

  • xStepaxStepa Member Posts: 106
    Hi, these datatypes are not equivalent - use BigInt instead.
    SELECT convert(varchar, convert(bigint, RecordTimestamp)) as bigI_RecordTimestamp, * FROM ...
    
    Regards
    xStepa
Sign In or Register to comment.