Re: Querying date fields
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Tue, 22 Sep 1998 19:28:24 +0200
Message-ID: <6u8mkt$fio$1_at_newton.a2000.nl>
Date: Tue, 22 Sep 1998 19:28:24 +0200
Message-ID: <6u8mkt$fio$1_at_newton.a2000.nl>
>Is there any way in forms to query a date field using > date or < date. I
>have already used the copy built-in in my prequery trigger to query a date
>between 00:00:00 and 24:59:59 due to the date field containing a time stamp
>and the the user only knowing the date of the field.
If I understand right, then you need trunc( my_date ). It will set the time part to 0:00:00. Try:
select to_char( sysdate, 'dd-mon-yyyy hh24:mi') , to_char( trunc( sysdate ), 'dd-mon-yyyy hh24:mi') from dual;
Arjan. Received on Tue Sep 22 1998 - 19:28:24 CEST