Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

HOUR function [Date and time] Next Page

HOURS function [Date and time]

A function that evaluates hours. For specific details, see this function's usage.

Syntax 1: integer

HOURS ( [ datetime-expression, ] datetime-expression )

Syntax 2: timestamp

HOURS ( datetime-expression, integer-expression )


datetime-expression    A date and time.

integer-expression    The number of hours to be added to the datetime-expression. If integer-expression is negative, the appropriate number of hours is subtracted from the datetime. If you supply an integer expression, the datetime-expression must be explicitly cast as a DATETIME data type.

For information about casting data types, see CAST function [Data type conversion].


The behavior of this function can vary depending on what you supply:

See also
Standards and compatibility

The following statements return the value 4, signifying that the second timestamp is four hours after the first. It is recommended that you use the second example (DATEDIFF).

SELECT HOURS( '1999-07-13 06:07:12',
   '1999-07-13 10:07:12' );

   '1999-07-13 06:07:12',
   '1999-07-13 10:07:12' );

The following statement returns the value 17517342.

SELECT HOURS( '1998-07-13 06:07:12' );

The following statements return the datetime 1999-05-13 02:05:07.000. It is recommended that you use the second example (DATEADD).

   CAST( '1999-05-12 21:05:07' AS DATETIME ), 5 );

SELECT DATEADD( hour, 5, '1999-05-12 21:05:07' );