Skip to Main Content
Forums

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!

Select data between two date items.

Eslam_ElbyalyJun 21 2017 — edited Jun 22 2017

Oracle forms 6i.

Hi,

I have a table(sales_order) with columns (sold_amount,sale_date). And two "DateTime" Items(:from_date and :to_date)

with the following format 'DD /MM /YYYY HH12:MI:SS' -- there are a space after DD and MM format elements.

I am trying to issue the following select statment

"Select nvl(sum(sold_amount),0) into v from sales_order where sale_date between :from_date and :to_date".

It return 0 when there are sold amounts between the two dates I am using. And it working with Toad.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2017
Added on Jun 21 2017
#forms, #moved-from-devops
9 comments
891 views