SPL DATETIME bug ????
what does:
let l_dte1 = "2004-09-29 09:57:58.00"
let l_dte2 = "2004-12-29 09:57:58.00"
select count(*)
from table1, table2
where join
and datetime between
l_dte1 :: datetime year to fraction(2)
and
l_dte2 :: datetime year to fraction(2)
do?????
assuming that your datetime is really year to fraction(2)
Superboer.
ahum it does sound like a bug.. and do the explains look really the same???