If we bind parameter (to Aurora database via MariaDB ODBC driver) of C type SQL_C_TIMESTAMP to a DATETIME column in the table, we are seeing data loaded is '1970-01-01 00:00:00' for value '0000-00-00 00:00:00' in the SQL_TIMESTAMP_STRUCT.
Same if we try to insert in a TIMESTAMP column (instead of DATETIME) of the table, then value is stored properly as '0000-00-00 00:00:00'.
Also, instead of SQL_C_TIMESTAMP, if we bind as SQL_C_CHAR with same value to DATETIME column, then as well value is correctly stored as '0000-00-00 00:00:00'.