Error Code: 3065 Invalid Date Input Value

[Lukas Weberruss]

Hi,

I run the following sql sequence (entries older than 90 + 60 min.) on an 
oracle db with no error:

select count(*) as count_older_90min 
        from SXMSPHIST 
        where 
        (
                (
                        TO_DATE('20050418164435','YYYYMMDDHH24MISS')-
                        TO_DATE(sendtst,'YYYYMMDDHH24MISS')
                ) * (24*60)
        ) > 150



with MAXDB I am getting the following error " -3065 : Invalid Date Input 
Value". I'm using oracle compatibility mode.
Can you please tell me how to format the date/time fields correctly.

Mfg
Lukas Weberruss