Skip to content

Instantly share code, notes, and snippets.

@davidsheardown

davidsheardown/MS-SQL Return Epoch Unix Timestamp.sql

Created August 17, 2022 07:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save davidsheardown/1a0842007625472e4778eb9b54f639fc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save davidsheardown/1a0842007625472e4778eb9b54f639fc to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. davidsheardown created this gist Aug 17, 2022.
    1 change: 1 addition & 0 deletions MS-SQL Return Epoch Unix Timestamp.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    SELECT DATEDIFF(SECOND,'1970-01-01', GETUTCDATE()) AS 'UnixEpochTimestamp';