1. Using the Oracle Mapper with Oracle Integration Generation 2
  2. Troubleshoot the Mapper
  3. Transform an Incoming UTC Timestamp into a Standard Timestamp

Transform an Incoming UTC Timestamp into a Standard Timestamp

You can transform an incoming UTC timestamp into a standard timestamp in the mapper.

For example, the incoming data is in the following format:
2021-05-24T13:34:45.000000+00:00
and needs to transformed as follows: 
2021-05-24 13:34:45

The mapper shows a source element of tl_order_timestamp being mapped to a target element of Ora Oic Tl Order Timestamp. The Expression Builder is displayed at the bottom of the mapper.

Specify the following expression in the Expression Builder.

xp20:format-dateTime( string(fn:current-dateTime() ),"[Y0001]-[M01]-[D01] [H01]:[m01]:[s01]")