Hi,
"J.H.M. Dassen (Ray)" wrote:
> Mike Withers <M(dot)withers(at)uws(dot)edu(dot)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