You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Global Function for Get today's date in custom time zone returning yesterday

Accepted answer
42
Views
5
Comments

Summary:

Since the function for "Today's date()" returns value in UTC, I am exploring the "Get today's date in custom time zone". However, while testing this function I observed the value returned was yesterday when using "America/New_York," or "EST". The below screenshots were captured at approximately 12 pm ET with the expectation that both functions would return the same date (16-May-2024) but one with Timestamp in EST (16-May-2024 12:00 PM). What should user expect to see when defaulting a date/timestamp using "Get today's date in custom time zone"?

JPMC Use Case #1063

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!