Quering a specific TIME not date

I dont know if its possible as ive tried everything but cant get it to work...

My data is stored as a date so its for example 23/03/2007 10:00:00

How would i write a SQL statement to find me all records that have 10:00 in them and ignore the date?

Ive tried "Where to_date(fieldname,'24H:MI') >=to_date('10:00',24H:MI') but it doesnt work

HELP ...... Received on Fri Jan 26 2007 - 05:19:47 CST