Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Format date from MM/DD/YYYY to YYYYMMDD Post 302300680 by vidyadhar85 on Tuesday 24th of March 2009 06:54:50 PM
Old 03-24-2009
i know its not valid
this will do but it may fail for some other data
Code:
sed 's/\([0-9][0-9]\)\/\([0-9]\)\/\(....\)/\3\10\2/g;s/\([0-9]\)\/\([0-9]\)\/\(....\)/\30\10\2/g' filename

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

get yesterday date in yyyymmdd format

I would like to know how I could get a yesterday date in yyyymmdd e.g. today is 20011109, and I would like to get 20011108. Thank you!:confused: (2 Replies)
Discussion started by: hk_newbie
2 Replies

2. HP-UX

How can i get the yesterday's date in YYYYMMDD format

How can i get the yesterday's date in YYYYMMDD format??? (4 Replies)
Discussion started by: prasadsr
4 Replies

3. Shell Programming and Scripting

convert date format YYYYMMDD to MM/DD/YYYY

In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY. Thanks. (8 Replies)
Discussion started by: nasirgondal
8 Replies

4. Shell Programming and Scripting

PERL String to Date (Custom format yyyymmdd to dd-mon-yyyy)

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

5. Solaris

Date after 5 dates in YYYYMMDD format

Hi Experts, How to get date 5 days after current date in YYYYMMDD format? How do we compare date in YYYYMMDD format? Thanks (1 Reply)
Discussion started by: needyourhelp10
1 Replies

6. Shell Programming and Scripting

Date after 5 days from current date in YYYYMMDD format

Hello Experts, How do i get date after 5 days from current date in YYYYMMDD format? How do you compare date in YYYYMMDD format? Thanks (8 Replies)
Discussion started by: needyourhelp10
8 Replies

7. 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

8. Shell Programming and Scripting

Converting Date from YYYYMMDD to DD-MON-YYYY

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

9. 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

10. Programming

Date format change from mm/dd/yyyy to yyyymmdd in comma seperate line in perl

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
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 04:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy