Page 1 of 1
Saving time with . as separator
Posted: Fri 19 Sep 2014 08:04
by davor.TCS
I have time format on my device defined with . separator. Something like 11.09.14 (11 hours 9 minutes and 14 seconds) for time value. If I try to save that in SQLLite db file it saves me only hour, but seconds and minutes are 0?
Is there any solution for this?
Re: Saving time with . as separator
Posted: Fri 19 Sep 2014 12:24
by AlexP
Hello,
To change date/time format, you should set a corresponding format in the LiteConnection1.Options.DateFormat and LiteConnection1.Options.TimeFormat properties. In your case:
LiteConnection1.Options.TimeFormat := 'hh.mm.ss';
P.S. When displaying in visual components (DBGrid, etc.), date/time data will be displayed in a format defined by the OS.
Re: Saving time with . as separator
Posted: Sat 20 Sep 2014 10:25
by davor.TCS
Than you. That solved it.
Re: Saving time with . as separator
Posted: Mon 22 Sep 2014 05:59
by AlexP
Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.