soniccool
soniccool

Reputation: 6058

Formatting date to human readable format

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?

Upvotes: 33

Views: 67876

Answers (7)

Juan Cortés
Juan Cortés

Reputation: 21082

$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

Upvotes: 63

Dinesh Naik
Dinesh Naik

Reputation: 17

Use the diffForHumans function:

Carbon\Carbon::parse($ts)->diffForHumans()

Upvotes: -1

Hanky Panky
Hanky Panky

Reputation: 46900

Use strtotime() to convert that string into a Unix Timestamp, then use the date() function to display it like you want.

echo date("F j, Y, g:i a",strtotime($ts)); 

Reference:

http://www.php.net/manual/en/function.strtotime.php

http://www.php.net/manual/en/function.date.php

Upvotes: 26

BlitZ
BlitZ

Reputation: 12168

I do not think that php is even needed there. Check MySQL DATE_FORMAT() function.

Example:

SELECT DATE_FORMAT('2013-09-30 01:16:06', '%M %D, %Y %H:%i:%s') as `readable`;

Result:

September 30th, 2013 01:16:06

For real usage:

SELECT
    DATE_FORMAT(`date_column`, '%M %D, %Y %H:%i:%s') as `readable`
FROM
    `your_table`;

Upvotes: 4

Anup Singh
Anup Singh

Reputation: 1563

Mysql query

 select UNIX_TIMESTAMP(datetime_field) as datetime_field from table;

PHP

echo date("F d Y", $datetime_field )

Upvotes: 1

echo date("F d Y",strtotime("2013-09-30 01:16:06"))

Upvotes: 3

Shudmeyer
Shudmeyer

Reputation: 352

Something like:

<?php
$date = '2013-09-30 01:16:06';
$convertDate = date('F jS, Y h:i:s', strtotime($date));
echo $convertDate;
?>

Upvotes: 1

Related Questions