How do I change the date format using the echo command?

[Chelsea7]

I have one basic question about date format. As we know mysql uses yyyy-mm-dd format. I'm trying to get the correct format using the echo command so the date reads mm-dd-yyyy.

Everything else works fine. Here's my code for the DATE field. The print date command works fine but this is in a table.

----------
echo "<tr>";
echo "<td>".$row['date']."</td> ";


print date('M d Y', strtotime($row['date']));
echo "</tr>";
----------
Can print be used instead or should I stick with echo?

Thanks,
Chelsea

 

[jpadie]

print and echo can be used interchangeably.

mm-dd-yyyy is represented thus

echo date('m-d-Y', strtotime($row['date']));

more information here:

http://www.php.net/date

ensure that you have the default time zone set.

date_default_timezone_set('UTC'); //or whatever it is you need by way of timezone

more information here

 

[dkdude]

You can also ask MySQL to do the date_format for you.

Example query:

SELECT DATE_FORMAT([i]your_date_field_name[/i], '%m-%d-%Y') FROM [i]your_table_name[/i] WHERE [i]some condition or however you select...[/i];

Best,

Jakob