MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Date BETWEEN another using CURRENT_DATE
Posted by: Peter Brawley
Date: November 24, 2014 09:46PM

Check Date_Sub() syntax, lose the minus sign:

...BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) AND CURRENT_DATE ...

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Date BETWEEN another using CURRENT_DATE
Matt Snow
November 24, 2014 03:14PM
Re: Date BETWEEN another using CURRENT_DATE
Peter Brawley
November 24, 2014 09:46PM
Re: Date BETWEEN another using CURRENT_DATE
Rick James
November 24, 2014 11:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.