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

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 2 years ago