conversion of different timestamp to standard timestamp

Shell Programming and Scripting
1

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

2

will this work??

awk '{split($1,A,"/");split($2,B,":");split($6,C,"/");split($7,D,":");split($8,E,"/")}
{printf "%04s-%02s-%02s %02s:%02s:%02s %04s-%02s-%02s %02s:%02s:%02s %04s-%02s-%02s 00:00:00",A[3],A[2],A[1],B[1],B[2],B[3],C[3],C[2],C[1],D[1],D[2],D[3],E[3],E[2],E[1]}' filename
3

a slightly more legible version:

cat << EOF |
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
EOF
sed -e 's/[\/:]/ /g' |
nawk '{
  printf( "%04d-%02d-%02d %02d:%02d ", $3, $1, $2, $4, $5 );
  printf( "%s: %s ", $7, $8 );
  printf( "%04d-%02d-%02d %02d:%02d ", $11, $9, $10, $12, $13 );
  printf( "%04d-%02d-%02d 00:00:00", $16, $14, $15 );
  printf( "\n" );
  }'

output:

2009-02-28 08:03 Mchenry: Shawna 2009-02-28 08:03 2009-02-28 00:00:00
2009-03-28 06:03 phanj: ray 2009-03-28 08:03 2009-03-28 00:00:00
2009-04-08 04:03 hcary: jun 2009-04-08 08:03 2009-04-08 00:00:00
2009-02-09 08:03 ghtar: jan 2009-02-09 08:03 2009-02-09 00:00:00