Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

ddmmyyyy to dd-mmm-yy format?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting ddmmyyyy to dd-mmm-yy format?
# 1  
Old 02-17-2006
ddmmyyyy to dd-mmm-yy format?
Hi All,

Can anyone tell me a simple way of converting a date in ddmmyyyy format to dd-mmm-yy format.
For example

17022006 to 17-FEB-06

Thanks in advance

Regards,
Gaurav
# 2  
Old 02-17-2006
Code:
$date '+DATE: %d%m%Y'
DATE: 17022006

Rahul.
# 3  
Old 02-17-2006
Hi Rahul,

Can you elaborate a bit more, seems you got my question wrong.

I have date in variable in the ddmmyyyy format for example 17022006
now i want to convert this into ddmmmyy format so that i get 17-FEB-06

Regards,
Gaurav
# 4  
Old 02-17-2006
Code:
# !/usr/bin/bash

a=$1
mon=""

case `echo ${a:2:2}` in
01)   mon=Jan ;;
07)   mon=Jul ;;
*)    mon=ERR
esac

echo ${a:0:2}-$mon-${a:6:2}
exit 0

just fill out for the remaining months
# 5  
Old 02-17-2006
Small code in terms of lines, but only if you have Oracle installed.

Code:
var=170206
OUTPUT=$(sqlplus -silent ${DBUSER}/${DBPASS}@${ORACLE_SID} << DONE
set pages 0 feedback off
select to_char(to_date($var,'DDMMYY'),'DD-MON-YYYY') from Dual;
DONE)
echo $OUTPUT

Hope this is what you were looking for.

Thanks.
Rahul.
Last edited by rahulrathod; 02-17-2006 at 09:29 AM..
# 6  
Old 02-17-2006
Thanks a lot Rahul and Madhan for your help,
I will be using the case structure as suggested by madhan

Regards,
Gaurav
# 7  
Old 08-28-2007
Fyi
# yyyymmdd_HHMMSS
export FORMATTED_DATE=`date '+20%y%m%d_%H%M%S'`
echo ${FORMATTED_DATE}

# dd-mm-yyyy
export FORMATTED_DATE=`date '+%d-%m-20%y'`
echo ${FORMATTED_DATE}

# dd-mmm-yyyy
export FORMATTED_DATE=`date | cut -f3 -d' '`-`date | cut -f2 -d' '`-`date | cut -f6 -d' '`
echo ${FORMATTED_DATE}
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Command to check date format DDMMYYYY

Record: Record1|Record2|Record3|Record4|Record5|DATE1|DATE2 Need to Check DATE1 & DATE2 is in DDMMYYYY format in a file. records which not meet the date format DDMMYYYY extract to other file. (1 Reply)
Discussion started by: vivekn
1 Replies

2. UNIX for Advanced & Expert Users

How to convert mmm-yy to mm/dd/yyyy format in UNIX ?

How to convert mmm-yy to mm/dd/yyyy format in unix ? example: Jan-99 to 01/01/1999 Jan-00 to 01/01/2000 Jan-25 to 01/01/2025 Dec-99 to 01/12/1999 Dec-00 to 01/12/2000 Dec-25 to 01/12/2025 YY anything between 00-50 should be 2000-2050 YY anything between 51-99 should be 1951-1999 ... (2 Replies)
Discussion started by: gksenthilkumar
2 Replies

3. Shell Programming and Scripting

Date format to be changed from DDMMYYYY to YYYYMMDD

My requirement is:- there will be files at a location each day with the date format DDMMYYYY. Novawise_Activity_Call_Notes_04022013.txt Novawise_Activity_Inbound_04022013.txt Novawise_Activity_Inbound_05022013.txt Novawise_Activity_Call_Notes_05022013.txt... (8 Replies)
Discussion started by: djrulz123
8 Replies

4. Shell Programming and Scripting

perl one-liner to get yesterday's date in format dd-MMM-yy (i.e. 01-JAN-12)

I have the following perl one-liner to get yesterday's date, but I would like it in the form of dd-MMM-yy (for example: 01-JAN-12). Can someone alter the below code so I get the format I want? Also, could someone also give me a line for dd-Mmm-yy (for example 01-Jan-12)? Code: YEST=`perl -w... (3 Replies)
Discussion started by: thibodc
3 Replies

5. Shell Programming and Scripting

reformat HHMMSSmmm into HH:MM:SS.mmm

I have a bunch of logs where the timestamp hours, minutes, seconds and milliseconds all together without a visual delimiter, as below 123045000 I'd prefer to see more easier to read familiar format, as 12:30:45.000 I came up with this ugly echo '123045000'|awk '{print... (2 Replies)
Discussion started by: migurus
2 Replies

6. Shell Programming and Scripting

date(ddmmyyyy) sorting

input : 20110730 20110730 20110731 20110731 20110801 20110801 20110801 20110813 20110815 01062011 01062011 OUTPUT : i need to sort this input in such a way so that the latest date comes first. (11 Replies)
Discussion started by: urfrnddpk
11 Replies

7. Shell Programming and Scripting

changing month in Mmm format to mm FORMAT

i have an variable mydate=2008Nov07 i want o/p as in variable mymonth=11 (i.e nov comes on 11 number month) i want some command to do this for any month without using any loop. plz help me (1 Reply)
Discussion started by: RahulJoshi
1 Replies

8. Shell Programming and Scripting

Sort data by a DDMMYYYY field

I have a CSV file which I have to sort it by a field with DDMMYYYY format, since I'm not a unix specialist, how is the easiest way to do this? Sample data 30062008,432120,A,5001,A,201,Z ,2,MXN 31092008,432121,B,4001,B,101,Z ,2,MXN 05112008,432122,C,2001,C,51,Z ,2,MXN... (2 Replies)
Discussion started by: martinezjorge
2 Replies

9. Shell Programming and Scripting

How to convert DDMMYYYY to DD MONTH YYYY in Unix

Hi I am having date as a string in DDMMYYYY format(07082008) in a variable say cdate. I want to Convert it into DD Month YYYY format(7 August 2008). Could someone help. Thanks in Advance. (2 Replies)
Discussion started by: rspk_praveen
2 Replies

10. Shell Programming and Scripting

Convert filenames with DDMMYYYY to YYYYMMDD

Okay, I have posted on here one other time and received very fast help, so I figured I'd post again. Searched for awhile and couldn't find exactly what I'm looking for. I am attempting to write a script that will search through a given directory, or search through the current directory, and... (10 Replies)
Discussion started by: cbo0485
10 Replies
Login or Register to Ask a Question