Devart Forums

Posted: **Mon 21 Aug 2017 15:05**

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

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

Posted: **Wed 23 Aug 2017 11:13**

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.

Devart Forums

SQLite default datetime rounded to minutes

SQLite default datetime rounded to minutes

Re: SQLite default datetime rounded to minutes