UNIX_TIMESTAMP in SQL Server

by

If you’re not bothered about dates before 1970, or millisecond precision, just do:

-- SQL Server
SELECT DATEDIFF(s, '1970-01-01 00:00:00', DateField)

Almost as simple as MySQL’s built-in function:

-- MySQL
SELECT UNIX_TIMESTAMP(DateField);

Other languages (Oracle, PostgreSQL, etc): How to get the current epoch time in …

If you need millisecond precision (SQL Server 2016/13.x and later):

SELECT DATEDIFF_BIG(ms, '1970-01-01 00:00:00', DateField)

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. T-SQL split string
  3. How can I get column names from a table in SQL Server?
  4. How can I select the first day of a month in SQL?
  5. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  6. Multi-statement Table Valued Function vs Inline Table Valued Function
  7. SQL Server Insert if not exists
  8. Select statement to find duplicates on certain fields
  9. How to set table name in dynamic SQL query?
  10. Using a Variable in OPENROWSET Query
  11. How to find current transaction level?
  12. How do I see active SQL Server connections?
  13. EXISTS vs JOIN and use of EXISTS clause
  14. Check for file exists or not in sql server?
  15. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  16. Group DateTime into 5,15,30 and 60 minute intervals
  17. Why is a UDF so much slower than a subquery?
  18. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  19. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  20. SQL Server SELECT LAST N Rows
  21. How can I group by date time column without taking time into consideration
  22. The transaction log for the database is full
  23. Generate random int value from 3 to 6
  24. Add emoji / emoticon to SQL Server table
  25. Backup a single table with its data from a database in sql server 2008
  26. COALESCE Function in TSQL
  27. Cannot Resolve Collation Conflict
  28. Try_Convert for SQL Server 2008 R2
  29. Display next event date
  30. Sql query for tree table

Leave a Comment