SQL92 has different levels of compliance - entry, intermediate and full
(I believe).

It might be that (without looking) CURRENT_stuff is intermediate level or
something...

The NOW keyword is not standard as far as I know.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> sorry... old habits... but you say SQL92... the now function was around

ages

> ago when IB was always claiming SQL92 compliance. Was NOW never compliant?
>
>
> NOW is the old way - the new and preferred way
> is to use the SQL92 CURRENT_TIME/DATE/TIMESTAMP
> functions.
>
> Martijn Tonies