Sponsored Content
Full Discussion: sorting on date
Top Forums UNIX for Dummies Questions & Answers sorting on date Post 1777 by Duckman on Thursday 29th of March 2001 11:21:45 AM
Old 03-29-2001
but this will sort all dates with a common month together? before sorting on year?...ie,

01/15/1999
01/16/2000
02/01/1999
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

date sorting

Hi at all, I have to sort a log file on timestamp field. That's field is the third! a log file sample..... 1|EVTVOD-1-20060709_000614|2006/07/09-0:11:23|0.3.8 1|EVTVOD-1-20060709_000614|2006/07/09-0:11:16|0.3.8 1|EVTVOD-1-20060709_000614|2006/07/09-0:11:20|0.3.8... (3 Replies)
Discussion started by: nmilella
3 Replies

2. Shell Programming and Scripting

Sorting a date coulumn

Hi All, I have a file say abc.txt with the below data. 1234 876S 01Mar2007 foo 1244 65DF 19Jan2007 boo 9924 234K 01Jan2006 koo 8866 8FGH 12Feb1999 roo 7777 ASDF 13May2007 soo I need this file to be in sorted order depending on the date field. e.g 8866 8FGH 12Feb1999 roo... (2 Replies)
Discussion started by: rinku11
2 Replies

3. Shell Programming and Scripting

Date Sorting

Hi, I have a list of files that take on the format ABCDE_yymmdd and wish to sort them in ascending date order. I can't use the unix time stamp for the file as this could possibly be different from the date given in the file name. Does anyone know of any way this can be done using unix shell... (14 Replies)
Discussion started by: LiquidChild
14 Replies

4. UNIX for Dummies Questions & Answers

Sorting by date and time

Hi guys... I've been trying to do this for ages. Maybe you can help. I have log files like the examples below and I have grepped out certain lines from the files so that I can get an idea of who is logging on and how. So now I have the information in a new file but it is now in a different order... (7 Replies)
Discussion started by: padmundo
7 Replies

5. Shell Programming and Scripting

Date and Time sorting

Hi Guys! i have a problem of sorting column chronologically because the data i have in column is in the following format 06/Dec/2006:18:09:54 and need to be sorted in the following way (upto seconds) 06/Dec/2005:18:09:50 06/Dec/2005:18:09:51 31/Mar/2006:19:30:41 24/Oct/2006:19:16:19... (4 Replies)
Discussion started by: me_newbie
4 Replies

6. Shell Programming and Scripting

date(ddmmyyyy) sorting

input : 20110730 20110730 20110731 20110731 20110801 20110801 20110801 20110813 20110815 01062011 01062011 OUTPUT : i need to sort this input in such a way so that the latest date comes first. (11 Replies)
Discussion started by: urfrnddpk
11 Replies

7. Shell Programming and Scripting

Sorting the data with date

Hi, PFB the data: C_Random_130417 Java_Random_130518 Perl_Random_120519 Perl_Random_120528 so the values are ending with year,i.e.,130417 i want to sort the values with date. i want the output like this: Perl_Random_120519 Perl_Random_120528 C_Random_130417 Java_Random_130518 can... (5 Replies)
Discussion started by: arindam guha
5 Replies

8. Shell Programming and Scripting

Sorting by date

I am trying to sort by two columns. The first column in an ID, the second is a date in the form yyyy-mm-dd. I need to sort by the ID column, then in ascending order for the date column (earliest date to most recent date compared to today). Input data: 012-abc 2012-04-25 ... (3 Replies)
Discussion started by: mollydog11
3 Replies

9. Shell Programming and Scripting

Sorting on date basis

I have file data.txt having below data cat data.txt 01-MAY-13 2.38.11.00.100089 IN 4512 0000741881 01-MAY-13 2.38.11.00.100089 IN 4512 0000741881 01-JUN-13 2.38.11.00.100089 FC 1514 0000764631 01-NOV-13 2.38.11.00.100089 FC 1514 0000856571 01-NOV-13 2.38.11.00.100089 IN 300.32... (1 Reply)
Discussion started by: ranabhavish
1 Replies

10. UNIX for Dummies Questions & Answers

Sorting on fields for last date

Hi all, I have a file with a list of rpm's that have different dates. I am trying to just grab the latest rpm and install date, and discard the rest. The file has 1000's of entries all with different names and dates. I have tried sort -k on the file and I am not grabbing the info, ... (4 Replies)
Discussion started by: gartie
4 Replies
CONVCAL(1)							   User's Manual							CONVCAL(1)

NAME
convcal - convert dates to different formats SYNOPSIS
convcal [OPTIONS] [DATE] DESCRIPTION
convcal is part of the grace software package, an application for two-dimensional data visualization. convcal converts dates from and to various formats. The following date formats are supported (hour, minutes and seconds are always optional): iso 1999-12-31T23:59:59.999 european 31/12/1999 23:59:59.999 or 31/12/99 23:59:59.999 us 12/31/1999 23:59:59.999 or 12/31/99 23:59:59.999 days 123456.789 seconds 123456.789 The formats are tried in the following order : users's choice, iso, european and us (there is no ambiguity between calendar formats and numerical formats and therefore no order is specified for them). USAGE
convcal reads the dates either on the command line or in the standard input if the command line contains no date. The user's choice for the input format put one format before the other ones in the trial list, this is mainly useful for US citizen which would certainly prefer to have US format checked before european format. The default user's choice (nohint) does nothing so the following formats of the list are checked. The separators between various fields can be any characters in the set: " :/.-T". One or more spaces act as one separator, other characters can not be repeated, the T separator is allowed only between date and time, mainly for iso8601. So the string "1999-12 31:23-59" is allowed (but not recommended). The '-' character is used both as a separator (it is traditionally used in iso8601 format) and as the unary minus (for dates in the far past or for numerical dates). When the year is between 0 and 99 and is written with two or less digits, it is mapped to the era beginning at wrap year and ending at wrap year + 99 as follows : [wy ; 99] -> [ wrap_year ; 100*(1 + wrap_year/100) - 1 ] [00 ; wy-1] -> [ 100*(1 + wrap_year/100) ; wrap_year + 99] so for example if the wrap year is set to 1950 (which is the default value), then the mapping is : range [00 ; 49] is mapped to [2000 ; 2049] range [50 ; 99] is mapped to [1950 ; 1999] this is reasonably Y2K compliant and is consistent with current use. Specifying year 1 is still possible using more than two digits as follows : "0001-03-04" is unambiguously March the 4th, year 1, even if the user's choice is us format. However using two digits only is not recommended (we introduce a 2050 bug here so this feature should be removed at some point in the future ;-) Numerical dates (days and seconds formats) can be specified using integer, real or exponential formats (the 'd' and 'D' exponant markers from fortran are supported in addition to 'e' and 'E'). They are computed according to a customizable reference date. The default value is given by the REFDATE constant in the source file. You can change this value as you want before compiling, and you can change it at will using the -r command line option. The default value in the distributed file is "-4713-01-01T12:00:00", it is a classical reference for astronomical events (note that the '-' is used here both as a unary minus and as a separator). The program can be used either for Denys's and gregorian calendars. It does not take into account leap seconds : you can think it works only in International Atomic Time (TAI) and not in Coordinated Unified Time (UTC) ... Inexistant dates are detected, they include year 0, dates between 1582-10-05 and 1582-10-14, February 29th of non leap years, months below 1 or above 12, ... OPTIONS
A summary of the options supported by convcal is included below. -h prints the help message on stderr and exits successfully -i format set user's choice for input format, supported formats are iso, european, us, days, seconds and nohint. At the beginning the input format is nohint, which means the program try to guess the format by itself, if the user's choice does not allow to parse the date, other formats are tried -o format force output format, supported formats are iso, european, us, days, seconds and nohint. At the beginning, the output format is nohint, which means the program uses days format for dates read in any calendar format and uses iso8601 for dates read in numerical format -r date set reference date (the date is read using the current input format) at the beginning the reference is set according to the REFDATE constant in the code, which is -4713-01-01T12:00:00 in the distributed file. -w year set the wrap year to year SEE ALSO
grace(1) http://plasma-gate.weizmann.ac.il/Grace/ AUTHOR
Luc Maisonobe This man-page was written by Jan Schaumann <jschauma@netmeister.org> as part of "The Missing Man Pages Project". Please see http://www.netmeister.org/misc/m2p2/index.html for details. grace August 11, 2001 CONVCAL(1)
All times are GMT -4. The time now is 09:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy