When SQLite is inserted, 0:00:00 appears.

Converts a type when the date is saved to the SQLite database, for example, string _ now = system. datetime. Now. tostring ("S ");

That is to say, adding an s in the. tostring () method and converting it to the ISO 8601 standard string format can solve the problem of date reading errors.

In addition, it is very troublesome to convert the data in this way every time. In particular, we do not operate the datetime column to make it null (null is considered as "1899-12-30 0:00:00 "), when creating a table, we can set this column as non-empty and the initial value: 1899-12-30t0: 00: 00. In this way, we can also recognize the default values of SQLite when we do not operate this column.