Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #607: to_date() function bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #607: to_date() function bug
Date
Msg-id 8182.1015278857@sss.pgh.pa.us
Whole thread Raw
In response to Bug #607: to_date() function bug  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> otdyh=# select to_date(20020200,'YYYYMMDD');
>   to_date
> ------------
>  2002-02-01

> must be 2002-01-31  !!
> 00 day - is the last day of the previous month!

I don't think so.  If anything, this should raise an error.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: BUG: bigint and indexes ?
Next
From: Tatsuo Ishii
Date:
Subject: Re: Encoding Problem?