Devart Forums

Hello Devart Team, I have a Problem with Datetime Format and SQLITE.

- Drop UniConnection + SQLite Provider on Form.
- Drop UniQuery on Form

enter

select current_timestamp as d1,datetime('now') as d2 ,datetime('now','localtime') as d3

in Uniquery SQL and open result in Dataeditor.

When connection is in Direct=false mode, everything is fine, and all three values are as expected.
After changing Connection to Direct=true, the d3 value is something like '58357-1403576-02 20:44:32', completely strange.

Is this a Bug or am I missing something here ?

I am using UniDAC 4.6.11 / XE3

thanks
MV

Hello,

Thank you for the information. We have reproduced the problem and will fix it as soon as possible.