hi i need a scrit to convert one date format to another. for example i have three columns in a file which gets a different format, but lastly i want output with stadard timestamp as "yyyy-mm-dd hh:mm:ss" column1 column2 column3 2/28/2009 8:03 PM Mchenry: Shawna 2/28/2009 8:03 2/28/2009 3/28/2009 6:03 PM phanj: ray 3/28/2009 8:03 3/28/2009 4/8/2009 4:03 PM hcary: jun 4/8/2009 8:03 4/8/2009 2/9/2009 08:03 PM ghtar: jan 2/09/2009 8:03 2/09/2009 coloumn 1 contains a PM and name ...output should be as standard timestamp . coloumn 2 contains only time stamp ...output should be as standard timestamp . coloumn 3 contains only date ...output should be as standard timestamp . output file should contain format as below: column1 column2 column3 2009-02-28 08:03:00 2009-02-28 08:03:00 2009-02-28 00:00:00 2009-03-28 06:03:00 2009-03-28 08:03:00 2009-03-28 00:00:00 2009-04-08 04:03:00 2009-04-08 08:03:00 2009-04-08 00:00:00 2009-02-09 08:03:00 2009-02-09 08:03:00 2009-02-09 00:00:00 thanks PRakash

What shell are you using?

ksh we are using......... could u please share me the logic ...for this

I will do the first date-time string for you: #!/bin/ksh typeset -Z2 MONTH typeset -Z2 DAY typeset -Z5 HRMIN echo "2/28/2009 8:03 PM Mchenry: Shawna 2/28/2009 8:03 2/28/2009"|while read col1 col2 col3 therest do set -- $(IFS="/"; echo $col1) MONTH=$1 DAY=$2 YEAR=$3 HRMIN="$col2" printf "%s-%s-%s %s:00\n" "$YEAR" "$MONTH" "$DAY" "$HRMIN" done