Getting local timezone information in Mapper
SummaryNeed local timezone information in Mapper
I am building a scheduled integration to move data from one application to another. The integration needs to run twice a day - 6 AM and 6 PM, local time of the plant, which is based in Indiana.
Since they observe daylight savings time, 6 AM and 6 PM aren't always the same values relative to UTC. I've changed the time zone of the integration (based on this post https://blogs.oracle.com/integration/timezone-functionality-in-oic-schedules), but the XSL dateTime functions in the mapper still return all dates in UTC time.
Is it possible to change the value returned by the implicit-timezone function to return the proper offset: -5 for Standard Time and -4 for Daylight Savings Time? I need to know during the integration execution what the local time is, and what the current offset is.