nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
Oracle Analytics Forums
Oracle Analytics Forum

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

3601907

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.

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet