Currently in snowflake the date type column shows dates as YYYY-MM-DD format.

But i wanted to see them as MM-DD-YYYY format. For that i have run the below sql command

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

SHOW PARAMETERS LIKE 'DATE_OUTPUT_FORMAT';

and we can see its set

later in the worksheet i ran select * from sometable and we can see the date columns as MM-DD-YYYY format

but in the data preivew we still see the date as YYYY-MM-DD

how to make the data preivew also show date as YYYY-MM-DD

Currently in snowflake the date type column shows dates as YYYY-MM-DD format.

But i wanted to see them as MM-DD-YYYY format. For that i have run the below sql command

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

SHOW PARAMETERS LIKE 'DATE_OUTPUT_FORMAT';

and we can see its set

later in the worksheet i ran select * from sometable and we can see the date columns as MM-DD-YYYY format

but in the data preivew we still see the date as YYYY-MM-DD

how to make the data preivew also show date as YYYY-MM-DD

• snowflake-cloud-data-platform

1 Answer 1

You can change the date format from the three dots in Data Preview tab as shown in screenshot below.

From the documentation

The options available to you depend on the type of data in the column.

which based on my understanding means the preview data has a limited set of options.

I tested it by creating a date column and the options I see in the three dots are

-YYYY-MM-DD HH:MM:SS

-YYYY-MM-DD

-Mon YYYY