MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: DATE DIFF
Posted by: Peter Brawley
Date: December 06, 2014 02:12PM

set @1=curdate();
set @2=curdate()-interval 4 day;
select if( datediff(@1,@2)>3, @1, null );

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


Subject
Written By
Posted
DATE DIFF
Lovesalot Carluccio
December 06, 2014 01:40PM
Re: DATE DIFF
Peter Brawley
December 06, 2014 02:12PM
Re: DATE DIFF
Rick James
December 06, 2014 02:49PM
Re: DATE DIFF
Lovesalot Carluccio
December 06, 2014 03:09PM


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.