i have milliseconds equal to zero when I reconnect to my SQLite Database, and try to read DATETIME field, where I set milliseconds previously too. When I put milliseconds from a SQLite client to the same table, they are retained. Is it expected behaviour?
My code snippet:
Code: Select all
Edit;
FieldByName('Updated').AsSQLTimeStamp := DateTimeToSQLTimeStamp(Modified);
Post;