time formate conversion to am pam

Question

Hello can any one help me to retrieve value from database saved in datetime format to HTML5 input type time control.

I tried to use

select REPLACE(REPLACE(CONVERT(varchar, CAST('1900-01-01 23:28:00' AS time) ,100),'AM',' AM'),'PM',' PM')

but it gives error

Type time is not a defined system type.

I want output as

11:28:00 PM

Sunny Sharma · Answer

Hi Piyusha try this: SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20)CAST('1900-01-01 23:28:00' as DATETIME)) 7)) Hope it helps :)

Sunny Sharma · Answer

I'm glad I could help. Happy Coding :) Cheers!!

piyusha patravali · Answer

Thank you Sunny it worked.......thanks a lot