Jump to content

Archived

This topic is now archived and is closed to further replies.

Mateobus

Really Simple Date Question

Recommended Posts

OK, i have a mySQL table with date elements in the format YYYY-MM-DD. How do I display these dates nicely in PHP Like:

Month Day, Year, or just Month, Day

I looked for a couple tutorials but didn't find much. I feel like there should be a really simple way to do this.

Share this post


Link to post
Share on other sites
if $row['datecol'] is the column from your table and contains today's date, then

[code]echo date ('M jS, Y', strtotime($row['datecol']));[/code]

--> Apr 24th, 2006

Share this post


Link to post
Share on other sites
You can also do it at your query level as well:

[code]$query= "Select DATE_FORMAT(date_date,'%M %D %Y') AS sortdate from your_table ORDER BY date_date ASC"; /* ORDER BY function orders ascending (ASC) or descending(DESC) */

echo $sortdate;
[/code]

Also, search the MySQL site for the different formats you can use for DATE_FORMAT()...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.