DECLARE @CurrentDate DATETIME = '2012/09/23 10:23PM';
SELECT FORMAT(@CurrentDate, 'tt', 'en-US');
what is the output of above statement?

The 'tt' custom date and time format specifier represents the entire AM/PM designator. If only a single 't' is specified, this represents the first character of the AM/PM designator.