Timestamp Error - 7.2

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: SQL PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Timestamp Error - 7.2
Date: 2002-09-25 01:06:52
Message-ID: 3D910C2C.90802@heart.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kevin Houle 2002-09-25 01:10:03 Re: Dublicates pairs in a table.
Previous Message Bruce Momjian 2002-09-24 21:56:51 Re: [SQL] CURRENT_TIMESTAMP