Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

Other

Current Behavior

Snowflake code input: to_char(pos.createdwhen,'yyyymmdd')
Databricks code output: TO_CHAR(pos.createdwhen, 'yyyymmdd')

Expected Behavior

Databricks code output: TO_CHAR(pos.createdwhen, 'yyyyMMdd')

Steps To Reproduce

1. In snowflake environment:
   select to_char(current_timestamp(),'yyyymmdd'); --output: 20241112

2. In databricks environment:
   select to_char(current_timestamp(),'yyyymmdd'); --output: 20240012
   while
   select to_char(current_timestamp(),'yyyyMMdd'); --output: 20241112 [correct output with format 'yyyyMMdd' ]

Relevant log output or Exception details

No response

Sample Query

No response

Operating System

macOS

Version

latest via Databricks CLI