ORA-01821: date format not recognized

[tamilselvan]

--------------
select * from system_log where log_date >= '28apr03';
----------------

Why don't you use to_date function?

Like:

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


Tamil