SQL editor - CAST type not being returned

1

From the SQL editor, I’d like to be able to return a simple date to a report rather than the entire datetime string.

select cast(current_date as date);

OR

select current_date::date -- (I'm on Postgres);

Running that in any other client gets me ‘YYYY-MM-DD’ but Metabase returns time as well.

What am I missing?

2

We had the same issue here.
This seems to have done the trick:

SELECT CAST(current_date as VARCHAR(10));