Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert date format
Top Forums Shell Programming and Scripting Convert date format Post 302956899 by zaxxon on Monday 5th of October 2015 07:52:08 AM
Old 10-05-2015
Please use code tags for posting data, logs etc.
Also post 2-3 example lines of your data please, so that we can easier avoid pitfalls and provide a better solution.

Blind shot:

Code:
$ cat infile
03/02/2008 [AA] This is some data here.
26/04/2008 [BB] This is some data here.
$ sed '
s,/01/, January ,g
s,/02/, February ,g
s,/03/, March ,g
s,/04/, April ,g
' infile
03 February 2008 [AA] This is some data here.
26 April 2008 [BB] This is some data here.

This User Gave Thanks to zaxxon For This Post:
johnnybananas
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert mmddyy date format to ccyyddd format??

hi, for reading a cobol indexed file i need to convert "mmddyy" date format to "ccyyddd" format. i checked the datecalc and other scripts but couldnt modify them to cater to my need:(... The datecalc gives an output which i believe is the total days till that date, but i want to convert it... (2 Replies)
Discussion started by: Bhups
2 Replies

2. UNIX for Dummies Questions & Answers

Convert date format

Hi All, Need your help in converting a date format in ksh. I'm currently working on SUN os where my script is getting a date from a table. The result returns to ksh in this format: 17-JUL-08 How do i convert this string to a date format like yyyymmdd? I tried #!/bin/ksh d="17-JUL-08"... (5 Replies)
Discussion started by: agathaeleanor
5 Replies

3. Shell Programming and Scripting

Convert Epoch time format to normal date time format in the same file

I have a file named "suspected" with series of line like these : {'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''} {'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies

4. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

5. Shell Programming and Scripting

Convert date to Unix format

Dear Expert How to convert date in format of YYYY-MM-DD HH:MM:SS to unix format using a script or command if avaliable Example "2011-05-15 18:00:00" is converted to 1330970400 I tried to use option d in date command but no use, Im using solaris 10 Thanks a lot (12 Replies)
Discussion started by: yahyaaa
12 Replies

6. Shell Programming and Scripting

convert date format

I've been using this thread: https://www.unix.com/shell-programming-scripting/58675-change-date-dd-mmm-yyyy-mm-dd-yyyy.html and https://www.unix.com/shell-programming-scripting/14655-changing-yyyy-mm-dd-ddmmyy.html and this code: on this format: 05/16/2008 18:30:49 Installation 48985and I'm... (3 Replies)
Discussion started by: dba_frog
3 Replies

7. Shell Programming and Scripting

Convert any date format into yyyy/mm/dd

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

8. Shell Programming and Scripting

awk convert date format

Could you tell me how to convert the following dates? If I have m/d/yyyy, I want to have 0m/0d/yyyy. I want my dates to always be 8 digits. In other words, I want a 0 inserted whenever the month or day is a single digit. My issue is first I need to use FS="," to get field $4 for the... (7 Replies)
Discussion started by: wbrunc
7 Replies

9. Shell Programming and Scripting

Convert string into date format

Hi, I am getting the below string as a input for date. 12/03/2013 11:02 AM I want to change this date as 03-DEC-2013 11:02 AM. Could you please help on this. Thanks Chelladurai (4 Replies)
Discussion started by: ckchelladurai
4 Replies

10. Shell Programming and Scripting

Convert Date Format

Hello, I want to change the format of date value in variable. e.g. cur_date = '2013/03/13 14:24:50' (yyyy/mm/dd hh24:mi:ss) I want to change this to '13-MAR-2013 14:24:50 Following code coverts the current date to format I am looking for. But I do not know how this can be done for a date... (8 Replies)
Discussion started by: cartrider
8 Replies

LEARN ABOUT MOJAVE

datetime::locale::sid_et

DateTime::Locale::sid_ET(3)				User Contributed Perl Documentation			       DateTime::Locale::sid_ET(3)

NAME

       DateTime::Locale::sid_ET

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'sid_ET' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Sidamo Ethiopia.

DATA

       This locale inherits from the DateTime::Locale::sid locale.

       It contains the following data.

   Days
       Wide (format)

	 Sanyo
	 Maakisanyo
	 Roowe
	 Hamuse
	 Arbe
	 Qidaame
	 Sambata

       Abbreviated (format)

	 San
	 Mak
	 Row
	 Ham
	 Arb
	 Qid
	 Sam

       Narrow (format)

	 S
	 M
	 R
	 H
	 A
	 Q
	 S

       Wide (stand-alone)

	 Sanyo
	 Maakisanyo
	 Roowe
	 Hamuse
	 Arbe
	 Qidaame
	 Sambata

       Abbreviated (stand-alone)

	 San
	 Mak
	 Row
	 Ham
	 Arb
	 Qid
	 Sam

       Narrow (stand-alone)

	 S
	 M
	 R
	 H
	 A
	 Q
	 S

   Months
       Wide (format)

	 January
	 February
	 March
	 April
	 May
	 June
	 July
	 August
	 September
	 October
	 November
	 December

       Abbreviated (format)

	 Jan
	 Feb
	 Mar
	 Apr
	 May
	 Jun
	 Jul
	 Aug
	 Sep
	 Oct
	 Nov
	 Dec

       Narrow (format)

	 J
	 F
	 M
	 A
	 M
	 J
	 J
	 A
	 S
	 O
	 N
	 D

       Wide (stand-alone)

	 January
	 February
	 March
	 April
	 May
	 June
	 July
	 August
	 September
	 October
	 November
	 December

       Abbreviated (stand-alone)

	 Jan
	 Feb
	 Mar
	 Apr
	 May
	 Jun
	 Jul
	 Aug
	 Sep
	 Oct
	 Nov
	 Dec

       Narrow (stand-alone)

	 J
	 F
	 M
	 A
	 M
	 J
	 J
	 A
	 S
	 O
	 N
	 D

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BCE
	 CE

       Abbreviated

	 YIA
	 YIG

       Narrow

	 YIA
	 YIG

   Date Formats
       Full

	  2008-02-05T18:30:30 = Maakisanyo, February 05, 2008
	  1995-12-22T09:05:02 = Arbe, December 22, 1995
	 -0010-09-15T04:44:23 = Qidaame, September 15, -10

       Long

	  2008-02-05T18:30:30 = 05 February 2008
	  1995-12-22T09:05:02 = 22 December 1995
	 -0010-09-15T04:44:23 = 15 September -10

       Medium

	  2008-02-05T18:30:30 = 05-Feb-2008
	  1995-12-22T09:05:02 = 22-Dec-1995
	 -0010-09-15T04:44:23 = 15-Sep--10

       Short

	  2008-02-05T18:30:30 = 05/02/08
	  1995-12-22T09:05:02 = 22/12/95
	 -0010-09-15T04:44:23 = 15/09/-10

       Default

	  2008-02-05T18:30:30 = 05-Feb-2008
	  1995-12-22T09:05:02 = 22-Dec-1995
	 -0010-09-15T04:44:23 = 15-Sep--10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 6:30:30 hawwaro UTC
	  1995-12-22T09:05:02 = 9:05:02 soodo UTC
	 -0010-09-15T04:44:23 = 4:44:23 soodo UTC

       Long

	  2008-02-05T18:30:30 = 6:30:30 hawwaro UTC
	  1995-12-22T09:05:02 = 9:05:02 soodo UTC
	 -0010-09-15T04:44:23 = 4:44:23 soodo UTC

       Medium

	  2008-02-05T18:30:30 = 6:30:30 hawwaro
	  1995-12-22T09:05:02 = 9:05:02 soodo
	 -0010-09-15T04:44:23 = 4:44:23 soodo

       Short

	  2008-02-05T18:30:30 = 6:30 hawwaro
	  1995-12-22T09:05:02 = 9:05 soodo
	 -0010-09-15T04:44:23 = 4:44 soodo

       Default

	  2008-02-05T18:30:30 = 6:30:30 hawwaro
	  1995-12-22T09:05:02 = 9:05:02 soodo
	 -0010-09-15T04:44:23 = 4:44:23 soodo

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = Maakisanyo, February 05, 2008 6:30:30 hawwaro UTC
	  1995-12-22T09:05:02 = Arbe, December 22, 1995 9:05:02 soodo UTC
	 -0010-09-15T04:44:23 = Qidaame, September 15, -10 4:44:23 soodo UTC

       Long

	  2008-02-05T18:30:30 = 05 February 2008 6:30:30 hawwaro UTC
	  1995-12-22T09:05:02 = 22 December 1995 9:05:02 soodo UTC
	 -0010-09-15T04:44:23 = 15 September -10 4:44:23 soodo UTC

       Medium

	  2008-02-05T18:30:30 = 05-Feb-2008 6:30:30 hawwaro
	  1995-12-22T09:05:02 = 22-Dec-1995 9:05:02 soodo
	 -0010-09-15T04:44:23 = 15-Sep--10 4:44:23 soodo

       Short

	  2008-02-05T18:30:30 = 05/02/08 6:30 hawwaro
	  1995-12-22T09:05:02 = 22/12/95 9:05 soodo
	 -0010-09-15T04:44:23 = 15/09/-10 4:44 soodo

       Default

	  2008-02-05T18:30:30 = 05-Feb-2008 6:30:30 hawwaro
	  1995-12-22T09:05:02 = 22-Dec-1995 9:05:02 soodo
	 -0010-09-15T04:44:23 = 15-Sep--10 4:44:23 soodo

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 Mak
	  1995-12-22T09:05:02 = 22 Arb
	 -0010-09-15T04:44:23 = 15 Qid

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 hawwaro
	  1995-12-22T09:05:02 = 9:05 soodo
	 -0010-09-15T04:44:23 = 4:44 soodo

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 hawwaro
	  1995-12-22T09:05:02 = 9:05:02 soodo
	 -0010-09-15T04:44:23 = 4:44:23 soodo

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = Mak, 2-5
	  1995-12-22T09:05:02 = Arb, 12-22
	 -0010-09-15T04:44:23 = Qid, 9-15

       MMdd (dd/MM)

	  2008-02-05T18:30:30 = 05/02
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/09

       MMM (LLL)

	  2008-02-05T18:30:30 = Feb
	  1995-12-22T09:05:02 = Dec
	 -0010-09-15T04:44:23 = Sep

       MMMd (MMM d)

	  2008-02-05T18:30:30 = Feb 5
	  1995-12-22T09:05:02 = Dec 22
	 -0010-09-15T04:44:23 = Sep 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = Mak Feb 5
	  1995-12-22T09:05:02 = Arb Dec 22
	 -0010-09-15T04:44:23 = Qid Sep 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = February 5
	  1995-12-22T09:05:02 = December 22
	 -0010-09-15T04:44:23 = September 15

       MMMMdd (dd MMMM)

	  2008-02-05T18:30:30 = 05 February
	  1995-12-22T09:05:02 = 22 December
	 -0010-09-15T04:44:23 = 15 September

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = Mak February 5
	  1995-12-22T09:05:02 = Arb December 22
	 -0010-09-15T04:44:23 = Qid September 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = Mak, 2008-2-5
	  1995-12-22T09:05:02 = Arb, 1995-12-22
	 -0010-09-15T04:44:23 = Qid, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 Feb
	  1995-12-22T09:05:02 = 1995 Dec
	 -0010-09-15T04:44:23 = -10 Sep

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = Mak, 2008 Feb 5
	  1995-12-22T09:05:02 = Arb, 1995 Dec 22
	 -0010-09-15T04:44:23 = Qid, -10 Sep 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 February
	  1995-12-22T09:05:02 = 1995 December
	 -0010-09-15T04:44:23 = -10 September

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyMM (MM/yy)

	  2008-02-05T18:30:30 = 02/08
	  1995-12-22T09:05:02 = 12/95
	 -0010-09-15T04:44:23 = 09/-10

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = February 2008
	  1995-12-22T09:05:02 = December 1995
	 -0010-09-15T04:44:23 = September -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       Qidaame

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06					       DateTime::Locale::sid_ET(3)
All times are GMT -4. The time now is 12:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy