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>


>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

Original text of this message