datetime decode error in sqlite table

[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

[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

[sandy771]

Thanks maxim

Example sent

[MaximG]

Sorry, You can send to maximg*devart*com

[sandy771]

Hi Maxim - have you received it?

[MaximG]

We received your test sample. We will investigate this behavior and inform you about the results.

[sandy771]

Lovely - thank you

[sandy771]

Morning

Any news on this - have you managed to reproduce it?

[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.

[sandy771]

Thank You - any rough idea of when the next release will be out?

[MaximG]

We plan to release the new version of UniDAC within 1-2 months.

[sandy771]

Thank you