Received: from kss.net.au ([203.41.122.41]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA38626 for ; Mon, 29 May 2000 01:35:47 -0400 (EDT) (envelope-from carolyn@kss.net.au) Received: from kss.net.au (coco [10.10.1.9]) by kss.net.au (8.8.7/8.8.7) with ESMTP id BAA09467 for ; Tue, 30 May 2000 01:36:44 +1000 Message-ID: <3932022B.92883E9D@kss.net.au> Date: Mon, 29 May 2000 15:37:47 +1000 From: Carolyn Wong X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: date format Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/178 Hi All I'm using V6.5. I need to use the dd/mm/yy format, but the database seems to interpret it as mm/dd/yy, unless the digig >12, then the date format is interpreted as dd/mm/yy. Are there any setting required?