0 Replies Latest reply on Oct 28, 2012 10:56 PM by JohnMMathews

    JCR/SQL2 Trig Functions?

    JohnMMathews Level 1

      Am I missing something or are there no trig functions like cos() and sin() supported through any JCR queries?  I am trying to find nodes within X distance by using lat/lng.  I know this syntax isn't formed correctly, but this is basically what I am trying to achieve:

       

      SELECT * FROM Places WHERE

          acos(sin(1.3963) * sin(NODE_LAT) + cos(1.3963) * cos(NODE_LAT) * cos(NODE_LNG - (-0.6981))) <= 0.1570;

       

      Thanks,
      John