Hi Bob,
In my tables I just have a default value of now() for my time.
So
CREATE TABLE t1(
c1 text,
time timestamp NOT NULL DEFAULT now()
);
Insert into t1 values ('a');
Colin
>-----Original Message-----
>From: pgsql-novice-owner@postgresql.org
>[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Robert Morgan
>Sent: 20 May 2004 22:56
>To: postgres
>Subject: [NOVICE] timestamp error
>
>
>Hi I have a form that inserts data to the DB. One field is timestamp
>type this field is not always filled out but postgres wont
>accept '' or
>null and gives the error (or maybe php gives the error)..
>
>query failed: ERROR: Bad timestamp external representation '' in....
>
>any ideas appreciated
>
>Bob
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to
>majordomo@postgresql.org
>