Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does the Scheduler have support for daylight saving time?

April 26, 2017daylight Saving scheduler support time

0

10 Posted

Does the Scheduler have support for daylight saving time?

1 Answer

0

10 Posted

Yes. You must set the DEFAULT_TIMEZONE scheduler attribute if you want your job or window to follow daylight savings adjustments. For instance, if your database resides in Paris, you would set this to ‘Europe/Warsaw’. Daylight saving adjustments will not be followed if you specify an absolute offset, for instance ‘-8:00’ would only be correct for half of the year in San Francisco. If no value is specified for this attribute, the scheduler uses the time zone of systimestamp when the job or window is enabled. This is always an absolute offset and will not follow daylight savings adjustments.