Hello I'm having a problems with a couple of columns, when I try to set a default value here is my code...


alter table cboo_pedido
add fec_uactu date default 'today' not null,
add hor_uactu varchar(2) default extract(hour from cast('now' as date)) not null

The first column (fec_uactu) goes OK, but on the second column I get this error:
Invalid token.
SQL error code = -104.
Token unknown - line 3, char 34.
extract.

How can I add the second column with the required default?


Note:
I am using Firebird 1.5.6

Regards,

-Fidel