Last updated
Last updated
This custom UDF is added to avoid runtime exceptions caused by format differences when casting strings to DATE
, inside procedures and functions.
It creates a DATE
from a STRING
.
Parameters
DATESTR: A STRING
that represents a DATE
with a specific format.
Take into consideration that Oracle DATE
contains an empty TIMESTAMP
(00:00:00.000), while Snowflake DATE
does not. SnowConvert allows transforming DATE
to TIMESTAMP
with the flag.
: Date Type Transformed To Timestamp Has A Different Behavior