php Output date

[computermax2328]

Hello Again,

 

I am building a blog and for every time I post in my database I have an auto time stamp that is attached to every entry. When I output the date and time just as a variable I get Y-m-d. Then I tried to use date_format() command. Now I am getting a blank. How can I rearrange my $date variable to the format I need?

 

This is what I used:

 $date = $row['Date'];
$date = date_format("m/d/Y", $date);

[requinix]

Use DATE_FORMAT(). Which you said you tried but apparently there was something wrong.

 

1. What did you try?

2. Are you storing the dates as actual DATETIME columns? Or some other type?

[Barand]

If it's a DATE or DATETIME field use

 

$date = date_format("m/d/Y", strtotime($date));