From: | richard terry <rterry(at)gnumed(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: updating table where one date field is null |
Date: | 2008-07-18 00:58:38 |
Message-ID: | 200807181058.38293.rterry@gnumed.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Fri, 18 Jul 2008 08:34:14 am Stephan Szabo wrote:
> On Fri, 18 Jul 2008, richard terry wrote:
> > I'm passing some information to postges (from gambas basic), which gets
> > the data from date type
> >
> > eg date1 as date
> > date2 as date
> >
> > (IN the postgres database the default on the date field is null)
> >
> > my problem is that postgres baulks when I"ve not put a date into one of
> > the gambas date variables with the message:
> >
> > "invalid syntax for type date '00:00:00'"
> >
> > my sql is far more complex but reduced to the date part reads something
> > like this
> >
> > insert into mytable (date1, date2) values
> >
> > ('01/01/2008','00:00:00')
>
> '00:00:00' isn't a date. Are you sure that the second isn't meant to be a
> time?
Interesting observation, I'll ask on the gambas list. In gambas one declares a
date type as per the above, and the 00:00:00 is obviously the default of an
empty date for some reason (or as you say date/time). Thanks for replying, at
least this puts me on a track.
Regards
Richard
From | Date | Subject | |
---|---|---|---|
Next Message | David Gardner | 2008-07-18 01:41:13 | tracking down idle transactions in pg_locks |
Previous Message | Stephan Szabo | 2008-07-17 22:34:14 | Re: updating table where one date field is null |