How do I change the date format

How do I change the mysql date format from yyyy-mm-dd to mm-dd-yyyy on the results and details pages.

Also how do I add the day of the week for this date column
<?php echo($row_WADAhomework['due_date']); ?>

This the page I am working on.
homework_Results.php

Thank you

The best way to do this would be with a function... you can add an include to the top of all your pages such as corefuncs.php is what I like to use and then I include all my functions on what page.

Here's a couple of functions I wrote - you may need to modify the delimiters to get the display exactly as you want it.

The first one is what I use to convert standard date format (mm/dd/yyyy) into database format (yyyy-mm-dd):

// DATABASE DATE CONVERSION (ASSUMES DATE FORMAT IS MM/DD/YYYY)

function databaseDate($datetoconvert) {
$dateDataDate = explode('/', $datetoconvert);
$dateDataYear = $dateDataDate[2];
$dateDataMonth = $dateDataDate[0];
$dateDataDay = $dateDataDate[1];
$dataDateFinal = $dateDataYear.'-'.$dateDataMonth.'-'.$dateDataDay;
return $dataDateFinal;
}


This works by first setting the input of a date field to only accept mm/dd/yyyy through validation... then on the actual database update field, modify the data like this: databaseDate($_POST['datefield']

Remember that the function page include must occur before you call the function which is why I typically will call my functions in the first line of every page before anything else.

For the display, it works the same, but I use this function:

// DATE FUNCTION

function displayDate($datetochange) {
if ($datetochange != "0000-00-00") {
$date_var = strtotime($datetochange);
echo date('m/d/Y', $date_var);
} else {
echo '';
}

}

So, now just call the function and then use it like this:

<?php displayDate($row_WADAhomework['due_date']); ?>


In your case, you may want to modify that function's formatting from m/d/Y to read m-d-Y.

Best regards,

Brian

Thanks Brian.

Would I put both functions in the same file?

Also, do you have an answer to displaying the day of the week of the db date that was inserted?

Thanks,
Josh

Hi Brian,
Thanks for this function.
Can you explain how I would take a date entered in a search page as dd/mm/yyyy and convert it ready for a results page that requires a database format of yyyy-mm-dd

Ta

Hi Brian,
I got this to work! Thought I'd share this one.

To convert a date from dd/mm/yy ready for a search page results which expects yyyy-mm-dd.

I added this code in the results page immedialty prior to the "comparison list additions"

if ($_GET["S_newsdate"]!="" && $_GET["S_newsdate"]!="0") {
function databaseDate($datetoconvert) { //v2.0
$dateDataDate = explode('/', $datetoconvert);
$dateDataYear = $dateDataDate[2];
$dateDataMonth = $dateDataDate[1];
$dateDataDay = $dateDataDate[0];
$dataDateFinal = $dateDataYear.'-'.$dateDataMonth.'-'.$dateDataDay;
return $dataDateFinal;
}
$_GET["S_newsdate"] = databaseDate($_GET["S_newsdate"]);
}