SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: '<campaign_id>'

While deleting a mailchimp campaign from url
site_url/admin/config/services/mailchimp/campaigns/campaign_id/delete, I'm getting the below error message

SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: 'campaign_id'

The campaign gets deleted on mailchimp end, but the drupal entity fails to delete. As a result, I'm getting an error in the campaign listing page site_url/admin/config/services/mailchimp/campaigns

404: Resource Not Found - The requested resource could not be found.

I didn't face this issue in my local installation, but it persists on my dev, stage and production environments