[gnome-db] SQLite provider and GdaTimestamp (4.2.2)
- From: Piotr Pokora <piotrek pokora gmail com>
- To: gnome-db list <gnome-db-list gnome org>
- Subject: [gnome-db] SQLite provider and GdaTimestamp (4.2.2)
- Date: Mon, 29 Nov 2010 18:41:29 +0100
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]