Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Displaying date as dd-mm-yyyy and inserting to MySQL DATETIME field?

Displaying date as dd-mm-yyyy and inserting to MySQL DATETIME field?

Thread began 5/27/2014 11:34 am by Nathon Jones Web Design | Last modified 12/28/2015 9:02 pm by Nathon Jones Web Design | 26794 views | 9 replies

5/29/2014 12:00 pmJason ByrnesWebAssist

where the form field LEDProductUpdateDate already uses the Y-m-d format that the database requires, you do not need to use any additional formatting funcitons

<?php echo date("Y-m-d H:i:s"); ?>

formatting functions would only be \needed if the form element used a different format.

the function would need to be defined before the update record code, the used in the update record code like this:

$WA_fieldValuesStr = "".((isset($_POST["LEDstock"]))?$_POST["LEDstock"]:"") ."" . $WA_AB_Split . "".((isset($_POST["LEDProductUpdateDate"]))?formatUKDateMySQL($_POST["LEDProductUpdateDate"]):"") ."";

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.