Postgres Timezone Info
daniel —Fri, 05/06/2016 - 9:24am
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