How to get time in AM PM format in SQL Server
How to get time in 12 hour format in SQL Server
SELECT CONVERT(VARCHAR,GETDATE(),100) as ‘Default Date format’
SELECT RIGHT(‘0’+LTRIM(RIGHT(CONVERT(varchar,getDate(),100),8)),7) as ’12 Hour Time in AMPM’
SELECT REPLACE(REPLACE(RIGHT(‘0’+LTRIM(RIGHT(CONVERT(varchar,getdate(),100),7)),7),’AM’,’ AM’),’PM’,’ PM’)
as ’12 Hour Time in AM PM’
Instead of Replace we can use STUFF()
Try this
SELECT STUFF(RIGHT(‘0’+LTRIM(RIGHT(CONVERT(varchar,getdate(),100),7)),7),6,0,’ ‘)