APEX

Hello Everyone,

I need to create a gantt chart on time basis, like I want to show the daily work schedule of an employee(from 9.00 am to 10 am, 10.30 to 11.00am)

but when I created a gantt chart, it is coming up date wise, I expanded it to time, but then also its not showing timewise record.

I am storing time also with my date, and also mentioned the date format as 'MM/DD/YYYY HH:MI AM' in the Date Format field of the gantt chart.

this is query which I am using to create the chart:

SELECT NULL LINK,
EMP_ID ID,
(SELECT NAME FROM EMPLOYEE EMP WHERE CS.EMP_ID = EMP.EMP_ID) NAME,
NULL PARENT_ID,
TO_DATE(TO_CHAR(CS.START_TIME,'MM/DD/YYYY HH:MI AM'),'MM/DD/YYYY HH:MI AM') ACTUAL_START,
TO_DATE(TO_CHAR(CS.END_TIME,'MM/DD/YYYY HH:MI AM'),'MM/DD/YYYY HH:MI AM') ACTUAL_END
FROM CALENDAR_SLOT CS


Please help me to know how can I achieve this.

Apex 4.1
DB: 11gR2

Thanks
Tauceef