SELECT *
FROM MYTABLE
WHERE TO_DATE( TO_CHAR( MYDATE, 'HH24:MI' ), 'HH24:MI' ) >
O_DATE( '12:30', 'HH24:MI' )
Mikel Bengoa schrieb in Nachricht <01bd73a9$fc2e4540$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 Thu Apr 30 1998 - 03:38:03 CDT
