SQL Date Format in HH:MM AM/PM

Soumalya Das

10y1.3kCode

This query is used for getting time in SQL Server in HH:MM AM/PM format.

For HH:MM am/pm:

SELECT
LTRIM(Right(REPLACE(CONVERT(nvarchar(MAX),
CAST(GetDate() as smalldatetime), 109),':00:000', ' '), 8))
as[current_time]

For HH:MM:SS am/pm:

select CONVERT(VARCHAR(8), getdate(), 108)
+ ' ' + RIGHT(CONVERT(VARCHAR(30), getdate(), 9), 2)