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

Jan 3 2009 12:07 AM

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

Example: 10:23 PM

How to display that?


Answers (4)