SqlLite - date
Kim Martel
kim at martel.com.au
Sun Apr 4 10:51:32 UTC 2021
Thanks for the reply Mike
I have tried
Calculate #FD as 'D.M.Y' in the statup task and it makes no difference
I agree it seems to be taking 20 from 2021 and putting it as the date part!
Interesting I just open the same SQLite data file with the OS10.1 library
and it read the dates correctly.
So it is something to do with reading the data back from the data file with
10.2!
Regards
Kim
-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf
Of Mike Matthews - Omnis
Sent: Sunday, 4 April 2021 6:53 PM
To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Subject: Re: SqlLite - date
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>
www.lineal.co.uk<http://www.lineal.co.uk/>
www.sqlworks.co.uk<http://www.sqlworks.co/>
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
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<mailto:kim at martel.com.au>
--
This email has been checked for viruses by AVG.
https://www.avg.com
_____________________________________________________________
Manage your list subscriptions at
https://linkprotect.cudasvc.com/url?a=http%3a%2f%2flists.omnis-dev.com&c=E,1
,ydca4WCu9UmpYqw4mYUOGkV6vTexOGJIHvk5HPZ6ll-zDwNDqS1jOTE3u8XCm24uR9D_uYH4iJo
Oc4NFaHGSWIDuOGuxa3dtIf-BMvFc-XY4&typo=1
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new
message -> mailto:omnisdev-en at lists.omnis-dev.com
--
This email has been checked for viruses by AVG.
https://www.avg.com
More information about the omnisdev-en
mailing list