[Gambas-devel] SHOW STOPPER: GB3, sqlite3 and date fields

[Kadaitcha Man]

sqlite3 correctly displays dates:

sqlite> select LogdtTimestamp from log limit 10;
9/7/2008 20:22:04
9/7/2008 20:26:03
9/7/2008 20:41:29
9/7/2008 20:59:48
9/7/2008 21:35:02
9/7/2008 21:37:37
9/7/2008 22:02:28
9/7/2008 22:26:49
9/7/2008 22:29:20
9/7/2008 22:38:10

Attachment Screenshot-1.png shows the date as Gambas3 interprets it,
which is plainly wrong.

I have checked the data with sqlite3 and with sqlitebrowser, and in
both cases the dates are displayed correctly.

Also attached is a database and supporting code showing the problem.
In short, the dates returned by Gambas are gobbledegook.

I have confirmed that the problem also exists in gb2.

Environment is Ubuntu 9.10.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot-1.png
Type: image/png
Size: 36787 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/devel/attachments/20091214/a3e2f18d/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GB3_sqlite_dates.tar.gz
Type: application/x-gzip
Size: 11080 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/devel/attachments/20091214/a3e2f18d/attachment.bin>