Search Again: Re: Server-side sql using between/and From: Robin Quasebarth Date: Tuesday, October 21, 2003 Time: 8:09:40 am If the date is actually stored in a DATE format (not char) you can use the BETWEEN ( between '01-JAN-03' AND '31-OCT-03' )function but that will include both the high and low dates specified. Remember to TRUNC the dates if needed since a date field in Oracle stores time as well. TRUNC puts the date at Midnight of the date. You can use ( trunc (date_field)+1 >= to_date('01-JAN-03') AND trunc(date_field) < to_date ('31-OCT-O3') ) If you do not want to include the specified dates. Robin > How can I specify, in sql, that I'd like the server to process and send a > client only the records that fall BETWEEN a start date AND an end date that > the user specifies at run-time? > > ---------------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit http://www.digitalpoint.com/lists/oracle.html > ---------------------------------------------------------- > > ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ----------------------------------------------------------

Messages In This Thread: Server-side sql using between/and by Pellegrini, Anthony on Oct 21, 2003 at 7:23:39 am Re: Server-side sql using between/and by Robin Quasebarth on Oct 21, 2003 at 8:09:40 am