Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: search by date range
try select BLAH, BLAH, BLAH where date > to_date('01-NOV-1999',
'DD-MON-YYYY');
cindy
henry_atwork_at_my-deja.com wrote:
> will the following command work to find entries that are entered after
> 11/01/1999? select BLAH, BLAH, BLAH where date > '01-NOV-1999';
>
> if not how i can fix it? thanks.
>
> -hc
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Nov 13 1999 - 21:42:20 CST