Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Changing column with GMT time to EST accounting for daylight time savings

Question

Views

Comments

3601907 Rank 5 - Community Champion

Nov 13, 2018 7:10PM edited Aug 13, 2024 7:12PM in Oracle Analytics Cloud and Server

I have a column that stores last runtime of an OBIEE agent in GMT. I am in EST (New York time). I would like to change the times stored in the last runtime column to EST taking into account daylight savings time. I used this formula to change the time from GMT to EST

TIMESTAMPADD(SQL_TSI_HOUR, -5, "Jobs"."Last Runtime Ts")

I need help with the daylight time savings piece if anyone has come across such a challenge.

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Changing column with GMT time to EST accounting for daylight time savings