LONGTODATE not formatting
I'm not sure what I'm doing incorrectly but LONGTODATE isn't formatting as a human readable format. My query is below (we're running PostgreSQL):
SELECT icm.ChangeID as "ChangeId" ,icm.workorderid as "IncidentId", wo.title as "IncidentTitle", cd.title as "ChangeTitle", org.name as "SiteName", coalesce(tech.firstname, '') || ' ' || coalesce(tech.lastname, '') as "Technician", coalesce(req.firstname, '') || ' ' || coalesce(req.lastname, '') as "Requestor", pd.priorityname as "Priority", LONGTODATE(WO.createdtime) as "Created Date" FROM IncidentToChangeMapping icm inner join changedetails cd on cd.changeid = icm.changeid inner join workorder wo on wo.workorderid = icm.workorderid inner join SDOrganization org on cd.siteid = org.org_id left join sduser tech on cd.technicianid = tech.userid left join sduser req on cd.initiatorid = req.userid left join prioritydefinition pd on cd.priorityid = pd.priorityid
The query report runs but the work order createdtime field still displays as an epoch value.
Apprecicate any help