On Wed, Sep 12, 2012 at 8:56 PM, fidel_filio fidel_fi...@yahoo.com wrote:
...
add hor_uactu varchar(2) default extract(hour from cast('now' as date))
not null
I get this error:
Invalid token.
SQL error code = -104.
Token unknown - line 3, char 34.
extract.
At 01:17 AM 14/09/2012, Ann Harrison wrote:
you're using an ancient version of
Firebird which doesn't support the function EXTRACT at all.
Actually, Ann, we got EXTRACT() with IB 6.0, albeit with support for fewer
time-parts than it has today.
Cheers,
Helen
At 12:56 PM 13/09/2012, you wrote:
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