Bash – Add 30 days in date

bashdateMySQL

Using bash or mysql , how can I add 30 days in user expiry table?

Example I have DB name USERS and table expiry like this:

USERNAME   EXPIRATION
JOHN       2015-09-26

I want the command to take whatever value is in EXPIRATION column for a specified USERNAME and add 30 days to it

So the result would be:

USERNAME   EXPIRATION
JOHN       2015-10-26

Best Answer

Using GNU date :

$ date -d '2015-09-26 +30 days' '+%Y-%m-%d'
2015-10-26

Related Solutions

Bash – How to Add Users Non-Interactively

It's an old question, but curious, others can consider the command newusers. This is present on both a RHEL5.5 system and a Ubuntu 12.04 system that I use, so I'd take a guess it will be available in the repositories for most distributions.

From man newusers:

The newusers command reads a file of user name and clear-text password pairs and uses this information to update a group of existing users or to create new users. Each line is in the same format as the standard password file (see passwd(5)) with the exceptions explained below

Linux Bash Shell Script – How to Add X Days to Date and Get New Date

You can just use the -d switch and provide a date to be calculated

date
Sun Sep 23 08:19:56 BST 2012
NEW_expration_DATE=$(date -d "+10 days")
echo $NEW_expration_DATE
Wed Oct 3 08:12:33 BST 2012

  -d, --date=STRING
          display time described by STRING, not ‘now’

This is quite a powerful tool as you can do things like

date -d "Sun Sep 11 07:59:16 IST 2012+10 days"
Fri Sep 21 03:29:16 BST 2012

TZ=IST date -d "Sun Sep 11 07:59:16 IST 2012+10 days"
Fri Sep 21 07:59:16 IST 2012

prog_end_date=`date '+%C%y%m%d' -d "$end_date+10 days"`

So if $end_date=20131001 then $prog_end_date=20131011

Best Answer

Related Solutions

Bash – How to Add Users Non-Interactively

Linux Bash Shell Script – How to Add X Days to Date and Get New Date

Related Question