donderdag 14 december 2023

Snowflake issue with DATE_OUTPUT_FORMAT parameter

Today we encountered an issue with Snowflake. The DATE_OUTPUT_FORMAT parameter was not used when outputting the DATE datatype. The DATE_OUTPUT_FORMAT parameter is een parameter that formats the display of a DATE column or for instance the CURRENT_DATE() function.

So this was the issue :

The parameter setting on ACCOUNT Level in Snowflake is set to YYYY-MM-DD.

Normally it was formatted according due the dutch date format settings into something like this (not the same setting as the example above):

A couple of persons also reported the same issue on the Snowflake Forums

After a day it's solved by Snowflake.

Geen opmerkingen:

Een reactie posten