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

Bug #607: to_date() function bug

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #607: to_date() function bug
Date: 2002-03-04 19:21:10
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
Nurlan Mukhanov (nurlan(at)otdyh(dot)kz) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
to_date() function bug

Long Description
otdyh=# select to_date(20020200,'YYYYMMDD');

must be 2002-01-31  !! 

00 hours 00 minutes 00 seconds - next day or last day???
last day!!!

2000 year is 20 century or 21 century? - 20!!

same here!
00 day - is the last day of the previous month!

Sample Code

No file was uploaded with this report


pgsql-bugs by date

Next:From: Stephan SzaboDate: 2002-03-04 21:00:32
Subject: Re: BUG: bigint and indexes ?
Previous:From: Riendeau, MikeDate: 2002-03-04 19:12:45
Subject: Re: Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com

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