Devart Forums

Posted: **Wed 15 Dec 2021 12:18**

Hello,

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;

but then I get minutes resolved but seconds are now 0? Like it is some Short/Long Time Format issue?

Best regards

Posted: **Wed 29 Dec 2021 18:24**

Thank you for the information. Please send us a sample project where the issue can be reproduced. For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

Posted: **Tue 11 Jan 2022 17:44**

No problem, I have sent you a small project, but be advised. To view problem, you must save Now value and then restart application.
If I created "now" value record as 18.37.43, next time when I run app it will be shown as 18.37.00.

Posted: **Wed 12 Jan 2022 17:06**

Thank you for the information. We will investigate the described issue and let you know the results shortly.

Posted: **Sun 23 Jan 2022 09:28**

Hello, I have received yours reply (but it went to spam) so today I have sent you a new email. Please, take care to set testing environment in yours Windows according to problem.

Posted: **Wed 26 Jan 2022 11:29**

We have reproduced the issue and will investigate its origin.

Devart Forums

Saving time with . as separator 2

Saving time with . as separator 2

Re: Saving time with . as separator 2

Re: Saving time with . as separator 2

Re: Saving time with . as separator 2

Re: Saving time with . as separator 2

Re: Saving time with . as separator 2