how to check now() falls between two specific dates?
14,308
WHERE NOW() BETWEEN date_from AND date_to
Author by
Vijay
Follow me on twitter @vijaycbe If you like quotes, have a try!!! SOreadytohelp
Updated on June 14, 2022Comments
-
Vijay almost 2 years
I've a announcement table with the structure,
Msgid int, title varchar(150) message text date_from datetime date_to datetime
I've want to list all the announcements which will be due today (i.e) announcements of which today's date falls b/w date_from and date_to.
any ideas?