APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex 4.1 gantt date truncated

jareeqOct 21 2011 — edited Oct 27 2011

Hi Again,

I'm trying to create gantt chart using apex.

source sql is:

select '' link,
       1 ID,
       'T1' TASK_NAME,

       null PARENT_ID,
       sysdate START_DATE,
       sysdate+ .011 END_DATE

  from dual union
select '' link,
       2 ID,
       'T1' TASK_NAME,

       null PARENT_ID,
       to_date('2011-10-11 12:31','YYYY-MM-DD hh24:mi') START_DATE,
       to_date('2011-10-12 21:41','YYYY-MM-DD hh24:mi') END_DATE

  from dual union
select '' link,
       3 ID,
       'T1' TASK_NAME,

       null PARENT_ID,
       sysdate+.4 START_DATE,
       sysdate+ .811 END_DATE

  from dual

Like you see above I'm putting hours minutes and seconds but displayed chart contains only valid date, all other data looks like this (from XML debug message):

<period resource_id="1" start="2011.10.21 00.00.00" end="2011.10.21 00.00.00" style="defaultStyle"/>
<period resource_id="2" start="2011.10.11 00.00.00" end="2011.10.12 00.00.00" style="defaultStyle"/>
<period resource_id="3" start="2011.10.21 00.00.00" end="2011.10.21 00.00.00" style="defaultStyle"/>

Also created sample app available here:

http://apex.oracle.com/pls/apex/f?p=56739

but result is the same.

According to some other user ( http://apex.oracle.com/pls/apex/f?p=36648:71:706382355392067::NO:::) apps this precision works fine in anycharts.

I'm stuck here so little help will be appreciated.

Thanks,
jareeq

Edited by: jareeq on 2011-10-21 02:43

This post has been answered by Hilary Farrell-Oracle on Oct 24 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2011

Added on Oct 21 2011

#apex, #apex-discussions

3 comments

663 views