To sort dates it works best to convert them to epoch seconds - the number of seconds since Jan 1 970. This code adds an epoch time sorts based on the epoch time, then prints the original minus the seconds: this assumes some kin of linux OS -
Called a tag sort.
I get this output: --- Post updated at 17:16 ---
@Drl - one of our senior people, may mention getting a linux package for date operations, one of the commands is "dsort" which does exactly what the code above does. Hopefully he will mention where to download it. I do not know
These 2 Users Gave Thanks to jim mcnamara For This Post:
I check the man page but I still cannot see what this command is supposed to do
sort +5 -6 <file>
It just seems to sort the file as normal??
Thanks
Calypso (3 Replies)
Hi to all.
I'm trying to sort this with the Unix command sort.
user1:12345678:3.5:2.5:8:1:2:3
user2:12345679:4.5:3.5:8:1:3:2
user3:12345687:5.5:2.5:6:1:3:2
user4:12345670:5.5:2.5:5:3:2:1
user5:12345671:2.5:5.5:7:2:3:1
I need to get this:
user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
Hello all -
I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
sort --random-sort
The full command is
path=`find /testdir -maxdepth 1 -mindepth 1 -type d | ***Some sort of sort function*** | head -1`
I have a list I want to randomly sort. It works fine in ubuntu but on a 'osx lion' sort dosen't have the --random-sort option.
I don't want to... (5 Replies)
Input file:
100%ABC2 3.44E-12 USA
A2M%H02579 0E0 UK
100%ABC2 5.34E-8 UK
100%ABC2 3.25E-12 USA
A2M%H02579 5E-45 UK
Output file:
100%ABC2 3.44E-12 USA
100%ABC2 3.25E-12 USA
100%ABC2 5.34E-8 UK
A2M%H02579 0E0 UK
A2M%H02579 5E-45 UK
Code try:
sort -k1,1 -g -k2 -r input.txt... (2 Replies)
Hi Experts,
I have a filelist collected from another server , now want to sort the output using date/time stamp filed.
- Filed 6, 7,8 are showing the date/time/stamp.
Here is the input:
#----------------------------------------------------------------------
-rw------- 1 root ... (3 Replies)
Hi,
Could anyone kindly show me a link or explain the difference between
sort -n -k2 -k3 & sort -n -k2,3
Also, if I like to remove the row with repetition at both $2 and $3, Can I safely use
sort -u -k2 -k3
Example;
100 20 30
100 20 30
So, both $2 and $3 are same and I... (2 Replies)
How to sort the following output based on lowest to highest BE?
The following sort does not work.
$ sort -t. -k1,1n -k2,2n bfd.txt
BE31.116 0s 0s DOWN DAMP
BE31.116 0s 0s DOWN DAMP
BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 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)