Received: from bond.goldwiretech.com (bond.goldwiretech.com [63.150.239.226])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f8AEV8743792
	for <pgsql-docs@postgresql.org>; Mon, 10 Sep 2001 10:31:08 -0400 (EDT)
	(envelope-from azaitsev@goldwiretech.com)
Received: from XXX.goldwiretech.com (xxx [10.0.0.151])
	by bond.goldwiretech.com (8.9.3/8.9.3) with ESMTP id KAA22295;
	Mon, 10 Sep 2001 10:29:24 -0400
Message-Id: <5.1.0.14.0.20010910101921.01b549f8@mail.goldwiretech.com>
X-Sender: azaitsev-pop@mail.goldwiretech.com
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Mon, 10 Sep 2001 10:29:21 -0400
To: pgsql-docs@postgresql.org
From: Alexander Zaitsev <azaitsev@goldwiretech.com>
Subject: Two digits year formatting
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Archive-Number: 200109/18
X-Sequence-Number: 950

Hello:

Is there any way to make Postgres think of the year '00' as of the year 
2000 during the to_date function execution?

I tried following:
select to_date('01/01/00', 'MM/DD/YY');
select to_date('01/01/00', 'MM/DD/RR');

In both cases the result is 0001-01-01 BC

Thanks.

Alexander Zaitsev
azaitsev@goldwiretech.com

PS. The document 
http://www.postgresql.org/idocs/index.php?functions-formatting.html does 
not provide with the solution.