`HOUR`
Data 360 Query Guide, mirrored from developer.salesforce.com: **Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API
markdownreferencev16QN8-2WAXguide: data-cloud-query-guidestage: referencetrust: officialsource: developer.salesforce.comservice: data360interface: sql`HOUR`Data 360Data CloudData 360 Query Guide
Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/hour.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.
HOUR
Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Returns the hour field from a timestamp or interval. This function is equivalent to EXTRACT(HOUR FROM ...).
<timestamp>: The timestamp to extract the hour from.<interval>: The interval to extract the hour from.
Returns the hour as an integer.
Get the hour of the day from a timestamp.
Returns 20.
Get the hour component from an interval.
Returns 2.
Cookie Consent Manager
Cookie Consent Manager
- ### General Information
- ### Required Cookies
- ### Functional Cookies
- ### Advertising Cookies
General Information
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings. Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Cookies Details
Functional Cookies
- [x] Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Cookies Details
Advertising Cookies
- [x] Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.
Cookies Details
Cookie List
Consent Leg.Interest
- [x] checkbox label label
- [x] checkbox label label
- [x] checkbox label label
Clear
- - [x] checkbox label label
Apply Cancel
Save Settings
Accept All Cookies
