JDBC Driver for Freshdesk

Build 22.0.8462


Query from BusinessHours table

Table Specific Information

Note: Only users with admin privileges can access the following Table.


Following is an example to select all entries from BusinessHours table:

SELECT * FROM BusinessHours

You can also select a specific entry from BusinessHours table:

SELECT * FROM BusinessHours WHERE Id = 100


Name Type ReadOnly Description
Id [KEY] Bigint False

Business hour ID.

Description String True

Description of the business hour.

Name String True

Name of the business hour.

IsDefault Boolean True

True if this is the default business hour.

TimeZone String True

Denotes the time zone of the business hour.

business_hours String True

Collection of start time and end time of days of a week.

CreatedAt Datetime True

Business hour creation timestamp.

UpdatedAt Datetime True

Business hour updated timestamp.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462