2

I went through the Snowflake docs and found that the default date_output_format in snowflake is "YYYY-MM-DD". We can change it to per session as (alter session set date_output_format = 'DD-MON-YYYY').

But I want to change the default value irrespective of the session. So that whenever I open the snowflake and query the date should be in the format "DD-MON-YYYY".

Can anyone please help me, if it's possible to do so?

Lukasz Szozda
  • 162,964
  • 23
  • 234
  • 275
Madman
  • 80
  • 5

1 Answers1

2

Depending on needs DATE_OUTPUT_FORMAT could be set up on ACCOUNT/USER level:

ALTER ACCOUNT SET date_output_format = 'DD-MON-YYYY';

ALTER USER <user_name> SET date_output_format = 'DD-MON-YYYY';

Related: Parameter Hierarchy and Types

Lukasz Szozda
  • 162,964
  • 23
  • 234
  • 275