1

I am working with a query in SQL Server:

select datetimevalue 
from temp;

Here datetimevalue column's datatype is datetime2 and I need to convert this value into timestamp.

In MySQL if I simply write: 

select UNIX_TIMESTAM(datetimevalue) 
from temp;

then it returns timestamp.

Is there any way to convert datetime in timestamp explicitly in SQL Server 2014?

marc_s
  • 704,970
  • 168
  • 1,303
  • 1,425
Mitul Chauhan
  • 49
  • 1
  • 2
  • 8

1 Answers1

1

SQL Server doesn't have a timestamp type. It used to have one in old versions but that type IS NOT a date & time value. In current versions timestamp is a deprecated synonym for rowversion.

Amit
  • 43,881
  • 8
  • 73
  • 106