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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

MINUTE function [Date and time] Next Page

MINUTES function [Date and time]

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

Syntax 1: integer

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

Syntax 2: timestamp

MINUTES( datetime-expression, integer-expression )


datetime-expression    A date and time.

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


Since this function returns an integer, overflow can occur when syntax 1 is used with timestamps greater than or equal to 4083-03-23 02:08:00.

See also
Standards and compatibility

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

SELECT MINUTES( '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 1051040527.

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

The following statements return the timestamp 1999-05-12 21:10:07.000. It is recommended that you use the second example (DATEADD).

SELECT MINUTES( CAST( '1999-05-12 21:05:07'

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