Substracting days from current date(K shell script)


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Substracting days from current date(K shell script)
# 1  
Old 02-10-2011
Substracting days from current date(K shell script)

Hi,

I want to subtract 'n' days from the current timestamp in a k shell script. Is there any inbuilt function to do it
or any workaround solution to get the date. And I want the output to be in YYYY:MM:DD HH:MM:SS format. Please help.

Thanks in advance.

Last edited by Perderabo; 04-11-2011 at 02:41 PM.. Reason: Disable smilies
# 2  
Old 02-10-2011
In ksh88, no there are no builtins to do what you want. You have to resort to perl or a ksh script that turns dates into JD, subtract days, then turn the new JD back into a date.

See cfa johnson's scripts for Julian dates:
8: The Dating Game
# 3  
Old 02-10-2011
If you are using ksh93 you can use %T. For example to print the date 5 days ago:
Code:
$ printf "%(%Y:%m:%d %H:%M:%S)T\n" "5 days ago"
2011:02:05 10:20:15
$

# 4  
Old 04-11-2011
how to get 10 days date from currentdate

May i know, how to get 10 days date from currentdate.

Like current date: 04-11-2011
I need: 03-28-2011.

I am using this but when i use it in my query the result is diffrent

Code: date -d "14 days ago"
# 5  
Old 04-11-2011
Use this script with Number of days as the parameter

datefunction.ksh
Code:
 #!/bin/bash

sec2date (){
    date --utc --date "1970-01-01 $1 sec" "+%Y-%m-%d %T"
}

sec=86400
NDAYS=$1
SEC_DIFF=`expr $sec \* $NDAYS`

CURR_TS=`date "+%Y-%m-%d %T"`

dte1=`date --utc --date "$CURR_TS" +%s`
dte2=$((dte1-SEC_DIFF))

dte2op=$(sec2date $dte2)

echo "Current Timestamp:            $CURR_TS"
echo "Timestamp $1 days before:  $dte2op"
exit 0

Use like "datefunction.ksh 5"
Here 5 is the number of days
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Linux

How to calculate the quarter end date according to the current date in shell script?

Hi, My question is how to calculate the quarter end date according to the current date in shell script? (2 Replies)
Discussion started by: Divya_1234
2 Replies

2. HP-UX

awk command in hp UNIX subtract 30 days automatically from current date without date illegal option

current date command runs well awk -v t="$(date +%Y-%m-%d)" -F "'" '$1 < t' myname.dat subtract 30 days fails awk -v t="$(date --date="-30days" +%Y-%m-%d)" -F "'" '$1 < t' myname.dat awk command in hp unix subtract 30 days automatically from current date without date illegal option error... (20 Replies)
Discussion started by: kmarcus
20 Replies

3. UNIX for Beginners Questions & Answers

Subscribers with Date 90 days older than current date

I have to display only those subscribers which are in "unconnected state" and the date is 90 days older than today's date. Below command is used for this purpose: cat vfsubscriber_20170817.csv | sed -e 's/^"//' -e '1d' | nawk -F '",' '{if ( (substr($11,2,4) == 2017) && ( substr($11,2,8) -lt... (1 Reply)
Discussion started by: dia
1 Replies

4. Shell Programming and Scripting

Seven days past date from current date

hi all.. i want 2 know how 2 find 7days past date from current date.. when i used set datetime = `date '+%m%d%y'` i got 060613.. i just want to know hw to get 053013.. i tried using date functions but couldnt get it :( i use c shell and there is no chance that i can change that ..... (3 Replies)
Discussion started by: Rahul619
3 Replies

5. Shell Programming and Scripting

Number of days between the current date and user defined date

I am trying to find out the number of days between the current date and user defined date. I took reference from here for the date2jd() function. Modified the function according to my requirement. But its not working properly. Original code from here is working fine. #!/bin/sh... (1 Reply)
Discussion started by: hiten.r.chauhan
1 Replies

6. Shell Programming and Scripting

How to Get 60 days Old date from current date in KSH script

Hi i am writing a cron job. so for it i need the 60 days old date form current date in variable. Like today date is 27 jan 2011 then output value will be stote in variable in formet Nov 27. i am using EST date, and tried lot of solution and see lot of post but it did not helpful for me. so... (3 Replies)
Discussion started by: Himanshu_soni
3 Replies

7. Windows & DOS: Issues & Discussions

Adding or subtracting days from current date in batch script

Hi, I'm writing an batch file to create report In the batch file iam passing two arguments:startdate and finishdate Ex: startdate=07-sep-2009 finishdate=07-sep-2011 I need to have script that takes command line argument as input and gives me out currentdate last year and current date... (2 Replies)
Discussion started by: anand1773
2 Replies

8. Shell Programming and Scripting

Date after 5 days from current date in YYYYMMDD format

Hello Experts, How do i get date after 5 days from current date in YYYYMMDD format? How do you compare date in YYYYMMDD format? Thanks (8 Replies)
Discussion started by: needyourhelp10
8 Replies

9. Shell Programming and Scripting

how to get what date was 28 days ago of the current system date IN UNIX

Hi, Anybody knows how to get what date was 28 days ago of the current system date through UNIX script. Ex : - If today is 28th Mar 2010 then I have to delete the files which arrived on 1st Mar 2010, (15 Replies)
Discussion started by: kandi.reddy
15 Replies

10. Shell Programming and Scripting

How to find a date which is 7 days past when given current date

hii all. I have to get the date of the 7th day past from the current date. if i give the current date as sep 3 then i must get the date as 27th of august. can we get the values from the "cal" command. cal | awk '{print $2}' will this type of command work. actually my need is if today is... (17 Replies)
Discussion started by: ladtony
17 Replies
Login or Register to Ask a Question