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

CC Date format code defaults to current centry

From: Joe Brown <joebrown(at)rclooke(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: CC Date format code defaults to current centry
Date: 2005-03-08 17:40:02
Message-ID: 422DE372.1080303@rclooke.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
joe=> select to_date('19450323','CCYYMMDD');
  to_date  
------------
 2045-03-23
(1 row)

joe=> select to_date('19450323','YYYYMMDD');
  to_date  
------------
 1945-03-23
(1 row)

I thought the former would be "more" correct.  But it seems I am mistaken.

Responses

pgsql-bugs by date

Next:From: Ezequiel TolnayDate: 2005-03-09 02:09:22
Subject: BUG #1532: typecast problem between arrays of an int8 derived datatype and varchar[]
Previous:From: Gill, Jerry T.Date: 2005-03-08 17:31:03
Subject: Re: BUG #1528: Rows returned that should be excluded by WHERE clause

pgsql-patches by date

Next:From: Mark KirkwoodDate: 2005-03-08 22:33:02
Subject: Re: Display Pg buffer cache (WIP)
Previous:From: Tom LaneDate: 2005-03-08 14:55:56
Subject: Re: Display Pg buffer cache (WIP)

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