My Oracle Support Banner

E-PC: ISOToDateTime PeopleCode Function is Not Converting DateTime String to Base Time Zone (Doc ID 2984412.1)

Last updated on NOVEMBER 01, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.


According to PeopleBooks, ISOToDateTime() function takes an ISO-8601-formatted string, YYYY-MM-DDThh:mm:ss[.S]TZD, and returns a string with an ISO-8601-formatted datetime in the base time zone configured in PSOPTIONS.

However, when testing the function, ISOToDateTime() simply removes the timezone indicator, and no conversion is performed.

For example: The string "2023-10-24T18:50:18.1234567Z" passed to the function, in which the time zone is PDT, returns a value of 2023-10-24T18:50:18.1234567.

Steps to replicate:

1. Log into Application Designer, open the PeopleCode editor, and pass a datetime string such as "2023-10-24T18:50:18.1234567Z" to ISOToDateTime.
2. Execute the PeopleCode (via an online page or Application Engine program), and observe that the returned string is incorrect. In PDT time zone the value returned is 2023-10-24T18:50:18.1234567 instead of 2023-10-24

Sample Environment:

PeopleTools 8.59.20


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.