[gnome-db] SQLite provider and GdaTimestamp (4.2.2)



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


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]