HOUR Function

Returns the hour from a time or datetime value.

Category:	Date and Time
Returned data type:	TINYINT

Syntax

HOUR(time | datetime)

specifies any valid expression that represents a time value.

Data type	TIME
See	FedSQL Expressions

specifies any valid expression that represents a datetime value.

Data type	TIMESTAMP
See	FedSQL Expressions

Table: CUSTONLINE

The following statement illustrates the HOUR function:

Statements	Results
select hour(endtime) from custonline;	10 22 19 12 12 16 15 11 10 9
select hour(current_time);	14