15.00 - DEGREESRADIANS - Teradata Database

DEGREES
RADIANS

Purpose  

DEGREES takes a value specified in radians and converts it to degrees.

RADIANS takes a value specified in degrees and converts it to radians.

Syntax  

where:

Syntax element …	Specifies …
arg	a numeric expression. If the function is DEGREES, the arg is interpreted as an angle in radians. If the function is RADIANS, the arg is interpreted as an angel in degrees.

ANSI Compliance

This is a Teradata extension to the ANSI SQL:2011 standard.

Result Title

The following table lists the default titles for DEGREES(arg) and RADIANS(arg).

Function	Title
DEGREES(arg)	(5.72957795130823E001*arg)
RADIANS(arg)	(1.74532925199433E-002*arg)

Result Type and Format

Here are the result type and format of DEGREES and RADIANS.

If the operand is numeric, the format is the default format for the resulting data type.

If the operand is character, the format is the default format for FLOAT

If the operand is a UDT, the format is the default format for the predefined type to which the UDT is implicitly cast

Note: The NULL keyword has a data type of INTEGER.

For information on data type formats, see SQL Data Types and Literals.

Argument Types and Rules

If the argument is not numeric, it is converted to a numeric value, based on implicit type conversion rules. If the argument cannot be converted, an error is reported. For more information on implicit type conversion, see “Implicit Type Conversions” on page 583.

If arg is a character string, it is converted to a numeric value of the FLOAT data type.

If arg is a UDT, the following rules apply:

The UDT must have an implicit cast to any of the following predefined types:

Numeric

Character

DateTime

Interval

To define an implicit cast for a UDT, use the CREATE CAST statement and specify the AS ASSIGNMENT clause. For more information on CREATE CAST, see SQL Data Definition Language.

Implicit type conversion of UDTs for system operators and functions, including DEGREES and RADIANS, is a Teradata extension to the ANSI SQL standard. To disable this extension, set the DisableUDTImplCastForSysFuncOp field of the DBS Control Record to TRUE. For details, see Utilities: Volume 1 (A-K).

Neither DEGREES nor RADIANS can be applied to the following types of arguments:

BYTE or VARBYTE

BLOB or CLOB

CHARACTER or VARCHAR if the server character set is GRAPHIC

Usage Notes  

DEGREES and RADIANS are useful when working with trigonometric functions such as SIN and COS, which expect arguments to be specified in radians, and inverse trigonometric functions such as ASIN and ACOS, which return values specified in radians.

 

 

 

 

Examples  

Representative DEGREES and RADIANS function expressions and the results are as follows.

Expression	Result
SIN(RADIANS(60.0))	8.66025403784439E-001
DEGREES(1.0)	5.72957795130823E 001