How to convert 12hours time format to 24 hours format in TIBCO BW

[TADISETTI -]

I am getting start time in input data like below

input data: 1:30:00 PM

Expected output data: 13:30:00 PM

How we can acheive, above output.

[angel torralba 2]

This is a tough one,

I haven't found information as well... I have found how to convert from 24 hours to 12 hour format.

I just need to find the appropiate 12 hour format for tibco, but I haven't had luck so far.

 

Gonna keep on watch this thread

[Shruti Jaiswal]

Hi,Try using below function to change the format, this parse the date to 24hr formatif(contains(<<date_parameter>>, 'AM') or contains(<<date_parameter>>, 'PM'))

thentib:trim(tib:parse-dateTime('MM/dd/yyyy hh:mm:ss a',  <<date_parameter>>))

else

tib:parse-dateTime('MM/dd/yyyy HH:mm', <<date_parameter>>)