07-07-2006
Quote:
Originally Posted by dkr123
How can I compare two dates in String format (eg. May 23 2006 05:30:21) in AWK?
Thanks
1. convert 'Month DD YYYY' to 'YYYYMMDD'
2. compare 2 of the 'converted' dates
3. If both dates refer to the same date, convert HH:MM:SS to HHMMSS
4. compare 2 converted 'times' from above
The rest should a matter of the implementation details.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
Hi
I have this simple script:
#!/bin/bash
date1=2009:07:15:12:36
date2=2009:07:15:12:16
echo $date1
echo $date2
datediff=
#datediff=date1-date2
echo datediff is$datediff
How do i return the difference in seconds? (6 Replies)
Discussion started by: carp.dk
6 Replies
3. Homework & Coursework Questions
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
4. Shell Programming and Scripting
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 ... (4 Replies)
Discussion started by: informix2009
4 Replies
5. Solaris
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. UNIX for Dummies Questions & Answers
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
7. Shell Programming and Scripting
hi,
I have a file named user.cfg under /var/member/
#user.cfg file under /var/member/
login user: root #how are you
login pass: admin #where are you
M: user1 pass1 #20121008
M: user2 pass2 #20111230
M: user3 pass3 #20091220
M: user4 pass4 #20070210
M: user5 pass5 #20130708
M:... (3 Replies)
Discussion started by: baris35
3 Replies
8. Shell Programming and Scripting
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
9. UNIX for Dummies Questions & Answers
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
10. Shell Programming and Scripting
Hey everyone,
I'm trying to create a script using awk and if that will list all of our aws tapes that have archived date that is past 90 days from todays current date, so that I can pass that to my aws command to remove.
The fifth column is the creation date in epoch/seconds, so I'm... (13 Replies)
Discussion started by: beyondmondays
13 Replies
LEARN ABOUT OPENSOLARIS
dp
DP(8) [nmh-1.5] DP(8)
NAME
dp - parse dates 822-style
SYNOPSIS
/usr/lib/mh/dp [-form formatfile] [-format string] [-width columns] [-version] [-help] dates ...
DESCRIPTION
Dp is a program that parses dates according to the ARPA Internet standard. It also understands many non-standard formats, such as those
produced by TOPS-20 sites and some UNIX sites using ctime(3). It is useful for seeing how nmh will interpret a date.
The dp program treats each argument as a single date, and prints the date out in the official 822-format. Hence, it is usually best to
enclose each argument in quotes for the shell.
To override the output format used by dp, the -format string or -format file switches are used. This permits individual fields of the
address to be extracted with ease. The string is simply a format string and the file is simply a format file. See mh-format(5) for the
details.
Here is the default format string used by dp:
%<(nodate{text})error: %{text}%|%(putstr(pretty{text}))%>
which says that if an error was detected, print the error, a `:', and the date in error. Otherwise, output the 822-proper format of the
date.
FILES
$HOME/.mh_profile The user profile
PROFILE COMPONENTS
None
SEE ALSO
ap(8), Standard for the Format of ARPA Internet Text Messages (RFC-822)
DEFAULTS
`-format' default as described above
`-width' default to the width of the terminal
CONTEXT
None
BUGS
The argument to the -format switch must be interpreted as a single token by the shell that invokes dp. Therefore, one must usually place
the argument to this switch inside quotes.
MH.6.8 11 June 2012 DP(8)