How to convert a datetime into short time format in SQL Server 2005?

Question

I want to display the time in hh:mm AM/PM format.

Example: 10:23 PM

How to display that?