Re: [gnome-db] gdafield &dbgrid & timestamp

[Malerba_Vivien stna dgac fr]

le ven 04-01-2002  17:09, Rodrigo Moya a écrit :

> > 
> > 
> > the output is:
> > 
> > timedate: 31/12/1969-20:59:59
> > timedate: 31/12/1969-20:59:59
> > timedate: 31/12/1969-20:59:59
> > 
> as you can see, this is almost the same as 0/0/00 (unix time starts in
> 1/1/1970). So, I think the problem is that the provider (in this case,
> gda-postgres) is not converting correctly the timestamp fields.
> 
> In fact, in
> libgda/providers/gda-postgres-server/gda-postgres-recordset.c, in
> fill_field_values function:
> 
> ///////////////////////////////////////////////////////////
> 
> case GDA_TypeDbTimestamp:       /* FIXME */
>                       /* binded to datetime, timestamp, abstime,
> interval/timespan,
>                                    tinterval, reltime */
> //////////////////////////////////////////////////////////
> 
> it seems there is something wrong in that part of the code. Vivien, any
> idea what the problem is?

I'll try to solve this problem tomorrow night.

Right now I'm busy making gASQL a better tool (the core is almost
redesigned, more code on the way).

Cheers,

Vivien

PS: I wish the whole Gnome-DB team a happy new coding year!