ROUND_DATE_UDF
Last updated
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
User-defined function (UDF) that processes the DATE_VALUE with the time portion of the day rounded to the unit specified by UNIT_TO_ROUND_BY. The equivalent function in Teradata is ROUND(date).
DATE_TO_ROUND
TIMESTAMP_TZ
The date to be rounded.
UNIT_TO_ROUND_BY
VARCHAR
The unit to round the date to.
Returns the date rounded by the unit defined in UNIT_TO_ROUND_BY.
Input:
Output: