Dates in "Where" Clause

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

TO:  LISTSERV@LIST.IEX.NET, SQR-USERS@LIST.IEX.NET
>FROM:  Chris

SUBJECT:  Dates in "Where" Clause

(sorry if this went out twice - I seem to have problems posting to this
bboard)

_______________________________________________________________________

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   A
Where A.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 or bad string. 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