Dates in "Where" Clause

[Christian Hagen <christian.hagen@SMTPGATE.CRESTAR.COM>]

TO:  SQR-USERS@list.iex.net
>FROM:  Chris

SUBJECT:  Dates in "Where" Clause

_______________________________________________________________________

Does anybody know how to edit, format or manipulate dates when they are in a
where clause?

Platform is Oracle 7.3.3
SQR3

For example:

Select Column_1 &Column_1
Column_2  &Column_2
>From PS_TABLE where Date = $Var_Date

                ! right now $Var_Date is manipulated into this format:  30-JUN-97

Although the above statement works with the stated format I believe that I
will have a problem after 01/31/1999 ?!?

When attempting to use other formats the SQR halts and states that I have an
improper month.

I would like to use a format such as this:  '1997-06-30'   but again I get
an error message that I have an improper month.  So what I do is take the
above format ('1997-06-30' ) and string manipulate it into '30-JUN-97'
format.

Any insight to this date problem would be greatly appreciated.

Thank you in advance for your time and consideration.

Chris