How to save timestamp from php to MySQL?

Question

MySQL

I'm trying to send data to the database as a timestamp from PHP, but it always gives me an error:

Incorrect datetime value: '1526763600' for column 'expiration_date' at row 1

I tried setting the field type and datatime and timestamp in MySQL - it still doesn't help. How all the same it is correct to store in a DB time and date in the timestamp format? Or just set the field type to INT and don't worry?

Answer 1

Use the FROM_UNIXTIME function to convert input parameters to the timestamp data type:
Checking the result:

SELECT UNIX_TIMESTAMP(expiration_date) FROM you_table