Need to convert 24 hr time format to 12 hr time format

Summary:

Need to convert 24 hr time format to 12 hr time format

Content (required):

Hi

I trying to fetch a column from Assignment page where in the UI it shows 12 hr format but when i fetch using the bip report, it fetches in 24 hr format.

My query is

select PAAM.TIME_NORMAL_START, 

paam.TIME_NORMAL_FINISH

--papf.person_number 

from per_all_assignments_m paam,

per_all_people_f papf

 

WHERE

paam.person_id = papf.person_id 

I need in 12 hr format in BIP . Any solution?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):