HOUR - Returning the Hour of a Time Value- FineDataLink Help Document

Last update: May 21, 2025

Overview

Syntax	HOUR(text/date,format)	Returns the hour of a specified time value.The function specifies the returned value as an integer from 0 (0:00) to 23 (23:00).
Parameter 1	text/date	Represents the time from which the hour is to be extracted.
Parameter 2	Format
Type of the Returned Value	Value

Notes

The function allows the parameters to be empty. That is to say, you can simply use HOUR(). When the parameters are empty, the function returns the hour of the current system server time.

If any parameter is NULL, the result is NULL.

Example

Formula	Result
HOUR()	15, corresponding to the system server time at 2020-10-23 15:36:02.
HOUR("11:32:40")	11
HOUR("11:32:40","HH:mm:ss")	11

Previous：DAY - Returning the Day of a Date

Next：MINUTE - Returning the Minute of a Specified Time

Helpful
Not helpful
Only read

中文（简体）

English

HOUR - Returning the Hour of a Time Value

Overview

Notes

Example

附件列表