[gnome-db] SQLite provider and GdaTimestamp (4.2.2)
Piotr Pokora <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <[email protected]> |
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