How to debug: error when inputting timestamp data (from api) into a timestamp DB field (MySql8)

Hey all,

Can anyone please guide me how I can debug why I am getting errors when trying to input timestamp data from an API into a timestamp data field in my DB? Getting the following error:

ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '1524773620' for column 'billing_period_ends_at

I’ve tried:

• changing the DB field to datetime, time, date - no luck
• tried changing the $_POST value to date, time, text
• tried using a setValue to change the value to various outputs such as timestamp, datetime etc.

Whatever I do, I get the same error above - I’m sure it’s me! So if anyone can help guide debugging this I’d be grateful!