I am trying to format a dateTime to remove the milliseconds part and just have seconds (e.g. 2015-04-07T17:13:19Z)
The issue is that when i use the dateTime function in XSLT as xpath in the BW Designer i need to convert the output string back into a dateTime. BW does not support functions in the editor or EXSLT.
The xsl: element executionDateTime: current()/ns4:tradeHeader/ns4:partyTradeInformation[1]/ns4:executionDateTime
@executionDateTimeScheme element current()/ns4:tradeHeader/ns4:partyTradeInformation[1]/ns4:executionDateTime/@executionDateTimeScheme
Please help if you can
Thanks
try this:
input: string(2015-04-07T17:13:19Z)
output: dateTime