oracle queries

hello all,

I have the following query which executes in oracle.

select emp1.cid as empid, emp1.employeeno, emp1.name, 
emp1.email, cat.sendEmail,  cat.category,
char(remind.reminddate,'dd') as rday, 
char(remind.reminddate,'mon') as rmonth  from
tblEmployee emp1, tblReminderCategory cat, 
tblReminders remind,tblExtEmpInfo Ext  where emp1.cid
= remind.employee  and remind.category = cat.cid  and
date(char(remind.reminddate,'dd-Mon')  || '-' ||
'2000')  between
date(char(date('31/Oct/2003'),'dd-mon') || '-' ||
'2000') and date(char(date('31/Oct/2003') ,'dd-mon')
|| '-' || '2000')  and emp1.cid = ext.employee (+) and
 emp1.leftorg=0 and remind.category = 1


I tried to execute the same query in sap db with sql
mode set to oracle i get the following error

General error;-3065 POS(12) Invalid date input value.

what might be wrong. 

Regards,

Raghavan

__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx