Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: David GardnerDate: 2008-07-18 01:41:13
Subject: tracking down idle transactions in pg_locks
Previous:From: Stephan SzaboDate: 2008-07-17 22:34:14
Subject: Re: updating table where one date field is null

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group