[SOLVED] Reading dates from MySQL format problem..

[A JM]

When reading the date from MySQL and displaying them in the field on my form the format is yyyy-mm-dd.

 

How can I change that to display mm/dd/yyyy?

 

I currently display the records date field like so:

 

value="<?php echo htmlentities($row_rstdetail['filed_date'], ENT_COMPAT, 'utf-8'); ?>"

 

Thanks.

 

A JM,

[smerny]

do it when you are pulling it from the database

 

so instead of just

 

GET date

 

use

 

GET DATE_FORMAT(date,'%m/%d/%Y') AS date

[A JM]

Since I'm using a SELECT * that would mean I would have to resort to pulling each field in the SQL statement...hmmm..

 

Could I write a custom function? I'm not positive about how a PHP is processed so I'm sure if that would work or not..?

 

Thanks for the suggestion.

[A JM]

Maybe something like this?

 

<?PHP

function ($theValue){

list($date, $month, $year) = explode("-", $theValue);

if (checkdate($month, $date, $year)) {

$pol_expdate =  $month . '/' . $date . '/' .  $year;

$theValue = $pol_expdate;

return $theValue;

}else{

return $theValue;

 

}

?>

[A JM]

Ultimately I fixed it with the following function.. let me know if anyone sees a problem with it.

 

<?php

function ConvertDate($theValue)

{

if ($theValue != NULL) {

list($year, $month, $date) = explode("-", $theValue);

$theValue =  $month . '/' . $date . '/' .  $year;

return $theValue;

}else{

return NULL;

}

}

?>

[5kyy8lu3]

that works.  you can also use php's date() function too if you prefer, it's probably faster and less code.

 

date("Y/m/d", $DateFromTable); //kinda like this