Find next month date threw mysql

Query example :

($sql="SELECT DATE_ADD(date_format(b_reg_date,'%Y/%m/%d'), INTERVAL 3 MONTH) as exp_date,business,users,utype,b_headline,b_reg_date,curdate() from `tbl_business` as h  having DATE_SUB(exp_date,INTERVAL 5 DAY)=curdate() ";)

Post a Comment

Previous Post Next Post