Sybase Adaptive Server Anywhere - Page 341

Chapter 8 SQL Functions
323
The following statements illustrate the use of format styles:
SELECT CONVERT( CHAR( 20 ), order_date, 104 )
FROM sales_order
order_date
16.03.1993
20.03.1993
23.03.1993
25.03.1993
...
SELECT CONVERT( CHAR( 20 ), order_date, 7 )
FROM sales_order
order_date
mar 16, 93
mar 20, 93
mar 23, 93
mar 25, 93
...
The following statement illustrates conversion to an integer, and returns the
value 5:
SELECT CONVERT( integer, 5.2 )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"CAST function" on page 318
COS function [Numeric]
Returns the cosine of a number.
COS ( numeric-expression )
numeric expression The angle, in radians.
The statement
SELECT COS( 0.52 )
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples