How to select records for today's sqlite?

Question

SQLite

I don't have datetime data type when I select I write it as a string to a table like this
strftime('%d.%m.%Y %H:%M')

Answer 1

If storing as a string, use a format that can be compared:
strftime("%Y-%m-%d %H:%M");

$start = strftime("%Y-%m-%d");
$end = strftime("%Y-%m-%d", strtotitme("tomorrow"));
$db->query("SELECT * FROM tab WHERE time > ='$start' AND time < '$end'");