I have a pivot table in calc which points on data from a Libreoffice database.
It takes the data with an sql request like this :
SELECT "myTable"."date", "OtherTables"."otherData"... FROM "myTable", "otherTables"... WHERE conditions...
But in the pivot table, dates appear as numeric values like “40800”, I would like them to appear as “14/09/2011”.
I can’t figure out how to do this. Can someone help me?
The libreoffice manual says that pivot tables use the formatting of the data source. In my database, the dates are formatted as date of course.
I tried to use sql convert functions like TO_DATE() but I had no success Chapter 4. Built In Functions
I guess I must use some sql function like CONVERT or TO_DATE but I can figure out If I am right,