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?