Integration Technologies - JDE1 (MOSC)

MOSC Banner

How to convert datetime from PST to ISO and Hawaii to ISO using OIC

I am getting the value for a date field from source file in the PST format or Hawaii format but i need to convert it to ISO format to map it to the filed that will be dumping into sql table. How can I achieve this?

Input from source file: 2/4/2025 7:58 (M/D/YYYY HH:MI)

Expected Conversion: 2025-02-04T07:58:00 (YYYY-MM-DDTHH:MI:SS)

Note: if YEAR or MONTH or DATE or HOUR or MINUTE or SCONDS values are coming in a single digit then it should be preceeded with 0(zero) ahead of the digit while converting. For example in above scenario Month,Day,Hour values are converted from 2,4,7 to 02,04,07.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center