I'm trying to execute this:

SELECT "resource"."resourcename" AS "Nombre del activo", "productType"."componenttypename" AS "Tipo de producto", CASE WHEN compDefLaptop.islaptop != 0 THEN 'true' ELSE 'false' END AS "Es portátil", "state"."displaystate" AS "Estado del activo", "aaauser"."first_name" AS "Usuario", "deptDef"."deptname" AS "Departamento", "osinfo"."osname" AS "Sistema operativo", "osinfo"."servicepack" AS "Service Pack", substring(longtodate("resource"."acquisitiondate"),1,10) AS "Fecha de compra", substring("sys"."BIOSDATE",7,2)+char(47)+substring("sys"."BIOSDATE",5,2)+char(47)+substring("sys"."BIOSDATE",1,4) AS "Fecha de BIOS", "sys"."model" AS "Modelo del activo", "aaov"."name" AS "Sitio", "resLocation"."location" AS "Ubicación" FROM "resources" "resource" LEFT JOIN "componentdefinition" "product" ON "resource"."componentid" = "product"."componentid" LEFT JOIN "componenttype" "productType" ON "product"."componenttypeid" = "productType"."componenttypeid" LEFT JOIN "resourcestate" "state" ON "resource"."resourcestateid" = "state"."resourcestateid" LEFT JOIN "resourceowner" "rOwner" ON "resource"."resourceid" = "rOwner"."resourceid" LEFT JOIN "resourceassociation" "rToAsset" ON "rOwner"."resourceownerid" = "rToAsset"."resourceownerid" LEFT JOIN "resources" "rToAssetResource" ON "rToAsset"."assttoresourceid" = "rToAssetResource"."resourceid" LEFT JOIN "sduser" "sdUser" ON "rOwner"."userid" = "sduser"."userid" LEFT JOIN "aaauser" "aaaUser" ON "sduser"."userid" = "aaauser"."user_id" LEFT JOIN "departmentdefinition" "deptDef" ON "rOwner"."deptid" = "deptDef"."deptid" LEFT JOIN "resourcelocation" "resLocation" ON "resource"."resourceid" = "resLocation"."resourceid" LEFT JOIN "sitedefinition" "siteDef" ON "resLocation"."siteid" = "siteDef"."siteid" LEFT JOIN "sdorganization" "aaov" ON "siteDef"."siteid" = "aaov"."org_id" LEFT JOIN "systeminfo" "sys" ON "sys"."workstationid" = "resource"."resourceid" LEFT JOIN "componentdefinitionlaptop" "compDefLaptop" ON "product"."componentid" = "compDefLaptop"."componentid" LEFT JOIN "osinfo" "osinfo" ON "sys"."workstationid" = "osinfo"."workstationid" WHERE "product"."componenttypeid" IN( '1', '308', '309') 

and the part of substring(longtodate("resource"."acquisitiondate"),1,10) fails, works if i use longtodate("resource"."acquisitiondate"). How can I convert the unix_time to dd/mm/YYYY?