Error on Redshift Delete

Hello,

Can anybody help me with the following error? I think is the conversion of the snapshot_date field.
The snapshot_date field is of data type date with no time.