Hi!
I have problem with GdaTimestamp values and SQLite provider.
When GdaTimestamp value is set using gda_holder_set_value (),
query is generated like:
UPDATE tbl SET
col_a = '0001 01 01 00:00:00+0',
col_b = '2010 11 29 17:12:14+0'
Query is executed, without error. Record is created.
However, when I try to select this record, warning is thrown:
Can't convert ' 1-01-01 00:00:00' to a timestamp
Why dashes are ignored for GdaTimestamp values?
col_a = '0001-01-01 00:00:00+0' works fine, when I try it with SQLite
directly.
Piotras
_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list