Forum > Databases

Tsqlitedataset and time format as hh:mm:ss

<< < (2/2)

LuizAmérico:
Sqlite supports the BETWEEN operator. What i said is that TSqliteDataset, which is a fpc wrapper around sqlite, stores the float value (something like 1,23700000+E10) instead of the textual representation (11:00:00) so it will compare different formats. Maybe this will work (not tested):

'SELECT * FROM calls WHERE starttime BETWEEN '+ FloatToStr(StrToTime('10:11:00'))+
' and '+ FloatToStr(StrToTime('10:12:00'))

Luiz

Anonymous:
Thanks for your help. It's stored in float value and it works fine now on SQLite 2.x.

Sainty

Navigation

[0] Message Index

[*] Previous page