Pivot table show dates in wrong format

[wagner.nardin]

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?

[Villeroy]

Do not convert dates to char. 13/12//2024 is not a date by any means.

[Timur]

Seems like a still open bug: 80177 – Date values from registered database appear as numbers when using them in a Pivot table data