Hi Richard
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 Ive not put a date into one
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 Ive not put a date into one of the
gambas
Alle 17:51, giovedì 17 luglio 2008, richard terry ha scritto:
insert into mytable (date1, date2) values
('01/01/2008','00:00:00')
What about
insert into mytable (date1, date2) values ('01/01/2008', NULL)
Maybe you want the type timestamp ...which is the set of a date and a time.
Good luck