>Dear List
>Please help me understand where I am going wrong with creating the following procedure:
>
>...
>CREATE PROCEDURE TestProc
>...
> select cast('Now' as time) as "TIME" from rdb$database;
>...
>Token unknown - line 7, column 57
>;

What should Firebird do with "TIME"? You simply need an INTO clause and a local variable or return parameter before the semicolon.

HTH,
Set