Formatting date to human readable format

php mysql unix-timestamp date-formatting
soniccool picture soniccool · Oct 3, 2013 · Viewed 45.6k times · Source

Lets say in my mysql database I have a timestamp 2013-09-30 01:16:06 and lets say this variable is $ts.

How can I output this to show more like September 30th, 2013?

Answer

Juan Cortés picture Juan Cortés · Oct 3, 2013 
$timestamp = "2013-09-30 01:16:06";
echo date("F jS, Y", strtotime($timestamp)); //September 30th, 2013

Note the use of S to get the english ordinal suffix for the day.
Since you're already using strtotime if you need a human readable data for the current time you can just use the keyword "now" as in strtotime("now")

Related sources

Related questions

PHP-MYSQL: Converting Unix Timestamp to DateTime and vice versa

im using php 5.4.6 and MySQL 5.5.29 and I get trouble by converting a UNIX TIMESTAMP to MYSQL DATETIME and vice versa. Mysql and php wun on the same local machine. I have a simple mysql table CREATE TABLE Entry( id SERIAL …

Read More
MySQL: What's the best to use, Unix TimeStamp Or DATETIME

Probably many coders want to ask this question. it is What's the adventages of each one of those MySQL time formats. and which one you will prefer to use it in your apps. For me i use Unix timestamp because …

Read More
PHP strtotime() function wrong by 1 hour?

I am converting dates and times into timestamps using PHP before they are inserted into my MySQL database. My problem is that when i use PHP's strtotime function the output timestamp is -1 hour behind my actual time. For example, …

Read More