I'm trying to delete rows for a given date from my table. Currently, it only works when I format it as follows:
delete from table_name
where date_entered = to_date('20-SEP-15 11:10:35', 'dd-MON-yy hh:mi:ss');
trunc() function - it removes the time from a datetime value.
delete from table_name where trunc(date_entered) = to_date('20-SEP-15', 'dd-MON-yy');