On Wed, Dec 19, 2007 at 08:14:17PM -0500, Tom Lane wrote:
Richard Huxton [EMAIL PROTECTED] writes:
I'm not sure that (CURRENT_DATE AT TIME ZONE 'UTC') does what you think
it does. Try setting your timezone to various offsets and exploring.
In fact, I think it's adjusting in exactly the
Louis-David Mitterrand [EMAIL PROTECTED] writes:
On Wed, Dec 19, 2007 at 08:14:17PM -0500, Tom Lane wrote:
Richard Huxton [EMAIL PROTECTED] writes:
I'm not sure that (CURRENT_DATE AT TIME ZONE 'UTC') does what you think
it does. Try setting your timezone to various offsets and exploring.
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?
Louis-David Mitterrand wrote:
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
Richard Huxton [EMAIL PROTECTED] writes:
I'm not sure that (CURRENT_DATE AT TIME ZONE 'UTC') does what you think
it does. Try setting your timezone to various offsets and exploring.
In fact, I think it's adjusting in exactly the wrong direction.
I get the right number from
regression=#