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

DAYNAME function [Date and time] Next Page

DAYS function [Date and time]

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

Syntax 1: integer

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

Syntax 2: timestamp

DAYS( datetime-expression, integer-expression )


datetime-expression    A date and time.

integer-expression    The number of days to be added to the datetime-expression. If the integer-expression is negative, the appropriate number of days is subtracted from the timestamp. If you supply an integer expression, the datetime-expression must be explicitly cast as a date or timestamp.

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


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

This function ignores hours, minutes, and seconds.

See also
Standards and compatibility

The following statement returns the integer 729889.

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

The following statements return the integer value -366, indicating that the second date is 366 days prior to the first. It is recommended that you use the second example (DATEDIFF).

SELECT DAYS( '1998-07-13 06:07:12',
             '1997-07-12 10:07:12' );
   '1998-07-13 06:07:12',
   '1997-07-12 10:07:12' );

The following statements return the timestamp 1999-07-14 00:00:00.000. It is recommended that you use the second example (DATEADD).

SELECT DAYS( CAST('1998-07-13' AS DATE ), 366 );
SELECT DATEADD( day, 366, '1998-07-13' );