Re: Novice: select by time

Thanks for the nudge. Couldn't get trunc(date_field) to do it, but did lead me to
...where to_char(date_field, 'HH24:MI:SS') = '00:00:00' which seems to do the trick.

D.

Per-Arne Hellarvik <phellarv_at_genuity.no> wrote:
>trunc(<datetime>) should do the work....
>
>
>On Thu, 27 Jun 2002 16:34:09 +0200, dsmcd wrote:
>
>> Hello...
>>
>> I'd like to select all records whose time is 00:00:00 in a
>>datetime
>> field ('MM/DD/YY HH24:MI:SS').
>>
>> Any suggestions?
>>
>> Thanks in advance,
>> D.
Received on Thu Jun 27 2002 - 10:20:53 CDT