MySQL Forums
Forum List  »  Microsoft SQL Server

Advanced Search
New Topic

Nested mathematical functions not supported?
Posted by: danielbrown1
Date: January 07, 2006 10:32PM

I am currently migrating from MSSQL to MySQL 5.

I have a query which runs fine on MSSQL but on MYSQL it returns "function sin does not exist"

Here's the query:

SELECT *, ( ( 60*1.1515 ) * ( 180 / 3.14159265359 ) * ( ACOS ( ( SIN ( u.zipLatitudeRadians ) * SIN ( 0.711204216895 ) ) + ( COS ( u.zipLatitudeRadians ) * COS ( 0.711204216895 ) * COS ( ( 3.14159265359 * (u.zipLongitudeDegrees - -74.051) ) /180 ) ) ) ) ) AS distance FROM user u

All I can think of is nested mathematical functions are not supported in MySQL. Is this the case?



Edited 1 time(s). Last edit at 01/07/2006 10:33PM by danielbrown1.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Nested mathematical functions not supported?
danielbrown1
January 07, 2006 10:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.