Skip to content

Instantly share code, notes, and snippets.

@nypgand1

nypgand1/gist:6511222

Created September 10, 2013 15:37
Show Gist options
  • Save nypgand1/6511222 to your computer and use it in GitHub Desktop.
Save nypgand1/6511222 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
CREATE TABLE TestTime(time TIMESTAMP WITH TIME ZONE);
SET SESSION TIME ZONE '+8';
INSERT INTO TestTime VALUES (to_timestamp('Fri 21 Nov 2003 19:00', 'Dy DD Mon YYYY HH24:MI'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment