R: SqlLite - date

[Giacomo Manzoli]

Hi Kim,

there are some faults related to the SQLite DAM (ST/*L/46 and ST/*L/47), maybe it’s related to one of those.

Regards,

Giacomo Manzoli
Ricerca & Sviluppo
_____________________________________
888 Software Products S.r.l.
Viale Combattenti Alleati d’Europa, 35
45100 Rovigo – Italia
Tel. +39 0425.471240
Fax +39 0425.471239
www.888sp.com<http://www.888sp.com/>

Da: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> per conto di Kim Martel <kim at martel.com.au>
Data: domenica, 4 aprile 2021 10:25
A: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Oggetto: SqlLite - date
Running win10 I have just converted a local SQLite Table from 10.1 to 10.2
and noticed that all the dates have changed.  They are all the 20th of the
respective month.

On editing the dates to the correct date after updating they reverted to the
20th of respective month.

I deleted the table and remade table and inserted a date and again after
inserting it became the 20th April.

Main data is in a postgres date file and there is no problems with the
dates.



Has anyone else had this problem with SQLite and/or do you have to change a
setting so the date is recognised correctly.

Or is it a bug



Regards

Kim



Kim Martel

Syfever Pty Ltd

41 Cooper St

Cootamundra

NSW 2590

Mob     0409 424100

Email     kim at martel.com.au





--
This email has been checked for viruses by AVG.
https://www.avg.com
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com