Postgres Pro
Downloads
Home   >   mailing lists

postgres UTC different from perl? - Mailing list pgsql-general

From Louis-David Mitterrand
Subject postgres UTC different from perl?
Date
Msg-id 20071219193128.GA13328@apartia.fr
Whole thread Raw
Responses Re: postgres UTC different from perl?
List pgsql-general
Tree view 
Hi,

when trying:

psql template1 -c "select  date_part('epoch',current_date at time zone 'UTC');"
date_part
------------
1198015200

the result is different from

perl -MDateTime -le 'print DateTime->today(time_zone => "UTC")->epoch;'
1198022400

Is there an issue with postgresql?

pgsql-general by date:

Previous
From: "Matt Magoffin"
Date:
Subject: Re: Way to avoid expensive Recheck Cond in index lookup?
Next
From: Reg Me Please
Date:
Subject: Rich LIKE inheritance