handling date field

mgirinath · #1 (**permalink**) 04-03-2007

Hi,

Is there any way we could change the date format listed below...

date I get is 03302007 (MMDDYYYY)
I need to change it to 20070330 (YYYYMMDD)

Thanks.

vgersh99 · #2 (**permalink**) 04-03-2007

Code:

echo '03302007' | sed 's#\(..\)\(..\)\(....\)#\3\1\2#'

tumblez · #3 (**permalink**) 04-03-2007

If you are wanting the current system date in that format...

date +"%Y%M%d"

will produce...

20070903

cfajohnson · #4 (**permalink**) 04-03-2007

Quote:

Originally Posted by mgirinath

Is there any way we could change the date format listed below...

date I get is 03302007 (MMDDYYYY)
I need to change it to 20070330 (YYYYMMDD)

Separate the components, then put them back together in the order you want:

Code:
date=03302007
temp=${date#??}
month=${date%"$temp"}
day=${temp%????}
year=${temp#??}
newdate=$year$month$day

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to sort a field in a file having date values	risshanth	Shell Programming and Scripting	4	06-04-2008 06:03 AM
Compare dates in a field and print the latest date row	cvkishore	Shell Programming and Scripting	1	08-04-2007 08:58 AM
Moving Part of a field to another field using AWK	rjsha1	Shell Programming and Scripting	5	08-04-2006 06:39 AM
Arrange date in a field	sabercats	Shell Programming and Scripting	6	02-28-2006 04:56 PM
Date Handling	AkumaTay	UNIX for Dummies Questions & Answers	1	08-16-2001 03:53 AM

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:


	Powered by