If you need a quick reference on how to convert SQL dates for use in a where clause in Oracle, I use the following format:

TO_TIMESTAMP ('12.31.2008:00:00:00','MM.DD.YYYY:HH24:MI:SS')

where you can replace the Dec 31, 2008 date with your date and alternatively, you can parse the date using a different format string, as you see in this example.