I found a workaround:
select 1 from dual where subdate('2005-11-25 11:04:10.456231',40)>'2005-11-23
11:34:04.985364'
did I miss a math lesson? ;-)
Thorsten
Thorsten Rosenkranz <[EMAIL PROTECTED]> schrieb:
> Hi
>
> I get a wrong result "1" with the following statement:
>
> select 1 from dual where '2005-11-23 11:34:04.985364'<subdate('2005-11-25
> 11:04:10.456231',40)
>
> with "select subdate('2005-11-25 11:04:10.456231',40) from dual" I get the
> correct result "2005-10-16 11:04:10.456231".
>
> "select 1 from dual where '2005-11-23 11:34:04.985364'<'2005-10-16
> 11:04:10.456231'" is also correct and results to nothing.
>
> I testet this statement in three db-versions:
>
> sapdb 7.3.0 Build 029-000-087-696 works correct
> maxdb 7.5.0 Build 030-121-100-791 and maxdb 7.6.0 Build 016-121-109-428 are
> wrong
>
> kind regards, Thorsten
>
>
> --
>
> Thorsten Rosenkranz
>
> Imago Informationstechnologie GmbH
> Sauerwiesen 6
> 67661 Kaiserslautern
> Tel. 06301-708-0
> Fax. 06301-708-222
> mailto:[EMAIL PROTECTED]
> http://www.imago.de
> HRB 3008 Amtsgericht Kaiserslautern
> USt-IdNr. DE 174941022
> Geschäftsführer: Herr Dipl.-Ing. Christian Keller
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
Thorsten Rosenkranz
Imago Informationstechnologie GmbH
Sauerwiesen 6
67661 Kaiserslautern
Tel. 06301-708-0
Fax. 06301-708-222
mailto:[EMAIL PROTECTED]
http://www.imago.de
HRB 3008 Amtsgericht Kaiserslautern
USt-IdNr. DE 174941022
Geschäftsführer: Herr Dipl.-Ing. Christian Keller
--
Thorsten Rosenkranz
Imago Informationstechnologie GmbH
Sauerwiesen 6
67661 Kaiserslautern
Tel. 06301-708-0
Fax. 06301-708-222
mailto:[EMAIL PROTECTED]
http://www.imago.de
HRB 3008 Amtsgericht Kaiserslautern
USt-IdNr. DE 174941022
Geschäftsführer: Herr Dipl.-Ing. Christian Keller
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
