sql convert 24 hour time to 12 hour code example
Example: CONVERT time string into 12 hours in sql
declare @t time
set @t = '14:40'
select CONVERT(varchar(15),@t,100)
declare @t time
set @t = '14:40'
select CONVERT(varchar(15),@t,100)