Re: updating table where one date field is null

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

In response to

Browse pgsql-novice by date

  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