How to set TIMESTAMP and DATETIME in workbench
Using work bench I have 2 data fields/columns that are dates
One is the date and time the record was first inserted into the table and will remain the same until the record is deleted lets call it DATE_CREATED
The second is the date and time the record was updated lets call it DATE_CREATED
Data Type for both is TIMESTAMP or should I make it DATETIME
In the workbench how should I set the default value to keep DATE_CREATED static and keep DATE_UPDATED dynamic so it changes each time the record is updated
Subject
Views
Written By
Posted
How to set TIMESTAMP and DATETIME in workbench
6533
September 01, 2017 10:17AM
30753
September 05, 2017 03:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.