Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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