I am having problem comparing dates using SQL.
I have a table with a field called 'order_date'. The field is a 'date/time' data type and contains the date and time like '15/4/2004 0:09:48'. What I am trying to do is to display all the records that contains today's date.
SELECT * FROM orders WHERE order_date LIKE Date();