The to_date function we talked earlier make a come back.
The wrong way to do it is :
SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = '12-04-27'
you end up comparing string in that case to work you need to do the following:
SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = to_date('12-04-27','yy-mm-dd')
I saw some example where user needed to use the TRUNC function on the date_and_time, so if it doesn’t work with the previous answer try using the TRUNC function.