Re: [Gambas-user] Postgresql date question

2008-07-20 Thread richard terry
On Sun, 20 Jul 2008 08:30:20 am Pino Zollo wrote: > 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) Yes, of course, that work

Re: [Gambas-user] Postgresql date question

2008-07-20 Thread Rolf Schmidt
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 I"ve not put a date

Re: [Gambas-user] Postgresql date question

2008-07-19 Thread Pino Zollo
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

[Gambas-user] Postgresql date question

2008-07-19 Thread richard terry
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 dat