I have a report where I use the query bellow.  What I need is that the date fields (wo.CREATEDTIME, wo.DUEBYTIME, etc) comes only with date format "dd/mm/yyyy" (in my case, in Brazil).

How can I get this?

SELECT ti.FIRST_NAME "Técnico",wos.ISOVERDUE "Status do vencimento",sdo.NAME "Local",wo.WORKORDERID "Identificação da solicitação",aau.FIRST_NAME "Solicitante",longtodate(wo.CREATEDTIME) "Hora de criação",longtodate(wo.DUEBYTIME) "Hora do vencimento",wo.TITLE "Assunto",longtodate(wos.LAST_TECH_UPDATE) "Horário da última atualização",(std.STATUSNAME::text) "Status da solicitação" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ((((((std.STATUSNAME LIKE '«erto%') OR (std.STATUSNAME LIKE '%Aguardando Aprovação%')) OR (std.STATUSNAME LIKE '%Em andamento%')) OR (std.STATUSNAME LIKE '%Pendente%')) OR (std.STATUSNAME LIKE '%Suspenso%')) OR ((std.STATUSNAME::text) IS NULL))  AND wo.ISPARENT='1'  ORDER BY 1 NULLS FIRST , 3 NULLS FIRST , 7 NULLS FIRST 

Tks

Sofia.