Ralf,

> thanx for the amazing fast answer .-) works very well and fast ...
>
> When I don´t have to use hour why is it an reserved word?

HOUR can be used as this:

select extract(hour from current_time) from rdb$database

The EXTRACT functions let's you extract a value from a
date/time/datetime value.

You can also use MONTH, YEAR, DAY, MINUTE, SECOND


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