Re: How to set TIMESTAMP and DATETIME in workbench

[Miguel Tadeu]

Hi Pete,

In Workbench, set the DATE_CREATED column to DATETIME and the default value to CURRENT_TIMESTAMP.
As for the DATE_UPDATED, if you want it automatically updated, you hsould create a trigger for that table. To do so, go to the "Triggers" tab when editing the table. You should set one before/after update and update the DATE_UPDATED column with CURRENT_TIMESTAMP or using the now() function.