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