Received: from cadillac.gaiam.com ([63.74.106.78]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f93KcSn05895 for ; Wed, 3 Oct 2001 16:38:28 -0400 (EDT) (envelope-from jason.servetar@ccgenesis.com) Received: by CADILLAC with Internet Mail Service (5.5.2653.19) id ; Wed, 3 Oct 2001 14:22:12 -0600 Message-ID: <309339290B4FD31184BC0060B06888CB01D0FDF2@CADILLAC> From: jason.servetar@ccgenesis.com To: pgsql-sql@postgresql.org Subject: to_date/to timestamp going to BC Date: Wed, 3 Oct 2001 14:22:10 -0600 X-Mailer: Internet Mail Service (5.5.2653.19) X-Archive-Number: 200110/37 X-Sequence-Number: 4992 Can someone tell me if this is a bug with the date functions or am I using them incorrectly? If anyone has a workaround for this I could use some help this data conversion. dev=> create table test_date (dt varchar(100)); CREATE dev=> insert into test_date values ('March 11, 1997'); INSERT 706020 1 dev=> select dt, to_date(dt, 'Month dd, yyyy'), to_timestamp(dt, 'Month dd, yyyy') from test_date; dt | to_date | to_timestamp ----------------+---------------+--------------- March 11, 1997 | 0001-03-19 BC | 0001-03-19 BC drw_dev=> select version(); version ---------------------------------------------------------------- PostgreSQL 7.1 on sparc-sun-solaris2.6, compiled by GCC 2.95.2 (1 row)