INT_TO_DATE_UDF
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Definition
UDF that reproduces Teradata's NUMERIC-TO-DATE functionality
PUBLIC.INT_TO_DATE_UDF(NUMERIC_EXPRESSION INTEGER)
Parameters
NUMERIC_EXPRESSION
INTEGER
A value that represents a DATE Type
Returns
Input number converted into a date data type.
Example
Input:
SELECT * FROM table1
WHERE date_column > 1011219
Output:
SELECT
* FROM
table1
WHERE date_column > PUBLIC.INT_TO_DATE_UDF( 1011219) /*** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'INT_TO_DATE_UDF' INSERTED. ***/;
Last updated