Date arithmetic

02SYSDATE NOW CURDATE

Now

Testing against a date range

Extract Date from Given Date or DateTime Expression

Using an index for a date and time lookup