Re: Selecting records by the Time of a Date column

Hi,

Following query may be your problem's answer:

         select (SYSDATE,'HH24:MI:SS')"NOW" FROM DUAL;

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'
>
> It does not work. How can I get it. Is there any function to get the time
> from a date?
>
> Thanks in advanced
>
> Mikel
Received on Thu Apr 30 1998 - 11:45:52 CDT