mkime date formatting.

Sonic_Rage

Ok, I'm not getting this for some reason, I have used the mktime function to insert the date/numbers into MySQL.

But now I want to be able to take those numbers and display them as a readable date format like this 9/22/03 on the webpage.

When I try

date_format(date, '%m/%d/%Y') as new_date

in my SQL query, it doesn't work. What am I doing wrong? I guess I'm not understanding the way it formats and I did look at php.net and still didn't understand it.

Thanks.

drew010

Let me try to understand this a little more:
you have a date stored in mysql as a timestamp in the form of 1064287149? and you want to retrieve that and in php make it display date like m/d/y?

if that is the case make a mysql query like this:

$q = "SELECT datecolum FROM tablename WHERE condition";
$r = mysql_query($q);
$data = mysql_fetch_row($r);

$date = date("n/d/y", $data[0]);
echo $date;

hope that helps

Sonic_Rage

That helps thank you. I have a question since I don't understand this part:

$date = date("n/d/y", $data[0]);

the $data[0], is that an array? If so, does that always have to be there or is there another that can go in it's place?

drew010

it is an array, but it doesnt have to be. it only is because it is the date we fetched out of mysql using mysql_fetch_array.
if you wanted you could even put
$date = date("n/d/y", 1043152486);
and it would still work.
or
$timstamp = 1043152486;
$date = date("n/d/y", $timestamp);