Re: Between dates query

From: Ari Kaplan <akaplan_at_interaccess.com>
Date: Wed, 8 Sep 1999 13:33:51 -0500
Message-ID: <rtdbmca51iv26@corp.supernews.com>

What is the error that you are getting?

-Ari Kaplan

Oracle Tips HomePage: http://homepage.interaccess.com/~akaplan

Mike Fellows wrote in message <7r66sa$4aj$1_at_gxsn.com>... Hi there

I have bben trying to create an SQL script used within a form to = search for a value between two dates

along the lines of ....

SELECT MONTH FROM TIME T
WHERE :BLOCK1.VAL BETWEEN T.DATE_1 AND T.DATE_2 This works fine, but when I try to carry out a TO_DATE function to = ensure Y2K compliancy, I get an error.

The script is as follows

    SELECT MONTH FROM TIME T
    WHERE :BLOCK1.VAL BETWEEN
    TO_DATE('T.DATE_1','DD-MON-RR') AND TO_DATE('T.DATE_2','DD_MON_RR)          Any ideas are greatly appreciated..     TIA          Mike Received on Wed Sep 08 1999 - 13:33:51 CDT