[Gambas-user] Using dates in Gambas

Bruce adamnt42 at gmail.com
Wed May 22 01:58:58 CEST 2019

Don't know if this helps but... Some few years ago I had a similar 
problem with sqlite3. In the end I got around it by sending dates as 
strings formatted as "yyyy-mm-dd hh:nn:ss" e.g. "2014-07-07 00:00:00". 
That was the only format that that version of sqlite3 understood.

On 22/5/19 6:37 am, Benoît Minisini wrote:
> Le 21/05/2019 à 20:50, David Silverwood via User a écrit :
>> Hi Benoit
>> It will be great if you can explain the database date handling because 
>> I can for the life of me not get Gambas to keep a sqlite date in 
>> sqlite format. (when loading from the database). Tried Str$, Format$, 
>> etc and no luck to date. It defaults to US format no matter what I 
>> try. I thought it had to do with my regional settings but Gambas 
>> apparently reads that perfectly when using
>> Print System.TimeZone
>> Print System.Language
>> last try Gambas complained as follows:
>> The following error has occurred:
>> Type mismatch: wanted Date, got String instead
>> (PS. I wanted a "date" as a string and not a date, in the hope that 
>> gambas would leave it alone...)
>> I'm about ready to give up here...
>> Many thanks
>> David
> Have you read the wiki page I started to write?

More information about the User mailing list