Sponsored Content
Full Discussion: Convert date format
Top Forums UNIX for Dummies Questions & Answers Convert date format Post 302221181 by Annihilannic on Sunday 3rd of August 2008 09:46:41 PM
Old 08-03-2008
It's not pre-Y2K compliant, but you could do something with sed like this:

Code:
d="17-JUL-08"
echo $d | sed '
        s/\(..\)-\(...\)-\(..\)/20\3\2\1/
        s/JAN/01/
        s/FEB/02/
        s/MAR/03/
        s/APR/04/
        s/MAY/05/
        s/JUN/06/
        s/JUL/07/
        s/AUG/08/
        s/SEP/09/
        s/OCT/10/
        s/NOV/11/
        s/DEC/12/
'

 

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

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

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

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

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

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

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

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

10. Shell Programming and Scripting

Convert date format

Hi guys I am looking to convert this kind of entry in a txt file 26/04/2008 to April 2008 Note : this is not using the date command , these are date entries in a file can i do this with sed ? Use code tags, thanks. (5 Replies)
Discussion started by: johnnybananas
5 Replies
SWISS::DTs(3pm) 					User Contributed Perl Documentation					   SWISS::DTs(3pm)

Name
       SWISS::DTs

Description
       SWISS::DTs represents the DT lines within an Swiss-Prot + TrEMBL entry as specified in the user manual
       http://www.expasy.org/sprot/userman.html .

Inherits from
       SWISS::BaseClass.pm

Attributes
       "CREATED_date"
	   Creation date

       "ANN_date"
	   Last annotation update

       "SQ_date"
	   Last Sequence update

       "CREATED_rel"
	   Created for release

       "ANN_rel"
	   Last annotation for release

       "SQ_rel"
	   Last sequence update for release

       "ANN_version"
	   Version number for entry annotation

       "SQ_version"
	   Version number for sequence

Methods
   Standard methods
       new
       fromText
       toText
       sort

   Writing methods
       set_Created ($date, $release)
       set_AnnotationUpdate ($date, $release[, $version])
       set_SequenceUpdate ($date, $release[, $version])

TRANSITION
The format of the DT line will change in early 2004 from: DT 01-JUL-1993 (Rel. 26, Created) DT 01-JUL-1993 (Rel. 26, Last sequence update) DT 28-FEB-2003 (Rel. 41, Last annotation update) to: DT 01-JUL-1993, integrated into UniProtKB/Swiss-Prot. DT 01-JUL-1993, sequence version 36. DT 28-FEB-2003, entry version 54. This module supports both formats. To convert an entry from the old to the new format, do: $entry->DTs->CREATED_rel("UniProtKB/Swiss-Prot"); $entry->DTs->ANN_version(54); $entry->DTs->SQ_version(36); perl v5.10.1 2008-07-11 SWISS::DTs(3pm)
All times are GMT -4. The time now is 09:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy