11-28-2012
Like I said, YYYY-MM-DD dates are directly sortable as strings. There's no need to convert them to epoch seconds.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
Currently I can grep a log file with the following command:
$results = `grep -A 2 '^$date.$time.*' $log`;
and the following arguments:
$date = 2007/04/25
$time = 16:07
Log example:
2007/04/25 16:07:12.145701
2007/05/25 14:07:12.145701
2007/05/25 17:07:12.145701
2007/06/25... (37 Replies)
Discussion started by: Epiphone
37 Replies
2. Shell Programming and Scripting
Hi,
I have problem of filtering a log file from my perl script.
#cat /data/pinpe.csv_20070731 | nawk -v FS=, '{print $1','$18','$22','$26}' | grep -w 100 | grep -w 1 | nawk '{print $4}'
Below is the output:
2009-06-16
2009-01-29
2009-06-02
2008-03-05
2007-08-05
2007-09-24... (5 Replies)
Discussion started by: pinpe
5 Replies
3. UNIX for Dummies Questions & Answers
I have a folder that has files that go way back to 2005. How can I search for files between say Jan 2006 - Dec 2007 only? I did a man on the Find command but nothing in there.
Any help would be appreciated. (4 Replies)
Discussion started by: bbbngowc
4 Replies
4. Shell Programming and Scripting
Hello friends,
I am looking for a script or method that can display all the dates between any 2 given dates.
Input:
Date 1
290109
Date 2
010209
Output:
300109
310109
Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies
5. Shell Programming and Scripting
Hi,
I have a script that handles a huge amount of log files from many machines and copies it into a SAN location with the following directory structure:
/SAN/machinenames/yyyy/m/d
so for example
/SAN/hosta/2011/3/12/files*
Now I am writing a bash script to search for files between to date... (4 Replies)
Discussion started by: GermanJulian
4 Replies
6. Shell Programming and Scripting
Hi,
I've written a script to search for an Oracle ORA- error on a log file, print that line and the .trc file associated with it as well as the dateline of when I assumed the error occured. In most it is the first dateline previous to the error.
Unfortunately, this is not a fool proof script.... (2 Replies)
Discussion started by: newbie_01
2 Replies
7. Programming
Just a little help if possible
I have a table with date data, I want to select dates that fall between today and 1 month ago, here's my query
SELECT id, stdate, DATE_SUB(CURDATE(), INTERVAL 1 month) as monthago, CURDATE() as today
FROM data_table
where (stdate between 'today' and 'monthago')... (4 Replies)
Discussion started by: barrydocks
4 Replies
8. What is on Your Mind?
How to grep a file containing dates to only last 30 days then move to another folder (7 Replies)
Discussion started by: kmarcus
7 Replies
9. UNIX for Beginners Questions & Answers
Lets say I have a massive directory which is filled with other directories all filled with different c++ scripts and I want a listing of all the scripts that contain the string: "this string". Is there a way to use a grep search for that? I tried:
grep -lr "this string" *
but I do not... (3 Replies)
Discussion started by: Circuits
3 Replies
LEARN ABOUT SUSE
convdate
CONVDATE(1) InterNetNews Documentation CONVDATE(1)
NAME
convdate - Convert to/from RFC 5322 dates and seconds since epoch
SYNOPSIS
convdate [-dhl] [-c | -n | -s] [date ...]
DESCRIPTION
convdate translates the date/time strings given on the command line, outputting the results one to a line. The input can either be a date
in RFC 5322 format (accepting the variations on that format that innd(8) is willing to accept), or the number of seconds since epoch (if -c
is given). The output is either ctime(3) results, the number of seconds since epoch, or a Usenet Date: header, depending on the options
given.
If date is not given, convdate outputs the current date.
OPTIONS
-c Each argument is taken to be the number of seconds since epoch (a time_t) rather than a date.
-d Output a valid Usenet Date: header instead of the results of ctime(3) for each date given on the command line. This is useful for
testing the algorithm used to generate Date: headers for local posts. Normally, the date will be in UTC, but see the -l option.
-h Print usage information and exit.
-l Only makes sense in combination with -d. If given, Date: headers generated will use the local time zone instead of UTC.
-n Rather than outputting the results of ctime(3) or a Date: header, output each date given as the number of seconds since epoch (a
time_t). This option doesn't make sense in combination with -d.
-s Pass each given date to the RFC 5322 date parser and print the results of ctime(3) (or a Date: header if -d is given). This is the
default behavior.
EXAMPLES
Most of these examples are taken, with modifications from the original man page dating from 1991 and were run in the EST/EDT time zone.
% convdate '10 Feb 1991 10:00:00 -0500'
Sun Feb 10 10:00:00 1991
% convdate '13 Dec 91 12:00 EST' '04 May 1990 0:0:0'
Fri Dec 13 12:00:00 1991
Fri May 4 00:00:00 1990
% convdate -n '10 feb 1991 10:00' '4 May 90 12:00'
666198000
641880000
% convdate -c 666198000
Sun Feb 10 10:00:00 1991
ctime(3) results are in the local time zone. Compare to:
% convdate -dc 666198000
Sun, 10 Feb 1991 15:00:00 +0000 (UTC)
% env TZ=PST8PDT convdate -dlc 666198000
Sun, 10 Feb 1991 07:00:00 -0800 (PST)
% env TZ=EST5EDT convdate -dlc 666198000
Sun, 10 Feb 1991 10:00:00 -0500 (EST)
The system library functions generally use the environment variable TZ to determine (or at least override) the local time zone.
HISTORY
Written by Rich $alz <rsalz@uunet.uu.net>, rewritten and updated by Russ Allbery <rra@stanford.edu> for the -d and -l flags.
$Id: convdate.pod 8894 2010-01-17 13:04:04Z iulius $
SEE ALSO
active.times(5).
INN 2.5.2 2010-02-08 CONVDATE(1)