Converting UTC to EST time zone in Logical SQL
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
Tagged:
0