Re: Between Dates Query

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 9 Sep 1999 00:13:25 +0200
Message-ID: <936828858.14947.0.pluto.d4ee154e@news.demon.nl>

The column name in the to_date doesn't need quotes, it should be = to_date(t.date_1,'DD-MON-RR') etc.

Hth,

--
Sybrand Bakker, Oracle DBA
Mike Fellows <mfello_at_globalnet.co.uk> wrote in message = news:7r671s$po0$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 - 17:13:25 CDT