Re: SQL to_date problem

> and ba_erkezes
> BETWEEN to_date('1998/09','YYYY/MM')
> and last_day( to_date('09/1998 23:59:59','mm/yyyy hh24:mi:ss'))

or use the trunc function

... and trunc(ba_erkezes,'YYYY/MM') = to_date('1998/09','YYYY/MM') ...

--
name: Johan Ur Riise
org: unic consulting
email: riise_at_bgnett.no
mob: +47 90 15 77 78 Received on Thu Oct 22 1998 - 15:30:19 CDT