Re: Selecting records by the Time of a Date column

Mikel Bengoa wrote:

> Hi,
>
> I have a table with a column that is a "Date" and I would like to get a set
> of records with the condition that the time part of this date is greater
> than a Value.
>
> I would like to do something like that:
>
> Select * from MyTable Where MyDate> '12:30'

Try select *
  from table
  where mydate - trunc(mydate) > 12/24 + 30/1440

r u d i
(remove anti-spam measure from reply-address) Received on Thu Apr 30 1998 - 13:27:05 CDT