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
          • AT TIME ZONE
          • SWITCHOFFSET
          • DATEADD
          • DATEDIFF
          • DATEPART
          • DATEFROMPARTS
          • DATENAME
          • DAY
          • EOMONTH
          • GETDATE
          • MONTH
          • SYSDATETIME
          • SYSUTCDATETIME
          • YEAR
        • Logical functionschevron-right
        • Mathematical functionschevron-right
        • 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

Date & Time functions

This section describes the functional equivalents of date & time functions in Transact-SQL to Snowflake SQL and JavaScript code.

AT TIME ZONEchevron-rightSWITCHOFFSETchevron-rightDATEADDchevron-rightDATEDIFFchevron-rightDATEPARTchevron-rightDATEFROMPARTSchevron-rightDATENAMEchevron-rightDAYchevron-rightEOMONTHchevron-rightGETDATEchevron-rightMONTHchevron-rightSYSDATETIMEchevron-rightSYSUTCDATETIMEchevron-rightYEARchevron-right
PreviousDATALENGTHchevron-leftNextAT TIME ZONEchevron-right

Last updated 1 year ago