SQLite, Date and Time

[isysoftware]

Hi All,
In a Sqlite DB I need to save a date and a time:
Example:
In_date: 08/04/2014
In_Time: 15:00
Out_Time: 18:00

My questions:
What kind of db type I need for Date and/or Time field?
Can I retrive Date and/or Time with aQ.fieldbyname('mydate').asDatetime? I need conversions?

Thanks,
Flavio

[AlexP]

Hello,

To work with date and time in SQLite, you can use the DATETIME type, and you will be able to work with the fields in Delphi using the AsDAteTime property with no need to convert them.