10 More Discussions You Might Find Interesting
1. Solaris
Hi All
I need help in converting a string of YYYYMMDD format to date in Sun OS and then find out if the day is a Wednesday or not. The "date -d" option is not working and your help is much appreciated.
The date command usage from the operating system we use here is as follows:
Thanks,
SK (11 Replies)
Discussion started by: SK123
11 Replies
2. Shell Programming and Scripting
Hi All
I need help in converting a string of YYYYMMDD format to date in Sun OS and then find out if the day is a Wednesday or not. The "date -d" option is not working and your help is much appreciated.
The date command usage from the operating system we use here is as follows:
usage: ... (1 Reply)
Discussion started by: SK123
1 Replies
3. Programming
Hi All,
I have line
,A,FDRM0002,12/21/2017,,0.961751583,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
it contains date in mm/dd/yyyy format i want to change this to yyyymmdd format using perl.
Use code tags, thanks. (8 Replies)
Discussion started by: vishal0746
8 Replies
4. Shell Programming and Scripting
Hello All,
I have a date in DD/MM/YYYY format. I am trying to convert this into unix timestamp. I have tried following:
date -d $mydate +%s
where mydate = 23/12/2016 00:00:00
I am getting following error:
date: extra operand `+%s'
Try `date --help' for more information.
... (1 Reply)
Discussion started by: angshuman
1 Replies
5. Shell Programming and Scripting
Hi All,
I have file like
“April 10, 2013”,”raj”
“April 29, 2013”,”raj1”
Output :
“2013/04/10”,”raj”
“2013/04/29”,”raj1”
Please help me how to do... (9 Replies)
Discussion started by: bmk
9 Replies
6. Shell Programming and Scripting
How can I convert any user inputted date into yyyy/mm/dd ?
For example user can input date one of the following 20120121 , 2012-01-21 ,01/21/2012,01/21/2012 etc
But I need to convert any of the date entered by user into yyyy/mm/dd (2012/01/2012). Any suggestion. Thanks in advance
this is... (1 Reply)
Discussion started by: ZeroHedge
1 Replies
7. Shell Programming and Scripting
Hi , I need to convert date from YYYYMMDD to DD-MON-YYYY
e.g
20111214 to 14-Dec-2011
Please help. (17 Replies)
Discussion started by: ady_koolz
17 Replies
8. Shell Programming and Scripting
Hi All,
I am learning PERL for one of the projects, and in one of these scripts, I read a flat text file and print in the terminal.
The problem is, the text file has a date field. The format is yyyymmdd. I need to display this as dd-mon-yyyy.
Any ideas to do this? Thanks a lot for the... (9 Replies)
Discussion started by: guruparan18
9 Replies
9. UNIX for Dummies Questions & Answers
I have a file with some date columns in MM/DD/YYYY format:
SMPBR|DUP-DO NOT USE|NEW YORK||16105|BA5270715|6/6/2007 |MWERNER|109||||JOHN||SMITH|MD|72211118||||||74559|21 WILMINGTON RD||D|11/6/2003|SL# MD CONTACT-LIZ RICHARDS|||0|Y|N||1411458|
And I want to convert the date format to:
... (5 Replies)
Discussion started by: ChicagoBlues
5 Replies
10. UNIX for Dummies Questions & Answers
how to convert the string YYYYMMDD into YYYY.MM.DD
Please advice (1 Reply)
Discussion started by: spatra
1 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)