Details

      Description

      All Math functions listed as below:

      POWER(numeric1, numeric2) 
      ABS(numeric) 
      MOD(numeric, numeric) 
      SQRT(numeric) 	
      LN(numeric) 	
      LOG10(numeric) 
      EXP(numeric) 	
      CEIL(numeric) 
      FLOOR(numeric) 	
      RAND([seed]) 	
      RAND_INTEGER([seed, ] numeric) 	
      ACOS(numeric)
      ASIN(numeric) 	
      ATAN(numeric) 	
      ATAN2(numeric, numeric) 	
      COS(numeric) 	
      COT(numeric) 	
      DEGREES(numeric) 	
      PI() 	
      RADIANS(numeric) 	
      ROUND(numeric1, numeric2) 	
      SIGN(numeric) 	
      SIN(numeric) 	
      TAN(numeric) 	
      TRUNCATE(numeric1, numeric2) 	
      

      See https://calcite.apache.org/docs/reference.html#arithmetic-operators-and-functions for more details.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                app-tarush Tarush Grover
                Reporter:
                mingmxu Xu Mingmin
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: