Pivot table show dates in wrong format

I runing query in libreoffice base connected in postgresql db, that i want to view as a pivot table in libreoffice calc.
My query return dates with this code:

TO_CHAR(“manifest”.“datein”,‘DD/MM/YYYY’) “Date In”,

but, when insert pivot table in calc, this column show dates only in timestamp format, not on date format.

What can be wrong?