They still work as far as I know ... but I don't know of any specific
SQL92 functions for those.

Yesterday, btw would be CURRENT_DATE - 1

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."

> what about the 'today', 'yesterday', 'tomorrow' literals - are they out

too?

>
>
> 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.
>