[Gambas-user] Postgresql date question

richard terry rterry at ...1822...
Thu Jul 17 23:51:59 CEST 2008


Hi to postgres users of gambas.

I'm passing some information to postges, which gets the data from date type

eg date1 as date
     data2 as date

(N 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')

I wondered if anyone could volunteer a solution

Regards

Richard




More information about the User mailing list