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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-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

Browse pgsql-bugs by date

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

Browse pgsql-patches by date

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