[Gambas-bugtracker] Bug #2239: Connection. connection form: SQL requests panel malfunction with date

bugtracker at gambaswiki.org bugtracker at gambaswiki.org
Sun Jun 13 22:28:05 CEST 2021


Comment #5 by Benoît MINISINI:

Are you sure that your SQL requests are supported by SQLite? As far as I know, SQLite does not have a date type. Everything is stored as string or floats, and so I don't know what the effect of your request could be.

In the SQLite Gambas database driver, dates are replaced by strings in the format "YYYY-MM-DD HH:MM:SS.UUU", which order follows the data/time order.

Benoît MINISINI changed the state of the bug to: NeedsInfo.

More information about the Bugtracker mailing list