Re: Date Query Issue

Sorry, yes it was!

After lunch drowsiness...

select ?? from table where trunc(date_field) = to_date('15/05/99','DD/MM/YY');

Kevin A Lewis wrote in message ...
>I may be wrong but I think the trunc may be on the wrong side of the where
>clause.
>
>Regards
>
>--
>Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
> <KevinALewis_at_HotMail.com>
>
>The views expressed herein by the author of this document
>are not necessarily those of BOCM PAULS Ltd.
>Mark Gumbs <mgumbs_at_nospam.hotmail.com> wrote in message
>news:375fbdef.0_at_145.227.194.253...
>> Try using the trunc command to strip off the time element.
>>
>> eg select ?? from table where date_field =
>> trunc(to_date('15/05/99','DD/MM/YY');
>>
>> M
>>
>> Neil Robinson wrote in message <7joe5k$4bi$3_at_news6.svr.pol.co.uk>...
>> >I have an Access97 front end that uses Oracle 7.3 over odbc. A few of
>the
>> >queries that I need to produce involve dates or date ranges. When I try
>to
>> >query on a single date using the criteria
>> >
>> >[field] = #15/05/99#
>> >
>> >the database returns only those records which have a date of 15/5/99 and
>no
>> >time value. If there is a time value within the record it's not
>returned.
>> >ie
>> >
>> >record a: 15/5/99 11:19:04
>> >record b: 15/5/99
>> >record c: 15/5/99
>> >record d: 15/5/99 12:18:33
>> >record e: 15/5/99
>> >
>> >3 records from this set would be returned. This is not a problem when
>> >querying a date range as the >= and <= operators alleviate it. I also
>need
>> >to be able to query single dates though and I can't see a simple way of
>> >doing it, given that the date will be on a user-input form.
>> >
>> >Any ideas?
>> >
>> >Thanks in advance
>> >
>> >--
>> >Neil Robinson
>> >
>> >
>>
>>
>
>
Received on Thu Jun 10 1999 - 09:19:28 CDT