Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010

    Red face Unanswered: How to query the datetime field in MySQL

    Hi, I am very new to MySQL. I normally work with MS SQL. I am querying a MySQL database via .NET Visual Studio 2005.

    I have a MySQL database which has a datetime field, I am basically trying to retrieve rows that are 24 hours old. i.e need to retrieve yesterday's data.

    I am having real difficulty in finding this where statement.

    Can somebody please help?


  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    please check da manual under Date and Time functions

    if you have trouble choosing the correct function, you may post again | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

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