Page 1 of 1
datetime decode error in sqlite table
Posted: Sun 26 Jul 2015 15:04
by sandy771
I am using unidac 6.1.3 on builder XE3
I have a sqlite database witha column defined as DATETIME the values written to this column are ISO8601 compliant and are eiter in the form
YYYY-MM-DD HH:MM:SS
or
YYYY-MM-DD HH:MM:SS.SSS
Reading these fields using UniQuery1->FieldByName("date")->AsString
gives either the correct date when no millisecs are present or 30/12/1899 when the date has millisecs
Is there a fix for this in a later version or a work around?
Thanks
Re: datetime decode error in sqlite table
Posted: Mon 27 Jul 2015 09:50
by MaximG
We were unable to reproduce the problem over here. For the following investigation, please send us a small example that demonstrates the problem, including a test DB. You can send to maxing*devart*com
Re: datetime decode error in sqlite table
Posted: Mon 27 Jul 2015 10:29
by sandy771
Thanks maxim
Example sent
Re: datetime decode error in sqlite table
Posted: Mon 27 Jul 2015 10:39
by MaximG
Sorry, You can send to maximg*devart*com
Re: datetime decode error in sqlite table
Posted: Mon 27 Jul 2015 12:48
by sandy771
Hi Maxim - have you received it?
Re: datetime decode error in sqlite table
Posted: Mon 27 Jul 2015 13:21
by MaximG
We received your test sample. We will investigate this behavior and inform you about the results.
Re: datetime decode error in sqlite table
Posted: Mon 27 Jul 2015 13:25
by sandy771
Lovely - thank you
Re: datetime decode error in sqlite table
Posted: Tue 28 Jul 2015 08:32
by sandy771
Morning
Any news on this - have you managed to reproduce it?
Re: datetime decode error in sqlite table
Posted: Tue 28 Jul 2015 08:52
by MaximG
We have reproduced the problem. It is due to the fact that the datestimes.date field in the provided database contains more than 3 symbols for the milliseconds value. You can ensure this by executing the query:
select cast(date as varchar(100)) from datestimes;
We have fixed processing of such values for milliseconds. The fix will be included in the next UniDAC build.
Re: datetime decode error in sqlite table
Posted: Tue 28 Jul 2015 08:58
by sandy771
Thank You - any rough idea of when the next release will be out?
Re: datetime decode error in sqlite table
Posted: Tue 28 Jul 2015 13:23
by MaximG
We plan to release the new version of UniDAC within 1-2 months.
Re: datetime decode error in sqlite table
Posted: Tue 28 Jul 2015 13:30
by sandy771
Thank you