How to search by date in Oracle

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.