Date format in query reports
Hello,
When i try to get some data by a new query report (in SDP), i have some problem with the dates format:
If I use the sdp built-in function "longtodate(wo.createdtime)", the date is returned in a useless format for me (i am spanish). If I use the function "from_unixtime(wo.createdtime)" the thing gets better (YYYY-MM-DD HH:MM:SS) but i am interested in a specific date format: "DD/MM/YYYY HH:MM:SS".
I don't know the reason when i use the function "convert()" or "date_format()", i get some senseless errors (strange java compiling errors show up in the error window).
Thanks and regards.
Rubén Ansótegui
When i try to get some data by a new query report (in SDP), i have some problem with the dates format:
If I use the sdp built-in function "longtodate(wo.createdtime)", the date is returned in a useless format for me (i am spanish). If I use the function "from_unixtime(wo.createdtime)" the thing gets better (YYYY-MM-DD HH:MM:SS) but i am interested in a specific date format: "DD/MM/YYYY HH:MM:SS".
I don't know the reason when i use the function "convert()" or "date_format()", i get some senseless errors (strange java compiling errors show up in the error window).
Thanks and regards.
Rubén Ansótegui