Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Compare a date (mm/dd/yyyy) with awk Post 303035660 by vgersh99 on Thursday 30th of May 2019 11:49:20 AM
Old 05-30-2019
convert MM/DD/YYYY to YYYYMMDD and compare numerically.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date Vadidation in YYYY-MM-DD

Date Vadidation in YYYY-MM-DD Hi , Please, Help me in validating given date that is passed in arg as YYYY-MM-DD. It should cover check 1 <= DD <= 31 and 1 <= MM <= 12 for each mm check 1 <=DD<= {28,30,31} (depending) for someYYYY and MM== 02 check 1 <= dd <= 29 I the... (1 Reply)
Discussion started by: itsmehihihi
1 Replies

2. Shell Programming and Scripting

Change Date from dd-mmm-yyyy to mm/dd/yyyy

I want to change a date from format dd-mmm-yyyy to mm/dd/yyyy. Is there a way to do this with sed or do you have to write a case statement to convert JAN to 01? Thanks (9 Replies)
Discussion started by: stringzz
9 Replies

3. Shell Programming and Scripting

converting the date field from dd/mm/yyyy to yyyy/mm/dd

How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix my script will generate text file which have two fields one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will... (4 Replies)
Discussion started by: pareshan
4 Replies

4. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

(Attention: Green PHP newbie !) I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Discussion started by: keyboarder
6 Replies

5. Shell Programming and Scripting

Converting date DD MM YYYY to DD MON YYYY

Hello, I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10) To extract the dates, I am using shell substrings, i.e.: read line ... (4 Replies)
Discussion started by: Adamm
4 Replies

6. Shell Programming and Scripting

awk compare column with date format

I have this code to compare columns 1 and 10 between file1 and file 2 and give me all records that match column 1 but dont match column 10 However column 10 is date format mm/dd/yy and awk cant read it and compare ...i tried awk < file1 -F~ '{print $10}' and it gave blank screen Is... (1 Reply)
Discussion started by: sigh2010
1 Replies

7. Shell Programming and Scripting

Need date in the format [mm dd yyyy hh AM/PM]

could you please help be on the below code .. Requirement is when i pass the parameter(for below 2) i should get current time -2 hours in the format :wall:.. cur_dt=`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID -P $PASSWD -h -C"select getdate()" | sed '2d'` pr_dt="`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID... (2 Replies)
Discussion started by: karthicss
2 Replies

8. Shell Programming and Scripting

Date conversion help from dd/mm/yyyy to dd/Mon/yyyy i.e. 28/10/2012 to 28/Oct/2012

Hi I have a problem with Date format in my code. 1st I am trying to convert today's date to yesterday's using YESTERDAY3=`perl -e '@y=localtime(time()-86400); printf "%04d/%02d/%02d",$y+1900,$y+1,$y;$y;'` And once it is done I am trying to using the yesterday date in a grep command to... (3 Replies)
Discussion started by: nithinankam
3 Replies

9. UNIX for Dummies Questions & Answers

Epoch date to YYYY/MM/DD or MM/DD/YYYY

I've seen a lot of posts on this and have tried the following: echo 1257000000| perl -e '($d,$m,$y)=(localtime(time-86400));$m+=1;$y+=1900;printf "$y/$m/$d\n";' But I am unable to convert a past Epoch date into a format such as YYYY/MM/DD or MM/DD/YYYY. I am using bash and don't know... (4 Replies)
Discussion started by: newbie2010
4 Replies

10. Shell Programming and Scripting

Date format YYYY/MM/DD to DD/MM/YYYY

I am getting output of YYYY-MM-DD and want to change this to DD/MM/YYYY. When am running the query in 'Todd' to_date(column_name,'DD/MM/YYYY') am getting the required o/p of DD/MM/YYYY, But when am executing the same query(Netezza) in linux server(bash) am getting the output of YYYY-MM-DD file... (3 Replies)
Discussion started by: Roozo
3 Replies
DateTime::Format::ISO8601(3pm)				User Contributed Perl Documentation			    DateTime::Format::ISO8601(3pm)

NAME
DateTime::Format::ISO8601 - Parses ISO8601 formats SYNOPSIS
use DateTime::Format::ISO8601; my $dt = DateTime::Format::ISO8601->parse_datetime( $str ); my $dt = DateTime::Format::ISO8601->parse_time( $str ); or my $iso8601 = DateTime::Format::ISO8601->new; my $dt = $iso8601->parse_datetime( $str ); my $dt = $iso8601->parse_time( $str ); DESCRIPTION
Parses almost all ISO8601 date and time formats. ISO8601 time-intervals will be supported in a later release. USAGE
Import Parameters This module accepts no arguments to it's "import" method. Methods Constructors o new( ... ) Accepts an optional hash. my $iso8601 = DateTime::Format::ISO8601->new( base_datetime => $dt, cut_off_year => 42, legacy_year => 1, ); o base_datetime A "DateTime" object that will be used to fill in missing information from incomplete date/time formats. This key is optional. o cut_off_year A integer representing the cut-off point between interpreting 2-digits years as 19xx or 20xx. 2-digit years < legacy_year will be interpreted as 20xx 2-digit years >= legacy_year will be untreated as 19xx This key defaults to the value of "DefaultCutOffYear". o legacy_year A boolean value controlling if a 2-digit year is interpreted as being in the current century (unless a "base_datetime" is set) or if "cut_off_year" should be used to place the year in either 20xx or 19xx. This key defaults to the value of "DefaultLegacyYear". o clone Returns a replica of the given object. Object Methods o base_datetime Returns a "DateTime" object if a "base_datetime" has been set. o set_base_datetime( object => $object ) Accepts a "DateTime" object that will be used to fill in missing information from incomplete date/time formats. o cut_off_year Returns a integer representing the cut-off point between interpreting 2-digits years as 19xx or 20xx. o set_cut_off_year( $int ) Accepts a integer representing the cut-off point between interpreting 2-digits years as 19xx or 20xx. 2-digit years < legacy_year will be interpreted as 20xx 2-digit years >= legacy_year will be interpreted as 19xx o legacy_year Returns a boolean value indicating the 2-digit year handling behavior. o set_legacy_year( $bool ) Accepts a boolean value controlling if a 2-digit year is interpreted as being in the current century (unless a "base_datetime" is set) or if "cut_off_year" should be used to place the year in either 20xx or 19xx. Class Methods o DefaultCutOffYear( $int ) Accepts a integer representing the cut-off point for 2-digit years when calling "parse_*" as class methods and the default value for "cut_off_year" when creating objects. If called with no parameters this method will return the default value for "cut_off_year". o DefaultLegacyYear( $bool ) Accepts a boolean value controlling the legacy year behavior when calling "parse_*" as class methods and the default value for "legacy_year" when creating objects. If called with no parameters this method will return the default value for "legacy_year". Parser(s) These may be called as either class or object methods. o parse_datetime o parse_time Please see the "FORMATS" section. FORMATS
There are 6 string that can match against date only or time only formats. The "parse_datetime" method will attempt to match these ambiguous strings against date only formats. If you want to match against the time only formats see the "parse_time" method. Conventions o Expanded ISO8601 These formats are supported with exactly 6 digits for the year. Support for a variable number of digits will be in a later release. o Precision If a format doesn't include a year all larger time unit up to and including the year are filled in using the current date/time or [if set] the "base_datetime" object. o Fractional time There is no limit on the expressed precision. Supported via parse_datetime The supported formats are listed by the section of ISO 8601:2000(E) in which they appear. 5.2 Dates 5.2.1.1 YYYYMMDD YYYY-MM-DD 5.2.1.2 YYYY-MM YYYY YY 5.2.1.3 YYMMDD YY-MM-DD -YYMM -YY-MM -YY --MMDD --MM-DD --MM ---DD 5.2.1.4 +[YY]YYYYMMDD +[YY]YYYY-MM-DD +[YY]YYYY-MM +[YY]YYYY +[YY]YY 5.2.2.1 YYYYDDD YYYY-DDD 5.2.2.2 YYDDD YY-DDD -DDD 5.2.2.3 +[YY]YYYYDDD +[YY]YYYY-DDD 5.3.2.1 YYYYWwwD YYYY-Www-D 5.2.3.2 YYYYWww YYYY-Www YYWwwD YY-Www-D YYWww YY-Www -YWwwD -Y-Www-D -YWww -Y-Www -WwwD -Www-D -Www -W-D 5.2.3.4 +[YY]YYYYWwwD +[YY]YYYY-Www-D +[YY]YYYYWww +[YY]YYYY-Www 5.3 Time of Day 5.3.1.1 - 5.3.1.3 optionally prefixed with 'T' 5.3.1.1 hh:mm:ss 5.3.1.2 hh:mm 5.3.1.3 - 5.3.1.4 fractional (decimal) separator maybe either ',' or '.' 5.3.1.3 hhmmss,ss hh:mm:ss,ss hhmm,mm hh:mm,mm hh,hh 5.3.1.4 -mm:ss -mmss,s -mm:ss,s -mm,m --ss,s 5.3.3 - 5.3.4.2 optionally prefixed with 'T' 5.3.3 hhmmssZ hh:mm:ssZ hhmmZ hh:mmZ hhZ hhmmss.ssZ hh:mm:ss.ssZ 5.3.4.2 hhmmss[+-]hhmm hh:mm:ss[+-]hh:mm hhmmss[+-]hh hh:mm:ss[+-]hh hhmmss.ss[+-]hhmm hh:mm:ss.ss[+-]hh:mm 5.4 Combinations of date and time of day 5.4.1 YYYYMMDDThhmmss YYYY-MM-DDThh:mm:ss YYYYMMDDThhmmssZ YYYY-MM-DDThh:mm:ssZ YYYYMMDDThhmmss[+-]hhmm YYYY-MM-DDThh:mm:ss[+-]hh:mm YYYYMMDDThhmmss[+-]hh YYYY-MM-DDThh:mm:ss[+-]hh 5.4.2 YYYYMMDDThhmmss.ss YYYY-MM-DDThh:mm:ss.ss YYYYMMDDThhmmss.ss[+-]hhmm YYYY-MM-DDThh:mm:ss.ss[+-]hh:mm Support for this section is not complete. YYYYMMDDThhmm YYYY-MM-DDThh:mm YYYYDDDThhmmZ YYYY-DDDThh:mmZ YYYYWwwDThhmm[+-]hhmm YYYY-Www-DThh:mm[+-]hh 5.5 Time-Intervals Will be supported in a later release. Supported via parse_time 5.3.1.1 - 5.3.1.3 optionally prefixed with 'T' 5.3.1.1 hhmmss 5.3.1.2 hhmm hh 5.3.1.4 -mmss -mm --ss STANDARDS DOCUMENT
Title ISO8601:2000(E) Data elements and interchange formats - information exchange - Representation of dates and times Second edition 2000-12-15 Reference Number ISO/TC 154 N 362 CREDITS
Iain 'Spoon' Truskett (SPOON) who wrote DateTime::Format::Builder. That has grown into The Vacuum Energy Powered "Swiss Army" Katana of date and time parsing. This module was inspired by and conceived in honor of Iain's work. Tom Phoenix (PHOENIX) and PDX.pm for helping me solve the ISO week conversion bug. Not by fixing the code but motivation me to fix it so I could participate in a game of "Zendo". Jonathan Leffler (JOHNL) for reporting a test bug. Kelly McCauley for a patch to add 8 missing formats. Alasdair Allan (AALLAN) for complaining about excessive test execution time. Everyone at the DateTime "Asylum". SUPPORT
Support for this module is provided via the <datetime@perl.org> email list. See <http://lists.perl.org/> for more details. AUTHOR
Joshua Hoblitt <jhoblitt@cpan.org> COPYRIGHT
Copyright (c) 2003-2005 Joshua Hoblitt. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the licenses can be found in the LICENSE file included with this module, or in perlartistic and perlgpl as supplied with Perl 5.8.1 and later. SEE ALSO
DateTime, DateTime::Format::Builder, <http://datetime.perl.org/> perl v5.14.2 2012-02-12 DateTime::Format::ISO8601(3pm)
All times are GMT -4. The time now is 07:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy