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

[Rodrigo Moya <rodrigo gnome-db org>]

On Mon, 2002-01-07 at 17:55, Malerba_Vivien stna dgac fr wrote:
> 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.
> 
perfect! thanks Vivien.

> Right now I'm busy making gASQL a better tool (the core is almost
> redesigned, more code on the way).
> 
hmm, don't you think it would be better to include all this redesign
into GNOME-DB, as we talked for the merge?

That is, I've implemented GNOME-DB for GNOME 2 so that you can now just
include the gASQL parts as GnomeDbShellComponent's. Or maybe you prefer
to still have gASQL as components but as a separate module in CVS?

cheers
-- 
Rodrigo Moya <rodrigo gnome-db org> - <rodrigo ximian com>
http://www.gnome-db.org/ - http://www.ximian.com/