Query I am using =>
select CONVERT(varchar(15),CAST('08:00:00.0000000' AS TIME),100)
output I am getting => 8:00AM
but I want output => 08:00AM
( two digit hours )
So how can I get this output
>Solution :
Sql Server way of LPAD
select right('0'+ CONVERT(varchar(15),CAST('08:00:00.0000000' AS TIME),100), 7)