Re: problem with selects based on dates

Hi,

"J.H.M. Dassen (Ray)" wrote:

> Mike Withers <M.withers@uws.edu.au> wrote:
> > db2001=# SELECT * FROM emp WHERE hiredate > 1981-01-01;
>                                               ^^^^^^^^^^
>
> > It is not clear to me why in the last query the 1980-12-17 hiredate record
> > is selected as well.
>
> There are no quotes around what you intend to be the date. Thus it is
> evaluated as an expression, resulting in 1979. Try
>         SELECT * FROM emp WHERE hiredate > '1981-01-01';

But better to use:  to_date( '1981-01-01','YYYY-MM-DD')
SELECT * FROM emp WHERE hiredate > to_date( '1981-01-01','YYYY-MM-DD')

CoL