SnowConvert - Translation Spec
search
⌘Ctrlk
SnowConvert - Translation Spec
  • For Teradata
  • Translation Reference
    • Teradata
    • Oracle
    • SQLServer
      • General Language Elements
      • DDLs
      • DMLs
      • Data Types
      • Statements
      • Built-in functions
        • SnowConvert custom UDFs
        • Aggregate functions
        • Analytic Functions
        • Conversion functions
        • Data Type functions
        • Date & Time functions
        • Logical functions
        • Mathematical functions
          • ABS
          • ACOS
          • ASIN
          • ATAN
          • ATN2
          • AVG
          • CEILING
          • COS
          • COT
          • DEGREES
          • EXP
          • FLOOR
          • LOG
          • LOG10
          • PI
          • POWER
          • SQUARE
          • STDEV
          • STDEVP
          • VAR
          • POWER
          • RADIANS
          • ROUND
          • SQRT
        • Metadata functions
        • Ranking functions
        • String functions
        • System functions
        • XML Functions
      • Built-in procedures
      • Snowflake Scripting
      • System Tables
      • Queries
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. Translation Referencechevron-right
  2. SQLServerchevron-right
  3. Built-in functions

Mathematical functions

This section describes the functional equivalents of mathematical functions in Transact-SQL to Snowflake SQL and JavaScript code, oriented to their usage in stored procedures in SnowFlake.

ABSchevron-rightACOSchevron-rightASINchevron-rightATANchevron-rightATN2chevron-rightAVGchevron-rightCEILINGchevron-rightCOSchevron-rightCOTchevron-rightDEGREESchevron-rightEXPchevron-rightFLOORchevron-rightLOGchevron-rightLOG10chevron-rightPIchevron-rightPOWERchevron-rightSQUAREchevron-rightSTDEVchevron-rightSTDEVPchevron-rightVARchevron-rightPOWERchevron-rightRADIANSchevron-rightROUNDchevron-rightSQRTchevron-right
PreviousIIFchevron-leftNextABSchevron-right

Last updated 1 year ago