I have a MySql database. In a column, I set Structure Type timestamp. I need that column to know at what day and hour the user updated their information. But I realize the database store the time zone from where I am (Europe) that is UTC+2. That could cause problems with users in different time zones. It would be better to store a universal time, that is UTC.
Can MySql automatically register the timestamp UTC?
I can change the column type from timestamp to date. Each time that the user updates his information I can get the UTC and update that information manually.
$utc = gmdate("Y-m-d H:i:s");
So, I can update the UTC time every time I make an update. But I was expecting that MySql would provide a column type that could do that automatically. Is this possible?