This article describes a mechanism to format time in BI
Publisher.
Let me explain with an example
I have a XML file with the following tag in it.
<SsStartTime>18:00:00</SsStartTime>
The
requirement is to display this time as 6:00PM