[Gambas-bugtracker] Bug #3048: gb.db2 Type mismatch: wanted Date, got String instead.

[<bugtracker@xxxxxxxxxxxxxx>]

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

Comment #6 by Omar MORENO:

After reviewing the behavior of date fields with the BETWEEN command, I realized that the query results depend on how the data was inserted.

When records are created through Gambas, the queries must match formats such as:
- YYYY-MM-DDT050000Z
- YYYY-MM-DDT000000.000Z

This difference occurs because each tool enforces its own date representation.
Gambas IDE requires localized formats, while SQLiteStudio allows ISO 8601 variants.

Due to these inconsistencies, I generally avoid relying on SQLite for projects where consistent and predictable date handling is critical.

Omar MORENO changed the state of the bug to: Accepted.



----[ Gambas bugtracker-list is hosted by https://www.hostsharing.net ]----