Re: [sqlite] Date and time comparison

Karthick V - TLS , Chennai wrote: Hello everyone, I am trying to retrieve some records from the database using date and time comparison. The table has three columns, Row Id, Start Time and end Time. I need to get the row id for a time which falls within the start and end time. I am using

[sqlite] Date and time comparison

Hello everyone, I am trying to retrieve some records from the database using date and time comparison. The table has three columns, Row Id, Start Time and end Time. I need to get the row id for a time which falls within the start and end time. I am using this query. select RowID, strftime('