CSS font stacks & developer FAQs with Web standards
One of hundreds of answers available with our premium content service.
A: To select records by date, your database table must have a DATE or TIMESTAMP field to use in the WHERE condition of the query statement. For example, for a product order table you might have a date_ordered field that is a DATE data type. Secondly, since the SQL query input is submitted as a string, you must cast the two dates to DATE data types, as below, split over several lines for clarity.
… full answer hidden
Premium members click below for full answer
How can I select records between two dates?