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?
Saving time with . as separator
Re: Saving time with . as separator
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.
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
Than you. That solved it.
Re: Saving time with . as separator
Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.