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!

Date Picker APEX 5 problem

marussigJun 19 2018 — edited Jun 19 2018

I can't figure out where could be a problem in date picker item (html5). I've made a Reflow Report. Body of refl.rep. contains two date picker items :P32_FROM and

:p32_TO. Looks like the problem could be here in item type... but it is not. I tested SQL and works fine.

WHERE ... AND

    table\_field

      BETWEEN :P32\_FROM

          AND :p32\_TO;

table_field is a TIMESTAMP, body items are date for date picker or date and time type concerning settings. Item format masks are as default YYYY-MM-DD"T"HH24:MI:SS nevertheless format is date or date and time.

Everything works fine if I replace :P32_FROM and :p32_TO with number or text type. My question is what could be wrong/significant with date picker? Messages are the same ORA-01843. What correlation is between database timestamp and date picker?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2018

Added on Jun 19 2018

#apex-discussions

6 comments

191 views