Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Converting UTC to EST time zone in Logical SQL — Cloud Customer Connect
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

Converting UTC to EST time zone in Logical SQL

Received Response
202
Views
7
Comments

Summary:

Our report is built with logical sql, the approval dates are displaying in UTC time zone and we need these to reflect EST time zone. Need help with syntax.

Content (required):

Our report is built with logical sql, the approval dates are displaying in UTC time zone and we need these to reflect EST time zone. Trying to convert the time using a case statement, cast statement in the select of the logical sql. here is the statement we are using

  CASE WHEN "Transaction Details"."Change Effective Date" IS NOT NULL THEN TO_CHAR(CAST(FROM_TZ(CAST("Transaction Details"."Change Effective Date" AS TIMESTAMP), 'UTC') AT TIME ZONE 'America/New_York' AS Date),'MM/DD/YYYY HH24:MI:SS') END s_14

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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