Re: Selecting records by the Time of a Date column

Hi Mikel,

try:

Select * from MyTable Where TO_CHAR(MyDate, 'HH24:MI') > '12:30'

good luck,

Paul.

Mikel Bengoa <miksil_at_jet.es> wrote in article <01bd73aa$5165c2e0$d39d37c3_at_pcmikel>...
> 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 Wed Apr 29 1998 - 00:00:00 CDT