Selecting records by the Time of a Date column

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