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

In article <377DDDD7.199F_at_yahoo.com>, Connor McDonald <connor_mcdonald_at_yahoo.com> writes
>Andy Hardy wrote:
>>
>> 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
>> ===============================================================
>
>Yes - but you can trap the query using pre-query and use
>set_block_property to build your own where clause based on the date they
>enter ...

But... this will then produce a 'where' clause within Oracle where I ask for a truncated date in default_where, but the Oracle enter_query/execute_query is still asking for the records that match the given values.

Andy

-- 
Andy Hardy. PGP key available on request
===============================================================