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
11
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!