How to change the output format of DateTime in a session

If you want, you can change the DateTime output format during a session using the statement.

SELECT CURRENT_DATE();

ALTER SESSION SET DATE_OUTPUT_FORMAT = 'DD MM YYYY';

SELECT CURRENT_DATE();

If you want to query which form is set in this session you can find the value of the parameter using this query

SHOW PARAMETERS LIKE 'DATE_OUTPUT_FORMAT' 
IN SESSION;