Alphabetical list of functions
350
♦
SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise. The % operator
is used as a modulo operator in Adaptive Server Enterprise.
"REMAINDER function" on page 360
MONTH function [Date and time]
Returns a number from 1 to 12 corresponding to the month of the given date.
MONTH (
date-expression
)
date-expression A datetime value.
The following statement returns the value 7.
SELECT MONTH( ’1998-07-13’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
MONTHNAME function [Date and time]
Returns the name of the month from a date.
MONTHNAME (
date-expression
)
date-expression The datetime value.
The following statement returns the value September.
SELECT MONTHNAME( ’1998-09-05’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
MONTHS function [Date and time]
Returns the number of months since an arbitrary date and time, between two
specified times, or adds the specified integer-expression amount of months to
a datetime.
MONTHS (
datetime-expression
|
datetime-expression, datetime-expression
|
datetime-expression, integer-expression
)
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
Function
Syntax
Parameters
Examples
Standards and
compatibility
Function
Syntax
To Next Page
Loading...