Oracle Get Working Hours

Inputs

Column Title	Column Title	Column Title
Host	String	Oracle host
Interface Name	String	Oracle interface name
Username	String	Oracle username
Password	SensitiveString	Oracle password

Outputs

Column Title	Column Title	Column Title
Success	Boolean	Whether successfully retrieved the operating hours
Intervals	Object	List of operating hour intervals for each day
In Operating Hours	Boolean	Whether current time is within operating hours
In Holiday	Boolean	Whether current time is during a holiday period

Intervals Object Structure

The intervals object contains days as keys with operating hours as values:

{
  "sunday": "00:00-02:59, 09:00-00:00",
  "monday": "00:00-02:59, 09:00-00:00",
  "tuesday": "00:00-02:59, 09:00-00:00",
  ...
}

Each day's value contains one or more time ranges in 24-hour format.

Note: All times are standardized to UTC offset based on the server timezone for January 1, 2000. This ensures consistent time handling regardless of daylight savings time variations across different regions.