Please send to query only hour selected AM/PM

Question

Please send to query only hour selected AM/PM

Answer 1

Hello 

 

You can use as Follow : 

select convert(varchar(15),CAST('20:20:00.0000000' AS TIME),100) as TimeFormat

Output will be :

8:20PM

Thanks

Answer 2

select RIGHT(CONVERT(VARCHAR(30), getdate(), 9), 2)