SQLTeam.com | Weblogs | Forums

Setting the table timezone to 0000-00-00 00:00:00

I am trying to set a timezone using the "timestamp" option of "0000-00-00" but the system says it will only accept 1001-00-00 and above.

Is there a way to get mysql to accept the 0000-00-00 timestamp please as per below:

CUST_Creation timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',


this is a microsoft TSQL forum

please google search .. lot of articles come ..

1 Like

What are you trying to capture in that colimn?

A datetime? Or just time?