Cannot set a mysql-function as default value for column with date type

[hakie]

In MSSQL it is possible to, when creating a database tables from file, to set a default value for a column through a function call. F.E.:

create table tbl.....(
..
CDATE DATE NOT NULL DEFAULT GETDATE(),
..
)

Why is this not possible within MYSQL?
I used:
CREATE TABLE tbl.. (
..
CDATE DATE NOT NULL DEFAULT NOW(),
..
) TYPE=MyISAM;

 

[KarveR]

try curdate() instead of now() ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[hakie]

curdate() doesn't work either. It seems none of the functions can be called.

 

[sleipnir214]

MySQL's online manual says (

http://www.mysql.com/doc/en/CREATE_TABLE.html

about halfway down the page) that the default of a column cannot be a function or expression ______________________________________________________________________
TANSTAAFL!

 

[hakie]

Exactly!, that's what i thought.
It's a shame it isn't possible.

Thanks anyway!