How to change it to the date format - UNIX for Dummies Questions & Answers

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-01-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-22-2008 11:58 PM
How Can we change the Date format from Variable	laknar	Shell Programming and Scripting	1	05-01-2008 11:47 PM
Change date format	ust	UNIX for Advanced & Expert Users	4	12-19-2007 01:17 PM
convert mmddyy date format to ccyyddd format??	Bhups	Shell Programming and Scripting	2	09-27-2006 08:30 PM
change the empty function from the old format to the new format	powah	Shell Programming and Scripting	0	06-23-2005 09:17 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode