Re: Query Date Column from FORMS 4.5
From: Ian Jones <ijones_at_slip.net>
Date: 1998/03/01
Message-ID: <34f99afe.65107049_at_news.slip.net>#1/1
Date: 1998/03/01
Message-ID: <34f99afe.65107049_at_news.slip.net>#1/1
>trunc(date_column) = trunc(:whatever_entered_in_form) this will eliminate
>the time
This is fine, but the trunc(date_column) will prevent any index getting used, which may give you performance problems.
The date_column>=x and date_column<=x+0.99999 appoach won't. Received on Sun Mar 01 1998 - 00:00:00 CET