Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group