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

Re: datetime error?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: datetime error?
Date: 2002-01-02 16:35:08
Message-ID: 4556.1009989308@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> writes:
>  I start fix my bug with "YY vs. zero" in formatting.c, and before it
>  a see current CVS:

> test=# select to_timestamp('10-10-2001', 'MM-DD-YYYY');
>       to_timestamp
> ------------------------
>  2001-10-10 00:00:00+02
> (1 row)

> test=# select to_date('10-10-2001', 'MM-DD-YYYY');
>   to_date
> ------------
>  2001-10-09
>          ^^

Hmm, is 2001-10-10 a daylight-savings transition day in your timezone?
Although I thought we'd fixed all those bugs ... and I don't see any
corresponding problem here.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-01-02 16:41:08
Subject: Re: how to watch parse/plan trees
Previous:From: Tom LaneDate: 2002-01-02 16:31:16
Subject: Re: Feature proposal: generalizing deferred trigger events

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