Re: F45, how to query a date(time) column with just the date?

[Quoted] [Quoted] If you try the function "trunc" (truncate) on a date methinks it throws away the
time element, hence in the WHERE clause you can compare a truncated record from the table with what the user has typed in. HTH Mungo

--
[Quoted] Mungo Henning - it's a daft name but it goes with the face...
mungoh_at_itacs.strath.ac.uk.http://www.itacs.strath.ac.uk/
(since everyone else does it) I speak for me, not my employer.