INSERT/UPDATE form - how to combine 5 form field to submit to one database field? Datetime

Originally Said By: Nathon Jones Web Design

  The sample code you've provided, to reformat the date when it is submitted...does that go above the Insert code or is that held within the body section?  

Originally Said By: Jason Byrnes

  it goes before the insert  

Have inserted the following before the Insert, but it's not inserting in the correct format and seems to be defaulting to 1970-01-01 00:00:00

<?php
if(isset($_POST['ADDEVENTPICKER'])) {
$_POST['ADDEVENTPICKER'] = date("Y-m-d", strtotime($_POST['ADDEVENTPICKER']));
}
?>

<?php
if (isset($_POST["formADDEVENTBTN"]) || isset($_POST["formADDEVENTBTN_x"])) {
$InsertQuery = new WA_MySQLi_Query($SMTmysqli);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "SMTevents";
$InsertQuery->bindColumn("SMTeventtitle", "s", "".((isset($_POST["SMTeventtitle"]))?$_POST["SMTeventtitle"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTeventdesc", "s", "".((isset($_POST["SMTeventdesc"]))?$_POST["SMTeventdesc"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTeventdate", "t", "".((isset($_POST["ADDEVENTPICKER"]))?$_POST["ADDEVENTPICKER"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTeventtime", "s", "".((isset($_POST["SMTeventtime"]))?$_POST["SMTeventtime"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTvenueID", "i", "".((isset($_POST["SMTeventvenue"]))?$_POST["SMTeventvenue"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTeventimg", "s", "".$WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"] ."", "WA_DEFAULT");
$InsertQuery->saveInSession("NEWEVENTID");
$InsertQuery->execute();
$InsertGoTo = "add-event-confirm.php";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>

Here's the Datepicker code:
<link type="text/css" href="../webassist/datepicker/add-event_datepicker_1/jquery-ui.css" rel="stylesheet" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>
<script type="text/javascript">
$(function(){
$('#datepicker_1').datepicker({
showButtonPanel:true,
dateFormat:"dd/mm/yy"
});
});
function closeDatePicker_datepicker_1() {
var tElm = $('#datepicker_1');
if (typeof datepicker_1_Spry != null && typeof datepicker_1_Spry != "undefined" && ADDEVENTPICKER_Spry.validate) {
datepicker_1_Spry.validate();
}
var docElm = document.getElementById("datepicker_1");
var tBlur = docElm.getAttribute("onBlur");
if (!tBlur) tBlur = docElm.getAttribute("onblur");
if (!tBlur) tBlur = docElm.getAttribute("ONBLUR");
if (tBlur) {
tBlur = String(tBlur).replace(/\bthis\b/g, "docElm");
eval(tBlur);
}
}
</script>

And the Datepicker form field...

<div class="form-group">
<label for="ADDEVENTPICKER" class="col-sm-2 control-label">Date:</label>
<div class="col-sm-10">
<input id="datepicker_1" name="ADDEVENTPICKER" type="text" placeholder="Click here to select a date" />
</div><!-- col-sm-10 -->
</div><!-- end form-group -->

I've attached the page also, for inspection. Thank you.