Bisma Jayadi wrote:

> Thanks Helen... but the problem still persist...
>
>
>>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.


--
Aage J.