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/[EMAIL PROTECTED]
