how to take date exactly older than 30 days in mysql?
If you want to take the date exactly older 30 days in mysql database
If your current date is 4/09/2015
You want the record older than 30 days then the 30th day date is 05/08/2015
mysql> Select * from table_name where current_date() - INTERVAL 30 DAY;
IF YOU GIVE LIKE THIS YOU WILL GET THE EXACTLY THE 30 DAY.
SUPPOSE YOU WANT THE LIST OF ALL THE RECORDS THAT ARE 30 DAYS OLDEER.
FOR THAT
MYSQL> SELECT * FROM table_name where receiveddate < date_sub(now(), INTERVAL 30 DAY)
This will dispaly all the records that are 30 days older.
Hope this post will help someone around the world.
Thank you......
If your current date is 4/09/2015
You want the record older than 30 days then the 30th day date is 05/08/2015
mysql> Select * from table_name where current_date() - INTERVAL 30 DAY;
IF YOU GIVE LIKE THIS YOU WILL GET THE EXACTLY THE 30 DAY.
SUPPOSE YOU WANT THE LIST OF ALL THE RECORDS THAT ARE 30 DAYS OLDEER.
FOR THAT
MYSQL> SELECT * FROM table_name where receiveddate < date_sub(now(), INTERVAL 30 DAY)
This will dispaly all the records that are 30 days older.
Hope this post will help someone around the world.
Thank you......
Comments
Post a Comment