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)
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)