SqlLite - date

Mike Matthews - Omnis omnis at lineal.co.uk
Sun Apr 4 08:52:37 UTC 2021

Hello Kim,

Sounds like the Century part is getting in the way, so check the format first, D-M-y etc.

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>



On 4 Apr 2021, at 09:25, Kim Martel <kim at martel.com.au<mailto:kim at martel.com.au>> wrote:

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

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



Kim Martel

Syfever Pty Ltd

41 Cooper St


NSW 2590

Mob     0409 424100

Email     kim at martel.com.au<mailto:kim at martel.com.au>

This email has been checked for viruses by AVG.
Manage your list subscriptions at https://linkprotect.cudasvc.com/url?a=http%3a%2f%2flists.omnis-dev.com&c=E,1,ydca4WCu9UmpYqw4mYUOGkV6vTexOGJIHvk5HPZ6ll-zDwNDqS1jOTE3u8XCm24uR9D_uYH4iJoOc4NFaHGSWIDuOGuxa3dtIf-BMvFc-XY4&typo=1
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com

More information about the omnisdev-en mailing list