MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: (Expiring Next Month) Problem
Posted by: Peter Brawley
Date: August 12, 2014 10:42AM

Assuming parameter N specifying how many months in the future to calculate for ... 

... where 100 * year(expiry_date) + month(expiry_date) = 
      100 * year(expiry_date + interval N month) + month(expiry_date + interval N month)

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


Subject
Written By
Posted
(Expiring Next Month) Problem
Jassm Rahma
August 12, 2014 01:44AM
Re: (Expiring Next Month) Problem
Phillip Ward
August 12, 2014 04:59AM
Re: (Expiring Next Month) Problem
Rick James
August 12, 2014 01:27PM
Re: (Expiring Next Month) Problem
Peter Brawley
August 12, 2014 10:42AM


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.