How to change it to the date format

preethgideon · #1 (**permalink**) 11-01-2006

Hi,
I want to know how to change this string to date format

20061102122042 to 02-11-2006 12:20:42
or 02-Nov-2006 12:20:42

Please let me know at the earliest.Thanks in advance.

Regards,
Preetham R.

anbu23 · #2 (**permalink**) 11-01-2006

Code:

echo 20061102122042 | sed "s/\(.\{4\}\)\(..\)\(..\)\(..\)\(..\)\(..\)/\3-\2-\1 \4:\5:\6/"

preethgideon · #3 (**permalink**) 11-02-2006

Hey thanks for the command but the string would be in the file say as the seventh field.

napolayan · #4 (**permalink**) 11-02-2006

Quote:

Originally Posted by preethgideon

Hey thanks for the command but the string would be in the file say as the seventh field.

then simply add this to anbu's code
cat filename|while read line
do
echo $line|awk '{print $7}'|sed "s/$.\{4\}$$..$$..$$..$$..$$..$/\3-\2-\1 \4:\5:\6/">>filename2
done

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Change of date format	svenkatareddy	Shell Programming and Scripting	2	05-23-2008 03:58 AM
How Can we change the Date format from Variable	laknar	Shell Programming and Scripting	1	05-02-2008 03:47 AM
Change date format	ust	UNIX for Advanced & Expert Users	4	12-19-2007 05:17 PM
convert mmddyy date format to ccyyddd format??	Bhups	Shell Programming and Scripting	2	09-28-2006 12:30 AM
change the empty function from the old format to the new format	powah	Shell Programming and Scripting	0	06-23-2005 01:17 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:


	Powered by