ORA-01821: date format not recognized

[slimdave]

Why don't you use to_date function?

Like:

select * from system_log
where log_date >= to_date('28-apr-03',''dd-mon-yy');

Better yet, why not learn the lessons of Y2K and specify ...

to_date('28-apr-2003','dd-mon-yyyy')