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]
