SQLite default datetime rounded to minutes

[m227]

Hi,
I have a table field defined in my table in such manner:

Code: Select all

Created      DATETIME DEFAULT (datetime('now','localtime'))

The problem is that when I insert new record it always rounds time part to whole minutes. The issue does not occur when I insert record directly from SQLite client. I must admit that to have backward compatibility with other DAC-s I use dated UniDAC (v6.1).

[ViktorV]

Unfortunately we could not reproduce the issue on the latest UniDAC 7.0.2 version.
Please make sure that the issue is reproduced on the latest UniDAC 7.0.2 version. If it is, please compose a small sample demonstrating the described behavior and send it using the contact form https://www.devart.com/company/contactform.html including scripts for creating database objects. Also, please specify the used IDE version.