I figured out how to bring the unix_timestamp format in to the php format as code below. This was complicated because one of the passActivationDate column which also uses the timestamp datatype did not seem to need conversion from the Unix format. Does anyone know why this may have occured?
Is is related to the method that the data is entered? Through an update or directly on the table through my GUI using Navicat.
I am working on the math calc's. To update the table schema I am assuming that I need to convert the values? Then run the DataAssist update with those properly formated values. Is this the correct way to go from php timestamp to mysql timestamp?
<?PHP
// takes $formated_datetime and converts to "UNIX timestamp":
$newExpiryDate_MySQL = strtotime("$newExpiryDate");
?>