Alphabetical list of functions
330
The statement
SELECT DATETIME( ’1998-09-09 12:12:12.000’ )
returns a timestamp with value 1998-09-09 12:12:12.000.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
DAY function [Date and time]
Returns an integer from 1 to 31 corresponding to the day of the month of a
date.
DAY (
date-expression
)
date-expression The date.
The following statement returns the value 12.
SELECT DAY( ’2001-09-12’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
DAYNAME function [Date and time]
Returns the name of the day of the week from the a date.
DAYNAME(
date-expression
)
date-expression The date.
The following statement returns the value Saturday.
SELECT DAYNAME ( ’1987/05/02’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
DAYS function [Date and time]
Returns the number of days from an arbitrary date to a specified date,
between two specified times or adds the specified integer-expression days to
a time.
Examples
Standards and
compatibility
Function
Syntax
Parameters
Examples
Standards and
compatibility
Function
Syntax
Parameters
Example
Standards and
compatibility
Function
To Next Page
Loading...