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
  • 732,580
  • 175
  • 1,330
  • 1,459
Mitul Chauhan
  • 49
  • 1
  • 2
  • 9

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
  • 45,440
  • 9
  • 78
  • 110