HOUR()

Scalar. Returns an integer representing the hour of the day (0 to 23) as extracted from a timestamp value

Syntax

HOUR( timestamp [, timezone ] )

Parameters
timestamp	An expression that evaluates to a timestamp value.
timezone	A string representing the time zone. If omitted, Sybase CEP Engine assumes the local time zone. See "Sybase CEP Time Zone Database" in the Sybase CEP Integration Guide for more information about valid time zone strings.

Data Types
Return	timestamp	timezone
Integer	Timestamp	String

If either parameter is NULL, the function returns NULL.

INSERT INTO OutStream
SELECT HOUR(InStream.OrderTime)
FROM InStream;