in PhpMyAdmin (OVH Mutu), a table with column type timestamp. Impossible to put into this colum a timestamp : Always display datetime like 2017-01-09 23:02:01 !!! It generate several problmes : default current_timestamp give in this table "0000-00-00 00:00:00". Calculate delays is impossible. The only way : define a int(11) type column. An idea ?...
If you need to calculate with the timestamp field, you simply may use
SELECT UNIX_TIMESTAMP(yourtimestampfield);. I decided to use this instead of the
int(11) because of the built in function
on update CURRENT_TIMESTAMP which shows this format
Also inside of mysql queries yo may use it the reverse way like
UPDATE user SET logouttime = FROM_UNIXTIME(UNIX_TIMESTAMP(logintime)+3600) WHERE user_id = 12345;
Hope this helps.