DAYNUMBER_OF_MONTH
Translation specification for the transformation of the Teradata DAYNUMBER_OF_MONTH function to its Snowflake equivalent
Description
Returns the number of days elapsed from the beginning of the month to the given date. For more information check DAYNUMBER_OF_MONTH.
Both Teradata and Snowflake handle the DAYNUMBER_OF_MONTH function in the same way, except in one case:
The ISO calendar: An ISO month has 4 or 5 complete weeks. For more information check About ISO Computation.
To ensure functional equivalence, a user-defined function (UDF) is added for the ISO calendar case.
Sample Source Patterns
Teradata
Snowflake
ISO calendar
Teradata
Snowflake
Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated