BowerStudios.com

  • My Lab
  • Family
  • Friends
  • Professional
  • About
Home

Postgres Timezone Info

daniel —Fri, 05/06/2016 - 9:24am

  • SQL

Postgres stores time in UTC, if you want to see the value of a date for a particular timezone, use one of the following:

SELECT now() AT TIME ZONE current_setting('TimeZone');
SELECT now() AT TIME ZONE 'EST5EDT';
SELECT now() AT TIME ZONE 'UTC';

  • Log in to post comments

Navigation

  • Search
  • Recent content
  • Contact Me
  • Mail
  • Pass Hasher
  • Bower Studios Admin

Quotes

daniel —Mon, 02/26/2007 - 12:19pm

Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety.

  • Log in to post comments
  • daniel's quotes

Popular content

Last viewed:

  • Excellent MySql Backup Utility
  • Connecting to an SSL enabled Postgres Server with Oracle Sql Developer
  • Gummy Bear!
  • Spring Security - Ant Path Style Syntax
  • HiDpi and Linux

Copyright 2019 Daniel Bower
  • My Lab
  • Family
  • Friends
  • Professional
  • About