Displaying dates

[dave1236]

Quick question -

I have my dates stored in my MySQL DB with an expiration associated with it. These are stored in Y-m-d format (Yahoo default (I beleive MySQL as well))

How do I convert these dates to display as a a "regular date"?

I have tried to name my variable in the way I want, but I simply destroy the integrity of the file by doing so.

Thanks!

[eelixduppy]

It depends on what you consider to be a "regular" date. Here is an example using MySQL:

$query = "SELECT DATE_FORMAT(date_col,'%m/%d/%Y') AS date_name";
// selects in the format: 

Look up more about the DATE_FORMAT function here: Date and Time Functions [dev.mysql.com]

Good luck :)

[eelixduppy]

I just realized how asleep I was for my last post:

$query = "SELECT DATE_FORMAT(date_col,'%m/%d/%Y') AS date_name FROM table_name"; 

..although I think you got the point before :)

Sorry about that!

[mrnoisy]

$getdate="SELECT date from table_name";
$getdate=mysql_query($getdate) or die(mysql_error());
$getdate=mysql_fetch_array($getdate);

echo date('F j, Y', strtotime($getdate));

PHP date reference [php.net]