Re: Search by Dates results not showing properly in Oracle 8i

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 10 Sep 2006 10:17:14 -0700
Message-ID: <1157908634.903129.167680@m79g2000cwm.googlegroups.com>

vishi83_at_gmail.com wrote:
> Hello ppl,
>
> I want to search records having a date that falls before a given date.
>
> Example: I would like to search some records having a date which falls
> before 5th of september.
>
> Plz help me out with a query for oracle 8i.
>
>
>
> Thanks :)

What have you tried (post title suggests you did try something?) Did you try the obvious WHERE date_column < TO_DATE('05092006','ddmmyyyy')?

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Sun Sep 10 2006 - 12:17:14 CDT