Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

DEGREES (SQL Server Compact Edition)

Given an angle in radians, returns the corresponding angle in degrees.


DEGREES ( numeric_expression ) 
numeric_expression

An expression of the exact numeric or approximate numeric data type categories, or of types that are implicitly convertible to float.

Returns the same type as numeric_expression, except for the following expressions.

Specified expression Return type

tinyint, smallint

int

real/float

float

Nonnumeric types that can be implicitly converted to float

float

The following example returns the degree value of various angles expressed in radians.

CREATE TABLE "Degrees" ("PI()/2" float, "PI()/3" float, "PI()/4" float)
INSERT INTO "Degrees" VALUES (DEGREES(PI()/2), DEGREES(PI()/3), DEGREES(PI()/4))
SELECT * FROM "Degrees"
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.