Re: bizarre AGE behaviour

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: DHS Webmaster <webmaster(at)dhs-club(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: bizarre AGE behaviour
Date: 2004-03-04 16:57:39
Message-ID: 200403040857.39605.scrawford@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wednesday 03 March 2004 3:19 pm, Tom Lane wrote:
> Steve Crawford <scrawford(at)pinpointresearch(dot)com> writes:
> > US Daylight Saving Time starts this year on April 4 when 0200
> > jumps to 0300. The answers PostgreSQL gave are correct.
>
> I suspect what the OP wants is non-timezone-aware behavior...

You are probably right. In his original post he posited that the
problem was due to some sort of leap-year bug in PostgreSQL. I was
just pointing him to the real cause of his observations so he could
tackle whatever problem he was having secure in the knowledge that PG
was working correctly.

Cheers,
Steve

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message DHS Webmaster 2004-03-04 18:40:06 Re: bizarre AGE behaviour
Previous Message Mark Lubratt 2004-03-04 06:01:57 Re: Multiple inserts without COPY