[Gambas-user] Using dates in Gambas
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
> Have you read the wiki page I started to write?
More information about the User