help with date (function) sql

[Tuma]

...the trunc/sysdate suggestions did the trick.

Thanks a bundle fellows....i appreciate it wholesale.