At 01:17 AM 14/09/2012, Ann Harrison wrote: > you're using an ancient version of >Firebird which doesn't support the function EXTRACT at all.
Actually, Ann, we got EXTRACT() with IB 6.0, albeit with support for fewer time-parts than it has today. Cheers, Helen