How to get data one year before from database in mysql?


Answers

  • Mourya
    April 21, 2020

    To get the data from database between today and one year before

    SELECT * FROM table WHERE date<= DATE_SUB(NOW(),INTERVAL 1 YEAR);

     

    Comment

Have More Question?

Subscribe For Daily Updates