Prev: translate string to binary / binary to string
Next: Select column with highest value
From: Dan on 24 May 2010 10:28

"Erland Sommarskog" <esquel(a)sommarskog.se> wrote in message
news:Xns9D82A5906C4AEYazorman(a)127.0.0.1...
> Roy Goldhammer (royg(a)yahoo.com) writes:
>> I ran this:
>>
>> declare @f float
>>
>> set @f = 30
>>
>> select sin(@f)
>>
>> and got -0.988031624092862
>>
>> What is this?
>
> The sinus value of 30 radians. If you intended 30 degrees try:
>
> select sin(radians(30E0))
>
> (Using only "30" does not work, as the return type of radians() is the
> same as the input type - quite silly if you ask me.)
>
> At least you are not alone. The topic for SIN in Books Online says:
>
> Returns the trigonometric sine of the specified angle, in radians
>
> So far, so good, but then there is the example:
>
> DECLARE @angle float
> SET @angle = 45.175643
> SELECT 'The SIN of the angle is: ' + CONVERT(varchar,SIN(@angle))
> GO

But the example is technically correct, it's 45.175643 radians, and nothing
in the results mentions degress ;)

--
Dan

First  |  Prev  | 
Pages: 1 2
Prev: translate string to binary / binary to string
Next: Select column with highest value