both field has type datetime
select * from table where datetime('now') between startTime and endTime..
SELECT * FROM table WHERE strftime('%s', date) BETWEEN strftime('%s', start_date) AND strftime('%s, end_date)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)