Get Time In AM/PM Format In SQL Server 2008
This article explains how to get time in AM/PM Format.
Introduction
This article explains how to get time in AM/PM Format.
Sometimes you want to display AM/PM time format. There is no option in standard Convert format to return AM/PM format.
I tried with different way and come up with the simple solution. Write following query to return only the time portion of the current date/time in an AM/PM format.
Execute the code and you will get time in AM/PM format.
