[gnome-db] GDate, GdaTimestamp && sqlite

Massimo Cora' <[email protected]>
Newsgroups gmane.comp.gnome.db
Message-ID <[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.

How can be performed that?
Right now I'm using an hack like

select analyse_time||'' as analyse_time_str from foo;

which is seen as a parseable string.
I'm using libgda git head.

thanks and regards,
Massimo
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkpCsP8ACgkQcfVTgMRILk0ikQCeOmhFEDygUost7Rqk4iRJXmSi
GlIAoIb2JMMJhM9tNPo7A7jQR4OCZZhW
=/Ka2
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.