Regarding post: viewtopic.php?f=48&t=30436
I have updated SQLite to latest version 5.0.2.
If time on Windows/Android is set to hh.nn.ss with . as separator, minutes and seconds are 0.
I have used as advised:
Code: Select all
var
FS: TFormatSettings;
begin
FS:= TFormatSettings.Create;
if FS.TimeSeparator = '.' then LiteConn.Options.TimeFormat:='hh.nn.ss';
...
end;
Best regards