Can I set UNIX_TIMESTAMP() as default?

[Nicolas Verhaeghe]

I would like an integer field to capture the current date as a Unix
Timestamp by default.

But this will not be accepted at all.

I get the error "invalid default value for [field name]"

Is there a workaround?

Thanks!