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

[bugtracker at gambaswiki.org]

http://gambaswiki.org/bugtracker/edit?object=BUG.2239&from=L21haW4-

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.