2 (of many) solutions here:
Create the column as a datetime instead and set it with NOW() when you first
insert the data.
In your update query, set the hr_con column to the current value.
(If you set the value explicitly it will not be updated with the automatic
timestamp value.)
read this for
Hi Leandro,
It is absolutly correct. Please read in doc about timestamp data type
http://www.mysql.com/doc/en/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you
