Date comparison using ksh


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date comparison using ksh
# 1  
Old 01-03-2010
Date comparison using ksh

Hi All,

i have a text sample below.

rootdbs 1 0 01/03/2010.03:11
physdbs 2 0 01/03/2010.03:17
logdbs01 3 0 01/03/2010.03:17
logdbs02 4 0 01/03/2010.03:17
dbs01 5 0 01/03/2010.03:17
dbs02 6 0 01/03/2010.03:17
dbs03 7 0 01/03/2010.03:17
dbs04 8 0 01/03/2010.03:17


What i want to achieve is:

1. create a variable that will display
YYYY=today's year
DD=today's day
MM=today's month

2. compare the $4 on the text above to the date in number 1.

3. if the date does not match for x days (where x is the number of days), it will send an email to me.
# 2  
Old 01-04-2010
What have you tried?

If you have gnu date, you can use

Code:
date -d "01/03/2010 03:11" +%s

to get the seconds since 1970-01-01 00:00:00 UTC, which compare the today's seconds with X days.
# 3  
Old 01-04-2010
We'll, The main objective actually is to loop from the dates on a per row basis and compare it with the current date. I don't want to get up to the seconds. If the dates are not equal and more than 3 days, it will send alert to me.

e.g.
DATETODAY=`date +D`
DATEBK=backup date

loop on a per row basis, then compare on a per row basis vs. DATETODAY.
# 4  
Old 01-04-2010
All date comparison should be performed with epoch ( number of seconds since 1970 ) .
Otherwise you need to write very complex code .
So , convert both dates to epoch , subtract from the first number 3*24*3600 and compare them as 2 numbers .
# 5  
Old 01-04-2010
Thank you for your reply. can you provide me some examples of the loop? I try to do it but it displays all the dates.

Code:
for i in 1.....10
do
datebk=onstat -g arc|awk '{print $4}'
echo $datebk
echo
done

the output of onstat -g arc|awk '{print $4}' is the whole output, i want to manipulate the output on a per row basis.

Last edited by pludi; 01-05-2010 at 01:52 AM.. Reason: code tags, please...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Date comparison

I have below txt file 02.05.2014 10.05.2014 17.09.2014 My requirement is the user enter date field should compare the input file if user enter date as 12.03.2013 it should compare with all date one by one from input file 12.03.2013 -ne 02.05.2014 12.03.2013 -ne 10.05.2014... (3 Replies)
Discussion started by: stew
3 Replies

2. Shell Programming and Scripting

Date Comparison

Hi Need some function or step to compare the date as given below. Example: Date_1: 25/04/2013 Date_2: 20/07/2012 if Date_1 is greater than Date_2 then do... else do.. fi Need exact unix steps to compare the above condition Use code tags please, see PM. (5 Replies)
Discussion started by: anshaa
5 Replies

3. UNIX for Dummies Questions & Answers

date comparison

Hi friends, I would like to compare two dates in an IF statement. This is what I am trying, but it doesn't work. date=20120122 minus=6 if ; then ... fi what would the IF clause looks like? Thanks! :) (5 Replies)
Discussion started by: kokoro
5 Replies

4. Shell Programming and Scripting

integer comparison in ksh

Hi, I am just trying to compare integer in ksh. can you please tell me what's wrong with this code... or give me suggestions on alternative. sample code: i=0; if ; then echo inside if fi Thanks in advance! (6 Replies)
Discussion started by: nram_krishna@ya
6 Replies

5. Solaris

Date comparison

Date comparison Hello all I am writing a scrip that will take action so long as the date with in the file is older than 3 months. The file will contain multiple rows of data. Each row will probably start with the date. My question... What is the exact code that should be used for date... (1 Reply)
Discussion started by: UofU
1 Replies

6. Homework & Coursework Questions

Date comparison with 'string date having slashes and time zone' in Bash only

1. The problem statement, all variables and given/known data: I have standard web server log file. It contains different columns (like IP address, request result code, request type etc) including a date column with the format . I have developed a log analysis command line utility that displays... (1 Reply)
Discussion started by: TariqYousaf
1 Replies

7. Shell Programming and Scripting

Date comparison

Hi all, I've a shell script which runs on Bourne shell. I've to do a date comparison. If the value of the supplied parameter(in format YYYYMMDD)is greater than todays's date(format YYYYMMDD), it should prompt the user that the supplied date is greater than today's date. The script is given... (6 Replies)
Discussion started by: sumesh.abraham
6 Replies

8. AIX

Problem in ksh script ( String comparison )

hi , i am trying to compre two strings if ] or if ] when the length of var1 is small (around 300-400 char ) it works fine but when it is large (around 900-1000 chars) it fails is there any limitations for this type of comparison ??? (1 Reply)
Discussion started by: amarnath
1 Replies

9. Shell Programming and Scripting

Problem in ksh script ( String comparison )

hi , i am trying to compre two strings if ] or if ] when the length of var1 is small (around 300-400 char ) it works fine but when it is large (around 900-1000 chars) it fails is there any limitations for this type of comparison ??? (3 Replies)
Discussion started by: amarnath
3 Replies

10. Shell Programming and Scripting

date comparison

How can I compare two dates in String format (eg. May 23 2006 05:30:21) in AWK? Thanks (2 Replies)
Discussion started by: dkr123
2 Replies
Login or Register to Ask a Question