The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page Delete files older than 3 months.(read date from the name of the file)
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Delete files older than 3 months.(read date from the name of the file)
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #3 (permalink)  
Old 07-14-2008
mirusnet's Avatar
mirusnet mirusnet is offline
Registered User
  
 

Join Date: Dec 2007
Posts: 146
Also just an example, with mysql

Code:
mirus scripts # logdate=`echo log_20080214072942 | egrep  -o 'log_[0-9]{6}' | egrep -o '[0-9]{6}'` 
mirus scripts # echo $logdate
200802
mirus scripts # month_diff=`mysql -u root -sABNe "SELECT PERIOD_DIFF(DATE_FORMAT(CURDATE(), '%Y%m'), '$logdate')"`
mirus scripts # echo $month_diff
5