To select time format in hh:mm (AM/PM) format

Denny
Posted by Denny under Sql Server category on | Points: 40 | Views : 1228
SELECT REPLACE(REPLACE(RIGHT('0'+LTRIM(RIGHT(CONVERT(varchar,getdate(),100),8)),7),'PM',' PM'),'AM',' AM')

Comments or Responses

Login to post response