Need date in the format [mm dd yyyy hh AM/PM]

Shell Programming and Scripting
1

could you please help be on the below code ..

Requirement is when i pass the parameter(for below 2) i should get current time -2 hours in the [mm dd yyyy hh AM/PM] format :wall:..

cur_dt=`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID -P $PASSWD -h -C"select getdate()"  | sed '2d'`
pr_dt="`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID -P $PASSWD -h -C\"select dateadd(hh,-$1,getdate())\" | sed '2d'`"
echo "Time period: $pr_dt  - $cur_dt

getting the below output,

Time period: Oct 11 2011 8:30PM  - Oct 11 2011 10:30PM

Requirement is

Oct 11 2011 8 PM  - Oct 11 2011 10 PM

(need to exclude the mins)

2

Modify the last line alone..

$ echo "Oct 11 2011 8:30PM - Oct 11 2011 10:30PM" | sed 's,:.., ,g'
Oct 11 2011 8 PM - Oct 11 2011 10 PM
$
3

Thanks Jayan ..

below worked for me ..

sed -e "s/:[0-9]*//g"`