i want to convert time given in am/pm to 24 hr representation and vice versa
like 19:00 should be parsed in to 7:00 PM
similarly 08:00 PM should be displayed as 20:00 .
how can i do this?

from db i get it in datetime format using mysql ie ; 2006-05-18 18:30:22

-------------------
suresh