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

    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?

    Thanks

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

    if you have trouble choosing the correct function, you may post again
    rudy.ca | @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
  •