Re: [gnome-db] GDate, GdaTimestamp && sqlite

2009/6/25 Massimo Cora' <[email protected]>

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> say I've the following table on sqlite.
>
> create table foo (analyse_time DATE);
>
> and say that I populate its elements with
>
> insert into foo values (datetime ('now', 'localtime'));
>
> A select shows me this:
>
> sqlite> select * from foo;
> 2009-06-25 01:00:21
>
> But when I'm getting the GValue from the GdaDataModel I cannot use it as
> a GdaTimestamp. The only GType detected is GDate, but I need the time too.
>

2 solutions:
* if you can, use the timestamp type instead of date in the table
declaration: create table foo (analyse_time timestamp);
* specifically request that the GType for the "analyse_time" column must be
GDA_TYPE_TIMESTAMP when running the SELECT statement, using
gda_connection_statement_execute_select_full()

Regards,

Vivien

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list