How do I format transformed time in xslt

winkimjr2 · September 17th, 2014, 03:27 PM

I want to display my time in 24 hour format. My xml time is 1:10 PM but I want it to display as 13:10:00.
How do I change my xslt to display correct time format? My xslt code is not working.

It is displaying this:
<ext:ProtectionOrderServiceTime>NaN:NaN:NaN-NaN:00</ext:ProtectionOrderServiceTime>

But this is what I want:

<ext:ProtectionOrderServiceTime>13:10:00</ext:ProtectionOrderServiceTime>

Here is my xslt element code

Code:

<ext:ProtectionOrderServiceTime>
<xsl:value-of select="mscef:formatTime(string(@timeServed))"/>
</ext:ProtectionOrderServiceTime>

Here is the xml that is transformed

XML element code

Code:

<NotificationEvent notificationType="ProtectionOrderService" timeServed="1:10 PM"</NotificationEvent>

mhkay · September 17th, 2014, 04:06 PM

You are calling some library or external function mscef:formatTime. Clearly this function doesn't do what you want it to do. You haven't given us any clues where this function comes from or whether you can change it, so we can't really help very much. Also, you tell us that the input is 1.10PM, but we can't help you write code to convert this unless we know all the possible inputs, e.g. how are noon and midnight represented? (Remember that we're not all familiar with the 12 hour clock as used in your country...)

winkimjr2 · September 17th, 2014, 05:24 PM

Quote:

Originally Posted by mhkay

You are calling some library or external function mscef:formatTime. Clearly this function doesn't do what you want it to do. You haven't given us any clues where this function comes from or whether you can change it, so we can't really help very much. Also, you tell us that the input is 1.10PM, but we can't help you write code to convert this unless we know all the possible inputs, e.g. how are noon and midnight represented? (Remember that we're not all familiar with the 12 hour clock as used in your country...)

I live in the USA. The time is the system is entered as 12 hour clock. So noon will be 12:00PM. And Midnight will be 12:00AM. The mscef:formatTime is a local function to convert time but it is not working. So I was looking for a different way to take the time e.g 1:30PM and convert it to 13:30:00.
Does this help?

mhkay · September 17th, 2014, 05:43 PM

If you want help finding the bug in the existing function, then you're going to have to show us the code.

If you want to replace it with XSLT code then the way you write this will depend greatly on whether you are using XSLT 1.0 or 2.0. Either way, please don't ask us to write the code for you. If you are having trouble writing the code yourself, show us your best attempt and we will try to explain where you went wrong.

winkimjr2 · September 18th, 2014, 11:07 AM

Quote:

Originally Posted by mhkay

If you want help finding the bug in the existing function, then you're going to have to show us the code.

If you want to replace it with XSLT code then the way you write this will depend greatly on whether you are using XSLT 1.0 or 2.0. Either way, please don't ask us to write the code for you. If you are having trouble writing the code yourself, show us your best attempt and we will try to explain where you went wrong.

That is fair what you said. I am using XSLT 2.0. I have however asked locally and someone helped me with this issue. So it is now resolved. Again, thanks for your advice. I will follow it as I continue to learn and post questions here seeking help. I love this forum!