[gnome-db] GDate, GdaTimestamp && sqlite
- From: Massimo Cora' <maxcvs email it>
- To: gnome-db list <gnome-db-list gnome org>
- Subject: [gnome-db] GDate, GdaTimestamp && sqlite
- Date: Thu, 25 Jun 2009 01:04:42 +0200
-----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-----
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]