SELECT ACOS(31.552278760192)
when executed in MSSQL Server it returns some value but when executed in MYSQL it returns null.
Any kind of help is appreciated.
-
1Why do not you check what ACOS(SIN(31.552278760192) * SIN(latitute) + COS(31.552278760192) * COS(latitute) * COS(longitute) - 74.338372290294) * 6371 is returning on mySQL? There might be some issue there.Kangkan– Kangkan2011-11-04 05:25:03 +00:00Commented Nov 4, 2011 at 5:25
-
Agreed - you need to break down each selection.SliverNinja– SliverNinja2011-11-04 05:27:03 +00:00Commented Nov 4, 2011 at 5:27
-
@Kangkan, I am not so lazy. I have checked it. It is returning something which is not null.Shahid Karimi– Shahid Karimi2011-11-04 05:27:29 +00:00Commented Nov 4, 2011 at 5:27
-
@Kangkan, I have edited the original post kindly read it again.Shahid Karimi– Shahid Karimi2011-11-04 05:36:22 +00:00Commented Nov 4, 2011 at 5:36
Add a comment
|
1 Answer
From the fine manual:
ACOS(X)
Returns the arc cosine of X, that is, the value whose cosine is X. Returns NULL if X is not in the range -1 to 1.
So 31.552278760192 is out of range for MySQL's ACOS. In fact, the arccosine function doesn't produce a real number as a result outside of [-1,1] and acos(31.552278760192) is ~4i.
1 Comment
Kangkan
Great grand reply. Such a deep insight. Where is the +10 up vote button?