SnowConvert - Translation Spec
search
Ctrlk
  • For Teradata
  • Translation Referencechevron-right
    • Teradatachevron-right
    • Oraclechevron-right
    • SQLServerchevron-right
      • General Language Elementschevron-right
      • DDLschevron-right
      • DMLschevron-right
      • Data Types
      • Statementschevron-right
      • Built-in functionschevron-right
        • SnowConvert custom UDFschevron-right
        • Aggregate functionschevron-right
        • Analytic Functionschevron-right
        • Conversion functionschevron-right
        • Data Type functionschevron-right
        • Date & Time functionschevron-right
        • Logical functionschevron-right
        • Mathematical functionschevron-right
          • ABS
          • ACOSchevron-right
          • ASINchevron-right
          • ATANchevron-right
          • ATN2chevron-right
          • AVG
          • CEILING
          • COSchevron-right
          • COTchevron-right
          • DEGREESchevron-right
          • EXPchevron-right
          • FLOOR
          • LOGchevron-right
          • LOG10chevron-right
          • PIchevron-right
          • POWERchevron-right
          • SQUARE
          • STDEV
          • STDEVP
          • VAR
          • POWER
          • RADIANSchevron-right
          • ROUND
          • SQRT
        • Metadata functionschevron-right
        • Ranking functionschevron-right
        • String functionschevron-right
        • System functionschevron-right
        • XML Functionschevron-right
      • Built-in procedureschevron-right
      • Snowflake Scriptingchevron-right
      • System Tableschevron-right
      • Querieschevron-right
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