> >>CURRENT_DATE
> >>
> >>insert into aTable (aDate)
> >>values (CURRENT_DATE)
> >
> > This works fine.
> >
> >>and
> >>SELECT CURRENT_DATE FROM RDB$DATABASE
> >
> >
> > But, this doesn't. "Field name missing" error arise.
>
> At my place, "select Current_date from rdb$database" works fine. I just
> tested in IB_SQL.
> I tested with Fb/1.5, dialect=3.

Same here ... (using Database Workbench). Must be a client error.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com