Issue with Date Format in Metabase Native Query (Oracle)

Get Help
1

I'm facing an issue with date formatting in my Metabase native query for Oracle.

  • I have a function in my query that expects dates in the 'MM-DD-YYYY' format.
  • Initially, I used this format directly in my native query without TO_DATE conversion, but the data count was incorrect.
  • To resolve this, I added TO_DATE conversion along with the {{asondate}} filter.

However, Metabase passes date parameters in the 'YYYY-MM-DD' format by default, which results in the error:

ORA-01843: not a valid month

Has anyone encountered a similar issue? How can I ensure that Metabase correctly formats the date before passing it to the query?

Any guidance would be appreciated!

clipboard-202503171103-73rfi
clipboard-202503171103-73rfi1363×493 20.5 KB

2

What version of metabase are you running?