I am converting from another database, where the line below was defined as a 'datetime'
datatype. Am trying to convert that data, and it is telling me that my default date is out of
range, and that I perhaps need to do a datestyle setting.
After looking at the docs, and even CAST, I still have not been able to figure out how to
set this up, other than just defining it as aa char(19) field.. Does anyone have any suggestions?
CREATE TABLE adns_neighbor_history (
ifID mediumint(8) unsigned NOT NULL default '0',
updatedTime timestamp NOT NULL default '0000-00-00 00:00:00', <------ rejected
remoteNet char(15) default NULL,
PRIMARY KEY (ifID,updatedTime)