Oracle Forms

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!

Strange behaviour with date with year 3000 in query

448225Apr 25 2006 — edited Nov 15 2008

Hi,

I've got a from date and a to date field in a form. When I fill in a to date with a year 3000 or more the query returns no records. This is my where clause of the query:
WHERE message_datetime BETWEEN TO_DATE(l_begin_date,'DD/MM/YYYY HH24:MI:SS') AND TO_DATE(l_end_date,'DD/MM/YYYY HH24:MI:SS').
The variable l_begin_date and l_end_date contains the values of the fields in the form.
If I fill in 2999 the query works fine. Can anyone help me?
Thanks

Ken

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2006

Added on Apr 25 2006

#forms, #moved-from-devops

16 comments

1,582 views