Need to substract date with current date and time Post: 302863059

Sponsored Content

Top Forums Shell Programming and Scripting Need to substract date with current date and time Post 302863059 by vijay_rajni on Saturday 12th of October 2013 03:48:37 AM

10-12-2013

Registered User

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 09:21 AM.. Reason: icode tags -> code tags

vijay_rajni

View Public Profile for vijay_rajni

Find all posts by vijay_rajni

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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...

4. 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...

5. 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

6. 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!

7. 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...

8. 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. ...

9. 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. 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...

LEARN ABOUT MINIX

holidays

holidays(4)							   File Formats 						       holidays(4)

NAME

       holidays - prime/nonprime table for the accounting system

SYNOPSIS

       /etc/acct/holidays

DESCRIPTION

       The   /etc/acct/holidays file describes which hours are considered prime time and which days  are holidays.  Holidays and weekends are con-
       sidered non-prime time hours.  /etc/acct/holidays is used by the accounting system.

       All lines beginning with an "*" are comments.

       The  /etc/acct/holidays file consists of two sections.  The first non-comment line defines the current year and the start time of prime and
       non-prime time hours, in the form:

       current_year	 prime_start	  non_prime_start

       The remaining non-comment lines define the holidays in the  form:

       month/day     company_holiday

       Of these two fields, only the  month/day is actually used by  the accounting system programs.

       The  /etc/acct/holidays file must be updated each year.

EXAMPLES

       Example 1: Example of the /etc/acct/holidays file.

       The following is an example of the /etc/acct/holidays file:

       * Prime/Nonprime Table for the accounting system
       *
       * Curr	  Prime     Non-Prime
       * Year	  Start     Start
       *
	 1991	  0830	   1800
       *
       * only the first column (month/day) is significant.
       *
       * month/day    Company Holiday
       *
	 1/1	      New Years Day
	 5/30	      Memorial Day
	 7/4	      Indep. Day
	 9/5	      Labor Day
	 11/24	      Thanksgiving Day
	 11/25	      day after Thanksgiving
	 12/25	      Christmas
	 12/26	      day after Christmas

SEE ALSO

       acct(1M)

SunOS 5.10							    28 Mar 1991 						       holidays(4)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

param as current date+time

Discussion started by: itik

2. Shell Programming and Scripting

Get date and time for past 1 hour from current date

Discussion started by: spch2o

3. Shell Programming and Scripting

Prefix the current date and time to the output of ps

Discussion started by: Bloke

4. Shell Programming and Scripting

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

Discussion started by: Donkey25