Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Smile Unanswered: SQL Comparing Date Question

    hi again~

    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.

    my SQL:
    SELECT * FROM orders WHERE order_date LIKE Date();
    But it does not return any records to me

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    SELECT * FROM orders WHERE order_date = Date();

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts