Skip to content

Instantly share code, notes, and snippets.

@dreamr
Created September 24, 2013 23:48
Show Gist options
  • Save dreamr/6692958 to your computer and use it in GitHub Desktop.
Save dreamr/6692958 to your computer and use it in GitHub Desktop.
CREATE OR REPLACE FUNCTION GETUTCDATE() RETURNS TIMESTAMP AS '
SELECT CAST(LOCALTIMESTAMP AT TIME ZONE ''UTC'' AS TIMESTAMP);
' LANGUAGE SQL VOLATILE;
GETUTCDATE();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment