Chapter 8 SQL Functions
333
♦
Sybase Not supported by Adaptive Server Enterprise.
"DB_ID function" on page 331
"DB_NAME function " on page 332
"Database-level properties" on page 1101
DEGREES function [Numeric]
Converts a number from radians to degrees.
DEGREES (
numeric-expression
)
numeric-expression An angle in radians.
The following statement returns the value 29.793805.
SELECT DEGREES( 0.52 )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
DIFFERENCE function [String]
Returns the difference in the SOUNDEX values between the two string
expressions.
DIFFERENCE (
string-expression-1
,
string-expression-2
)
string-expression-1 The first SOUNDEX argument.
string-expression-2 The second SOUNDEX argument.
The following statement returns the value 3.
SELECT DIFFERENCE( ’test’, ’chest’ )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"SOUNDEX function" on page 366
DOW function [Date and time]
Returns a number from 1 to 7 representing the day of the week of a date,
with Sunday=1, Monday=2, and so on.
DOW (
date-expression
)
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
To Next Page
Loading...