Hi Magnus,

It isn't a field - it's a function.

There are more:

NOW
CURRENT_USER
CURRENT_TIMESTAMP
CURRENT_DATE
CURRENT_TIME

But to simply get these values, you need the SQL construct:
select ... from ...

And RDB$DATABASE is a single row column and therefor returns
the value of the function only once.

You can also write statements as:
insert into mytable (datecolumn) values (current_date)

-- see, it's a function :)

Hope this helps,

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

>
> > select USER from rdb$database
>
> Thanks!
>
> Why is USER not shown when I do a "show table rdb$database;"?
> Are there other "hidden" fields in there?