Issue with Oracle DB timestamps

Get Help
1

Hi,

I’m having an issue with custom queries containing the to_timestamp function.

When I connect to the database through intelliJ I can execute the following query without any issues:

select to_timestamp(to_char(BISLADEDATUM, 'DD-MM-YYYY HH24:MI:SS')) from VIEW_TA where ROWNUM <= 10

If I use the exact same query in a metabase question, I get the following error:
ORA-01843: not a valid month

I find it strange that the month is not valid, while it seems to be valid when I perform the query outside of metabase.

What could cause this issue?

2

Hi @JPW
It looks very similar to Same Query but error report
Which version of Metabase? Post “Diagnostic Info” from Admin > Troubleshooting
And which version of ojdbc8.jar?