I want do native query in Oracle DB, with custom DATE column format (which include also time information). How to do it ?
I was trying to
alter session set NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI'
but this is rejected by Metabase with error Select statement did not produce a ResultSet for native query
Metabase does not support multi-statement queries.
You will have to define it with the Additional Connection String options in Admin > Databases, if the driver supports this.
But I would probably just format the output instead of trying to modify the session.
Driver doesn't support it, workaround is change select statement like this:
SELECT TO_CHAR(CREATE_DATE, 'DD-MM-YYYY HH24:MI') as Created,
but if you need to format multiple columns, you must edit each of them...