Alter Session
In this page you could find information about Session.
Alter session
Alter session has an equivalent in Snowflake and some the variables are mapped to Snowflake variables. If a permutation of Alter Session is not supported the node will be commented and a warning will be added.
-- Oracle
alter session set nls_date_format = 'DD-MM-YYYY';
-- Snowlake
alter session set /*** MSC-WARNING - MSCEWI3058 - NLS_DATE_FORMAT SESSION PARAMETER DOES NOT ENFORCE THE INPUT FORMAT IN ORACLE ***/
DATE_INPUT_FORMAT = 'DD-MM-YYYY' DATE_OUTPUT_FORMAT = 'DD-MM-YYYY';
Session Parameters Reference
Session Parameter
Snowflake transformation
NLS_DATE_FORMAT
DATE_INPUT_FORMAT and DATE_OUTPUT_FORMAT
NLS_NUMERIC_CHARACTERS
NOT SUPPORTED
Last updated
Was this helpful?