Re: F45, how to query a date(time) column with just the date?
From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Fri, 2 Jul 1999 16:27:32 +0100
Message-ID: <vcYZFFAkpNf3Ewof_at_ahardy.demon.co.uk>
Date: Fri, 2 Jul 1999 16:27:32 +0100
Message-ID: <vcYZFFAkpNf3Ewof_at_ahardy.demon.co.uk>
[Quoted] In article <377CD576.C8A60CD_at_itacs.strath.ac.uk>, Mungo Henning
<mungoh_at_itacs.strath.ac.uk> writes
>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.
True, but it's not something you can do with the standard 'ENTER_QUERY', 'EXECUTE_QUERY' forms functionality i.e. when you use them, there's no WHERE/DEFAULT_WHERE clause to set.
Andy
>HTH
>
>Mungo
>--
>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.
>
>
-- Andy Hardy. PGP key available on request ===============================================================Received on Fri Jul 02 1999 - 17:27:32 CEST