convert date format YYYYMMDD to MM/DD/YYYY

nasirgondal · #1 (**permalink**) 06-07-2006

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.

tayyabq8 · #2 (**permalink**) 06-08-2006

Code:

echo "YYYYMMDD" | awk '
BEGIN {OFS="/"}
{print substr($1,5,2), substr($1,7,2), substr($1,1,4)}'

Regards,
Tayyab

vino · #3 (**permalink**) 06-08-2006

Quote:

Originally Posted by nasirgondal

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.

You have broken a rule by duplicating your thread. The other one is here - changing the format of date.

Using shell script.

Code:

#! /bin/ksh

format=YYYYMMDD

YEAR=${format%????}
DAY=${format#??????}
MON=${format#$YEAR}
MON=${MON%$DAY}
echo $MON/$DAY/$YEAR

Using sed.

Code:

echo "YYYYMMDD" | sed -n -e "s_\(....\)\(..\)\(..\)_\2/\3/\1_p"

nasirgondal · #4 (**permalink**) 06-08-2006

Thank you.

arunkumar_mca · #5 (**permalink**) 06-13-2006

hi all....

Want some clarification ..

In the below scripts ...

echo "YYYYMMDD" | awk 'BEGIN {OFS="/"}{print substr($1,5,2), substr($1,7,2), substr($1,1,4)}'

What is OFS..Also how does the '/' is placed inbetween..

Thanks in advance,
Arun....

tayyabq8 · #6 (**permalink**) 06-13-2006

OFS is Output Field Separator, I don't know the internal technicle details of awk though I can imagine that awk puts each print command in a stack like

Code:

print substr($1,5,2)
print substr($1,7,2)
print substr($1,1,4)

and then separates each output of print with an OFS if defined, default OFS is " " a whitespace. Hope it helps.

Regards,
Tayyab

rspk_praveen · #7 (**permalink**) 08-07-2008

hi nasirgondal,

I also wanted such a script. It works fine but if the date is not exactly in YYYYMMDD format, lets say YYYYMDD or YYYYMMD format its not working. Is there any solution even for this. Appreciate your help

#! /bin/ksh

format=YYYYMMDD

YEAR=${format%????}
DAY=${format#??????}
MON=${format#$YEAR}
MON=${MON%$DAY}
echo $MON/$DAY/$YEAR

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
create filename with 'DD/MM/YYYY' date format	royalibrahim	Shell Programming and Scripting	4	04-12-2008 08:24 AM
sed to display date in dd/mm/yyyy format	sars	Shell Programming and Scripting	2	02-15-2007 03:32 AM
How can i get the yesterday's date in YYYYMMDD format	prasadsr	HP-UX	4	01-19-2007 09:52 AM
convert mmddyy date format to ccyyddd format??	Bhups	Shell Programming and Scripting	2	09-27-2006 11:30 PM
get yesterday date in yyyymmdd format	hk_newbie	UNIX for Dummies Questions & Answers	2	12-14-2001 03:32 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: