Displaying Dates

[bravo14 0]

Hi All

 

I have some dates in a mysql database and it is the format of yyyy-mm-dd and I wanto to display it in a differnet format on the web pages.

 

Any assistance would be much appreciated.

 

Mark

[kmark 0]

date("D F j, Y", strtotime($theDate));

 

would output: Friday Jun 13, 2008 if $thedate = 2008-06-13

[jesushax 0]

heres a function i created

 

<?php
function mydate($record){
$date =  strtotime($record);
echo date('d/m/y',$date);
}
?>

 

change the date('d/m/y') to suit the way you want it

[kmark 0]

all date formatting option are at http://ca3.php.net/date

[craygo 2]

If you want to bypass all the php, why not let mysql do it

 

$sql = "SELECT DATE_FORMAT(`datefield`, '%m/%d/%Y') AS formatted_date";

 

Ray

[PFMaBiSmAd 131]

The mysql DATE_FORMAT() function, as craygo has shown, will result in the fastest execution. The php strtotime() and data() functions are two of the slowest php functions.

[bravo14 0]

Thanks for your help guys.

 

Craygo just out of curiosity as I am relatively new to PHP/MySQL where in the code below would I put the code you suggested?

$result = mysql_query('SELECT * FROM `reports` ORDER by report_id LIMIT 0, 30 ', $con);
while($row = mysql_fetch_array($result))

{
echo ('<tr class="profiletext"><td>'.$row[date].'</td>');

[craygo 2]

what are the names of the fields in the table??