Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 1B3F42E0035 for ; Wed, 9 Apr 2008 21:45:35 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 72222-01-6 for ; Wed, 9 Apr 2008 21:45:19 -0300 (ADT) X-Greylist: delayed 00:30:21.003644 by SQLgrey-1.7.5 Received: from mail.eclinic.com.au (mail.eclinic.com.au [203.202.134.251]) by developer.postgresql.org (Postfix) with ESMTP id 040C82E006F for ; Wed, 9 Apr 2008 21:45:16 -0300 (ADT) Received: from mail.eclinic.com.au (preston [127.0.0.1]) by mail.eclinic.com.au (Postfix) with ESMTP id 522FA1000DB6 for ; Thu, 10 Apr 2008 10:14:44 +1000 (EST) Received: from mail.eclinic.com.au (preston [127.0.0.1]) by mail.eclinic.com.au (Postfix) with ESMTP id 3F0401000A2C for ; Thu, 10 Apr 2008 10:14:44 +1000 (EST) Received: from [119.11.68.213] (unknown [119.11.68.213]) by mail.eclinic.com.au (Postfix) with ESMTP id A4B281000DAB for ; Thu, 10 Apr 2008 10:14:43 +1000 (EST) Message-Id: <8817FD2B-5B01-4E3D-9C6D-A6FF165561FB@eclinic.com.au> From: Gavin 'Beau' Baumanis To: pgsql-sql@postgresql.org Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: dateformat issue Date: Thu, 10 Apr 2008 10:14:41 +1000 X-Mailer: Apple Mail (2.919.2) X-AV-Checked: ClamAV using ClamSMTP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/61 X-Sequence-Number: 30600 Hi Everyone, I have a question about dates, please. I am using Coldfusion and Postgres I have a function that takes the ate entered in a form and converts it into an odbc date format. So the string ends up being; {d '2008-04-10'} Strangely, the function is used throughout the application and causes no issues but on one particular template. And this same templates is replicated for other clients - that seemingly have no issue . The SQL is simply Insert into table (datefield) values ({d '2008-04-10'}) Now, I have read the docs and do not see the {d '2008-04-10'} format as being a valid date data type... But it works elsewhere in the application / on other sites - thus my current state of confusion. Thanks in advance for any ideas you might have. Please contact me if you should have any questions. Gavin 'Beau' Baumanis Senior Application Developer PalCare Pty. Ltd. E: beau@palcare.com.au T: +61 -3 9318 4567 M: +61 -4 38 545 586 W: http://www.palcare.com.au