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

1

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',

2

hi

this is a microsoft TSQL forum

please google search .. lot of articles come ..

image
image1235×761 64.1 KB

1 Like
3

What are you trying to capture in that colimn?

A datetime? Or just time?