Re: filtering records between 2 dates

[techie21 IT <techiei876@xxxxxxxxx>]

my sql statement is like below:-

SELECT * FROM p2
WHERE ORDDAT  BETWEEN  01/01/1960  AND  31/12/2000

Comparison operator BETWEEN operands not compatible.

File P2 is having ORDDAT field as a date field and is defined using 'L'
data type.

So I want to filter records between some specific date range but unable to
do so because of the mentioned error.
So need  guidance how could i remove this error to get desired results?


Thanks much..


On Sat, Jul 18, 2020 at 1:52 AM techie21 IT <techiei876@xxxxxxxxx> wrote:

> experts any updates please?
>
> On Sat, Jul 18, 2020 at 12:53 AM techie21 IT <techiei876@xxxxxxxxx> wrote:
>
> > hi,
> >
> > when trying to filter records between 2 dates getting this error:-
> > Message ID . . . . . . :   SQL0401       Severity . . . . . . . :   30
> >
> > Message type . . . . . :   Diagnostic
> >
> >
> >
> > Message . . . . :   Comparison operator BETWEEN operands not compatible.
> >
> > Cause . . . . . :   The operands of comparison operator BETWEEN are not
> >
> >   compatible.
> >
> >     -- Numeric operands are compatible with any other numeric operands
> > and
> >   with character and graphic operands.
> >
> >     -- Character operands are compatible with operands that are
> > character,
> >   graphic, date, time, timestamp, or numeric.
> >
> >     -- Date, time, and timestamp operands are compatible with character
> > and
> >   graphic operands or with another operand of the same type. Date and
> >
> >   timestamp operands are also compatible.
> >
> >     -- Graphic operands are compatible with graphic, character, date,
> > time,
> >   timestamp, or numeric operands.
> >
> >     -- Binary operands are compatible only with binary operands.
> >
> >
> >  More...
> > Press Enter to continue.
> >
> >
> >
> > F3=Exit   F6=Print   F9=Display message details