Sybase Adaptive Server Anywhere - Page 376

Alphabetical list of functions
358
PROPERTY_NAME function [System]
Returns the name of the property with the supplied property-number.
PROPERTY_NAME ( property-id )
property-id The property number of the database property.
The following statement returns the property associated with property
number 126. The actual property to which this refers changes from release to
release.
SELECT PROPERTY_NAME( 126 )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"Database properties" on page 1090
PROPERTY_NUMBER function [System]
Returns the property number of the property with the supplied property-
name.
PROPERTY_NUMBER ( property-name )
property-name A property name.
The following statement returns an integer value. The actual value changes
from release to release.
SELECT PROPERTY_NUMBER( ’PAGESIZE’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"Database properties" on page 1090
QUARTER function [Date and time]
Returns a number indicating the quarter of the year from the supplied date
expression.
QUARTER( date-expression )
date- expression The date.
The following statement returns the value 2.
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples