Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    5

    Unanswered: Searching for a specific 'date = tomorrow' query

    Hi,

    I've read chapter 12.5 of the MySQL manual but I can't find (or perhaps overread) the answer to the following question.

    When you want to select all the rows containing the current date you can do the following: SELECT * from blabla where date = curdate()

    What I want is that you select all the rows containing the date from tomorrow. a logical solution would be: SELECT * from blabla where date = curdate()+1

    The problem arises when you perform the query at the last day of the month. If I use that query on (for example) 31 January then he will filter all the rows containing date = 32 january.

    Is there a beter solution to my problem?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    DateAdd() may be more appropriate
    HTH

Posting Permissions

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