How do I create separate date and time columns in my report?

How do I create separate date and time columns in my report?

I need to create separate columns for the date and time of the "Effective From" and "Effective To" fields. Currently they are produced in one column.



SELECT wo.WORKORDERID AS "Request ID", wof.UDF_CHAR12 AS "Visitor Name", wof.UDF_CHAR11 AS "ID Number", wof.UDF_CHAR13 AS "Visitor Surname", wof.UDF_CHAR1 AS "From Company", longtodate(wof.UDF_DATE1) AS "Effective From", longtodate(wof.UDF_DATE2) AS "Effective To", std.STATUSNAME AS "Request Status", longtodate(wof.UDF_DATE3) AS "Card Issued Date/Time", wof.UDF_CHAR3 AS "Card Returned", wo.TIMESPENTONREQ AS "Time Elapsed" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE  (((wo.CREATEDTIME >= 1483221600000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1485899999000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1))))  AND wo.ISPARENT='1'

                  New to ADSelfService Plus?