List:General Discussion« Previous MessageNext Message »
From:Nicolas Verhaeghe Date:May 10 2006 6:33pm
Subject:Can I set UNIX_TIMESTAMP() as default?
View as plain text  
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?


SQL:2003 standardPeng Yi-fan10 May
Re: SQL:2003 standardPeter Brawley10 May
  • Re: SQL:2003 standardRoland Volkmann10 May
    • Can I set UNIX_TIMESTAMP() as default?Nicolas Verhaeghe10 May
RE: Can I set UNIX_TIMESTAMP() as default?George Law10 May