Re: [GENERAL] problem with selects based on dates

2001-09-14 Thread Szabo Zoltan
Hi, "J.H.M. Dassen (Ray)" wrote: > Mike Withers <[EMAIL PROTECTED]> 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 we

[GENERAL] problem with selects based on dates

2001-09-06 Thread Mike Withers
Hi everyone I have a problem with SELECTs using dates and WHERE. Some examples: SELECT * FROM emp; empno | ename|job | mgr | hiredate | sal | comm | deptno ---+++--++--+--+ 7499 | ALLEN | SALESMAN | 7698 | 19