Re: Bug #791: Error when inserting timestamp 2002-10-13 00:00:00

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: zuchi(at)fusionsoftware(dot)com(dot)br, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #791: Error when inserting timestamp 2002-10-13 00:00:00
Date: 2002-09-30 18:46:37
Message-ID: 23695.1033411597@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> When I try to insert in a field of the type timestamp value 2002-10-13 00:00:00 occurs this value is modified for 2002-10-12 23:00:00

(a) what timezone are you running in?

(b) does it happen on only that date? If so, is that a daylight-savings
transition day in your timezone?

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Venkatesh Phadnavis 2002-10-01 01:58:37
Previous Message pgsql-bugs 2002-09-30 18:20:15 Bug #791: Error when inserting timestamp 2002-10-13 00:00:00