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: 20020304192110.6E83F4764D9@postgresql.org (view raw or flat)
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');
  to_date
------------
 2002-02-01

must be 2002-01-31  !! 
Why???

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


Responses

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-2014 The PostgreSQL Global Development Group