topic Re: Date conversion in Operating System - HP-UX

Date conversion

Mike_Ca Li — Wed, 28 Jul 2004 16:46:12 GMT

HI :
I have eg:
01Jan04
24Jun04
how to convert to
01-Jan-04
24-Jun-04 ?
Thanks

Re: Date conversion

Michael Tully — Wed, 28 Jul 2004 16:51:10 GMT

Try this:

date %d%b%y

Re: Date conversion

Patrick Wallek — Wed, 28 Jul 2004 16:51:14 GMT

#!/usr/bin/sh
DATE=$1
DAY=$(echo ${DATE} | cut -c 1-2)
MONTH=$(echo ${DATE} | cut -c 3-5)
YEAR=$(echo ${DATE} | cut -c 6-7)

echo "${DAY}-${MONTH}-${YEAR}"

Invoke it as:

# conv_date 01Jan04
And the output should be:
01-Jan-04

Re: Date conversion

Michael Schulte zur Sur — Wed, 28 Jul 2004 16:51:29 GMT

Hi,

like
echo "01Jan04" | awk '{print substr($1,1,2)"-"substr($1,3,3)"-"substr($1,6,2)}'

hth,

Michael

Re: Date conversion

Michael Tully — Wed, 28 Jul 2004 16:55:40 GMT

obviously I didn't read the question correctly ... sorry

Re: Date conversion

Rodney Hills — Wed, 28 Jul 2004 16:56:55 GMT

How about this perl one liner-

perl -p -e 's/(..)(...)(..)/$1-$2-$3/' inpfile >outfile

HTH

-- Rod Hills

Re: Date conversion

Hein van den Heuvel — Wed, 28 Jul 2004 19:19:12 GMT

perl -pe 's/(\D+)/-$1-/' infile > outfile

Now this of course will only work with the very simple examples you show.

Just for grins,

Hein.

Re: Date conversion

H.Merijn Brand (procura — Thu, 29 Jul 2004 00:42:29 GMT

And for *all* other formats (including those of your example):

# perl -wMDate::Manip -e'$dt=UnixDate($string,"%d-%b-%Y");

Enjoy, Have FUN! H.Merijn

Re: Date conversion

H.Merijn Brand (procura — Thu, 29 Jul 2004 00:43:45 GMT

And for *all* other formats (including those of your example):

# perl -wMDate::Manip -e'$dt=UnixDate($string,"%d-%b-%Y")'

where $string is your date
if the dates are in a file

# perl -wMDate::Manip -pe'$_=UnixDate($_,"%d-%b-%Y")' file

Enjoy, Have FUN! H.Merijn

Re: Date conversion

Saravanan_11 — Thu, 29 Jul 2004 01:00:35 GMT

hai ,

Use in the following form date "+%d-%h-%y"

# date "+%d-%h-%y"
29-Jul-04
#

-Saravanan