Solve the problem of Delphi inserting date into 1899-12-30 day in SQLite.

The Short date format "yyyy/m/d" of the Win7 system that produces the reason is used with the DATETIMETOSTR (now) function when inserting the current date into the date format field in Sqlit.

This value can sometimes become a 1899-12-30 in a SQLite table. To resolve this issue, set the program's time format in the Create event of the main form, and set the

Application.updateformatsettings: = False; causes the program to be unaffected by the system time format.

Application.updateformatsettings: = False;
Set the date time format used by the program itself
longdateformat:= ' YYYY-MM-DD ';
shortdateformat:= ' YYYY-MM-DD ';
longtimeformat:= ' Hh:nn:ss ';
shorttimeformat:= ' Hh:nn:ss ';
dateseparator:= '-';
timeseparator:= ': ';

Solve the problem of Delphi inserting date into 1899-12-30 day in SQLite.