Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 432E4476747 for ; Tue, 24 Sep 2002 21:08:41 -0400 (EDT) Received: from gateway.heart.com.au (unknown [202.44.184.121]) by postgresql.org (Postfix) with ESMTP id A18C1476783 for ; Tue, 24 Sep 2002 21:08:39 -0400 (EDT) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gateway.heart.com.au (8.11.6/8.11.2) with ESMTP id g8P1eWI02719 for ; Wed, 25 Sep 2002 11:40:33 +1000 Received: from heart.com.au ([192.168.0.53]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id LAA31003 for ; Wed, 25 Sep 2002 11:08:42 +1000 Message-ID: <3D910C2C.90802@heart.com.au> Date: Wed, 25 Sep 2002 11:06:52 +1000 From: Keith Gray User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3 X-Accept-Language: en-us MIME-Version: 1.0 To: SQL PostgreSQL Subject: Timestamp Error - 7.2 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/311 X-Sequence-Number: 9588 We have moved from 7.1 to 7.2 and get the following error when extracting dates. Bad timestamp external representation ' ' eg. INSERT INTO mytable VALUES('1', '2001-09-24') Seems to accept dd/mm/yyyy (What about ISO default?) -- Keith Gray Technical Services Manager Heart Consulting Services