DateTime in SQL

I would like to filter a select statement by using date and time: select * where datefield = to_date('12/28/99 19:00:00') But, this doesn't work. How do I do this? Thanks, Bob Received on Thu Dec 30 1999 - 00:36:23 CST