Originally posted by: SystemAdmin

Hi,

i have mapping like this

=TODATETIME("20" + PCDATA Misc:In1,"CCYYMMDDHH24MMSS0-9")

where In1 is TIME_STAMP ..So the output looks like this

2008-07-02T01:40:15.364

Now i need the Output like this

2008-07-02T01:40:15+00:00

Can any one tell me what need to be done in this case.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: paul.brett

I think this should do the trick:

=FROMDATETIME(TODATETIME("20" + In1,"CCYYMMDDHH24MMSS0-9"),"{CCYY-MM-DD}T{HH24:MM:SS+/-ZZ:ZZ}")

...currently the timezone is not being displayed for me, but that may be because I am in GMT.

If the timezone is fixed for your runtime, then you could use:

=FROMDATETIME(TODATETIME("20" + In1,"CCYYMMDDHH24MMSS0-9"),"{CCYY-MM-DD}T{HH24:MM:SS}")+"+00:00"
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange