Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Date conversion and compare
Top Forums UNIX for Dummies Questions & Answers Date conversion and compare Post 302484416 by bhavinshah15 on Friday 31st of December 2010 02:10:10 AM
Old 12-31-2010
Java
Quote:
Originally Posted by m.d.ludwig
Attempting to interpret what is needed -- list of files that are older than a specific date/time:
Code:
#! /bin/ksh
 
NAME=$(basename ${0})
FILE=$(mktemp --tmpdir ${NAME}.XXXXXX)
 
trap "rm -f ${FILE}" EXIT
 
TIME="${1}"
shift
 
touch -t "${TIME}" ${FILE}
find "${@}" -type f ! -newer ${FILE} -print

The first argument is the time in the format [[CC]YY]MMDDhhmm[.ss], the second and subsequent arguments are directories.


Idea looks good - make a temp file with that date and then use find command to search required files....

But, making temp file requires time in MMDDhhmm format and we have time in "MMM DD" format ("Dec 20"). I don't want to write a function to convert externally
Jan -> 01
Feb -> 02
...
...
Do we have any built in conversion function?
Also,
I want to find files older than specified date, not newer files.... In find command, we can use "-newer" option but we don't have "-older" option.

---------- Post updated at 12:40 PM ---------- Previous update was at 12:33 PM ----------

Quote:
Originally Posted by jim mcnamara
"some command" produces a date. What is the "some command"? Commands like date let you specify what you get.

"Some command" - we have a local command which produces output in "MMM DD" format (eg "Dec 20"). Using this, I want to schedule a cron to move older files to archive directory...
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Date Conversion

Hello, I want to convert MM DD YYYY date format to MM-DD-YYYY format. For exemple: I have to convert Nov 28 2005 to 28-11-2005. Thenks for youf help. DAFI (2 Replies)
Discussion started by: dafidak
2 Replies

2. Shell Programming and Scripting

date conversion

file1 E106,0,1/9/1993,0,E001,E003,A,45200,3766.667,21.730769 E108,0,2/3/1995,0,E001,E003,A,15000,1250,7.211538 E109,0,06-mar-07,0,E001,E001,A,78000,6500,37.5 E110,0,09-dec-2008,0,E001,E001,A,56000,4666.667,26.923077 E104,0,06/04/1994,0,E001,E003,A,95000,7916.667,45.673077... (14 Replies)
Discussion started by: charandevu
14 Replies

3. Shell Programming and Scripting

Compare date from db2 table to yesterday's Unix system date

I am currently running the following Korn shell script which works fine: #!/usr/bin/ksh count=`db2 -x "select count(*) from schema.tablename"` echo "count" I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
Discussion started by: sasaliasim
9 Replies

4. Shell Programming and Scripting

Conversion of date to Julian date

Hi Gurus, Need help in Conversion of date(2007-11-30) to Julian date(YYDDD)... '+%J' 2007-11-30 to 'YYDDD' Thanks (4 Replies)
Discussion started by: SeenuGuddu
4 Replies

5. UNIX for Dummies Questions & Answers

Date conversion in ab i

(string(8)) ((date("YYYYMMDD")) ((date("YYYY/MM/DD")) in.date_field_name)) (1 Reply)
Discussion started by: dr46014
1 Replies

6. Shell Programming and Scripting

Julian date to Calendar date conversion

Hi all, I require to convert julian date to normal calander date in unix for eg julian date=122 now i want corresponding calander date ---------------------------------------- gr8 if give very small command/script and please explain the steps as well(imp) Thanks ... (3 Replies)
Discussion started by: RahulJoshi
3 Replies

7. Shell Programming and Scripting

ksh compare dates INSIDE a file (ie date A is > date B)

In KSH, I am pasting 2 almost identical files together and each one has a date and time on each line. I need to determine if the first instance of the date/time is greater than the 2nd instance of the date/time. If the first instance is greater, I just need to echo that line. I thought I would... (4 Replies)
Discussion started by: right_coaster
4 Replies

8. AIX

Date Conversion

Hi, I would like to change the incoming date format (Jun 25 2010) to 06/25/2010. I have seen date "dconv" function but i am not sure how that works. $ echo "Jun 25 2010" | nawk ' { months=" JanFebMarAprMayJunJulAugSepOctNovDec";date=$1;month=index(months,substr($1,1,3))/3; ... (3 Replies)
Discussion started by: Prashanth B
3 Replies

9. Shell Programming and Scripting

Date Conversion

Hi I want to convert date from one format to the other i.e. From Thu Mar 6 15:57:39 2014 To 2014-03-06 15:57:39 Is there any direct command to implement this ? (1 Reply)
Discussion started by: tostay2003
1 Replies

10. Shell Programming and Scripting

Shell script to compare two files of todays date and yesterday's date

hi all, How to compare two files whether they are same are not...? like i had my input files as 20141201_file.txt and 20141130_file2.txt how to compare the above files based on date .. like todays file and yesterdays file...? (4 Replies)
Discussion started by: hemanthsaikumar
4 Replies

LEARN ABOUT CENTOS

dm_date

DM_DATE(1)						User Contributed Perl Documentation						DM_DATE(1)

NAME

       dm_date - print out the system date and time

SYNOPSIS

       This performs the same operation as the unix 'date' command, but using the Date::Manip module.

	  dm_date [OPTION]... [+FORMAT]

DESCRIPTION

       This displays information about the current system time, or some other time. Options are:

       -h, --help
	   Print online help.

       -d STRING, --date=STRING
	   Display time described by STRING. STRING can be any string which can be parsed by Date::Manip.  Please refer to the Date::Manip::Date
	   documentation for details.

       -f DATEFILE, --file=DATEFILE
	   This reads each line in DATEFILE, and extracts a date from it and prints out the information.

	   Blank lines and lines starting with a pound (#) are ignored. Lines not containing a valid date are also ignored.

       -r FILE, --reference=FILE
	   Displays the last modification time of FILE.

       -R, --rfc-2822
	   Displayc the date and time in RFC 2822 format.

	   Example: Mon, 07 Aug 2006 12:34:56 -0600

       -u, --utc, --universal
	   Converts the date to UT (GMT) and prints out the information.

       Only one of -d, -f, or -r should be included. If more than one is included, the first one from the list (-d, -f, -r) is used and any other
       is ignored.

       The format string starts with a plus (+) and contains any of the format directives described in Date::Manip::Date.

KNOWN BUGS

       None known.

BUGS AND QUESTIONS

       Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author.

SEE ALSO

       Date::Manip::Date

LICENSE

       This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHOR

       Sullivan Beck (sbeck@cpan.org)

perl v5.16.3							    2014-06-09								DM_DATE(1)
All times are GMT -4. The time now is 09:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy