Visit Our UNIX and Linux User Community


Need to substract date with current date and time


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to substract date with current date and time
# 1  
Old 10-12-2013
Network Need to substract date with current date and time

I have below file which contain the date in column 3,4,5

Code:
12345 open 10/10/13 10:08 PM  3 application is in java          
67899 open 12/10/13 2:31 AM   2 apps can be reach               
23456 open 11/9/13 2:31 AM    4 java is OK                      
65432 open 12/10/13 10:07 PM  9 we are running below threshold  
34568 open 11/10/13 5:42 AM   8 unix shell scripts is OK        
45678 open 09/10/13 9:07 PM   7 web logic is running

we need to subtract date and time(which are in column 3,4, 5) with current date and time.. need to write difference in one column

suppose current date is "12/10/13 12:00 PM" ..then the output file should be like below

if the difference is less then a 1 day output column should say difference in hours
if the difference more then 24 hours output column should say difference in days
if the difference more then 30 days output column should say difference in month


Code:
12345 open 10/10/13 10:08 PM  3 application is in java                2 day        
67899 open 12/10/13 2:31 AM   2 apps can be reach                     7 hours 
23456 open 11/9/13 2:31 AM    4 java is OK                            1 month 
65432 open 12/10/13 10:07 PM  9 we are running below threshold        1 hour  
34568 open 11/10/13 5:42 AM   8 unix shell scripts is OK              1 day
45678 open 09/10/13 9:07 PM   7 web logic is running                  3 days

please provide me the code in shell ..i need your help..plz

Last edited by vijay_rajni; 10-12-2013 at 10:21 AM.. Reason: icode tags -> code tags
# 2  
Old 10-12-2013
This may be helpful for you.

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Getting the current time from a website and parsing date

I am trying to work on a script to grab the UTC time from a website So far I was able to cobble this together. curl -s --head web-url | grep ^Date: | sed 's/Date: //g' Which gives me the result I need. Wed, 06 Dec 2017 21:43:50 GMT What I need to is extract the 21:43:50 and convert... (4 Replies)
Discussion started by: allisterB
4 Replies

2. Shell Programming and Scripting

Add current date and time

i have file 1.txt asdas|csada|13|03|10|04|23|A1|canberra sdasd|sfdsf|13|04|26|23|28|A1|sydney i want to add today's date and time in the end of each row expected output asdas|csada|13|03|10|04|23|A1|canberra|130430|1358 sdasd|sfdsf|13|04|26|23|28|A1|sydney|130430|1358 todays date... (10 Replies)
Discussion started by: radius
10 Replies

3. Shell Programming and Scripting

Displaying current date time of EDT in IST time

Hi Folks, My server time is in EDT. And i am sending automated mails from that server in which i need to display the current date time as per IST (GMT+5:30). Please advice how to display the date time as per IST. IST time leads 9:30 mins to EDT. and i wrote something like below. ... (6 Replies)
Discussion started by: Showdown
6 Replies

4. Shell Programming and Scripting

[Solved] How to tar data along with current system date and time.?

Hi all, Following is my small script:- #!/bin/ksh for i in `cat /users/jack/mainfile-dr.txt` do sudo cp -r $i /users/jack/DR01/. done cd /users/jack/DR01/ sudo tar cvf system1-DR.tar * scp system1-DR.tar backupserver:/DRFiles/system1 sudo rm -rf system1-DR.tar In this script I... (10 Replies)
Discussion started by: manalisharmabe
10 Replies

5. UNIX for Dummies Questions & Answers

Adding hours and minutes to current date (Only to date not to time)

Hi, I want to add some hours and minutes to the current date. For example, if the current date is "July 16, 2012 15:20", i want to add 5 hours 30 minutes to "July 16, 2012 00:00" not to "July 16, 2012 15:20". Please help. Thanks! (4 Replies)
Discussion started by: manojgarg
4 Replies

6. Shell Programming and Scripting

How far is given date from current time?

give a date and time: Jun 12 21:05:16 06-12-2012 21:05:16 2012/06/12 21:05:16 How can i subtract these dates and times from the current date and time and get back the difference in seconds? a one liner like: echo "Jun 12 21:05:16" | some perl/awk programming 90900s (2 Replies)
Discussion started by: SkySmart
2 Replies

7. Shell Programming and Scripting

Date One Week Ago From Given Date, Not From Current Date

Hi all, I've used various scripts in the past to work out the date last week from the current date, however I now have a need to work out the date 1 week from a given date. So for example, if I have a date of the 23rd July 2010, I would like a script that can work out that one week back was... (4 Replies)
Discussion started by: Donkey25
4 Replies

8. Shell Programming and Scripting

Prefix the current date and time to the output of ps

Hi, I need to write a script, that will take the current date, time, and the output from # ps -eo pid,tid,class,rtprio,ni,pri,psr,pcpu,stat,wchan:14,comm and spit it to a file, so it'll look like this... PID TID CLS RTPRIO NI PRI PSR %CPU STAT WCHAN COMMAND 1 1 TS... (2 Replies)
Discussion started by: Bloke
2 Replies

9. Shell Programming and Scripting

Get date and time for past 1 hour from current date

Hi, I need to get the date and time for past 1 hour from the current date. Anyone know how to do so? Thanks (5 Replies)
Discussion started by: spch2o
5 Replies

10. Shell Programming and Scripting

param as current date+time

Hi All, I need to pass param on aix "errpt -a -s MMDDHHMMYY -e MMDDHHMMYY". How do I read the date+time on the system and pass it as parameter? I need also the -s as previous day and the -e as current day. Thanks, itik (1 Reply)
Discussion started by: itik
1 Replies

Featured Tech Videos