Datetime Convert

Question

I am using the CONVERT function in TSQL to get a date, time and AMPM as follows

CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22)

but it gives me 08/07/20 4:41:48 PM

Is there a setting that would give only 4:41 PM without the seconds?

Answer 1

If no such feature, then consider two alternatives:

-- Method 1  
  
declare @s as varchar(max)  
set @s = CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22)  
set @s = STUFF( @s, PATINDEX('%:[0-9][0-9] [AP]M', @s), 3, '')  
select @s  
  
-- Method 2  
  
select FORMAT( CURRENT_TIMESTAMP, 'dd''/''MM''/''yy h'':''mm tt')  

The date part can be removed if not needed.

Answer 2

Maybe this post can help you figure out:
https://robbamforth.wordpress.com/2010/06/11/sql-date-formats-getdate-examples/