Saving time with . as separator 2

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
davor.TCS
Posts: 29
Joined: Thu 05 Apr 2012 22:10
Contact:

Saving time with . as separator 2

Post by davor.TCS » 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

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Saving time with . as separator 2

Post by MaximG » 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

davor.TCS
Posts: 29
Joined: Thu 05 Apr 2012 22:10
Contact:

Re: Saving time with . as separator 2

Post by davor.TCS » 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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Saving time with . as separator 2

Post by MaximG » Wed 12 Jan 2022 17:06

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

davor.TCS
Posts: 29
Joined: Thu 05 Apr 2012 22:10
Contact:

Re: Saving time with . as separator 2

Post by davor.TCS » 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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Saving time with . as separator 2

Post by MaximG » Wed 26 Jan 2022 11:29

We have reproduced the issue and will investigate its origin.

Post Reply