Change 22nd Jan 2008 16:15:27 to Today 16:15.27

[JamesGMills]

Hello!

Now most of you will have seen when you are using a site that shows you dates of when things have happened if its happened today or yesterday then it will not show you the date it will actually say Today 15:35, or Yesterday 16:10...

Is this possible using SQL or is there something you can do on the date returned?

I am using datetime in mysql to store the date of something being added.

This is my SQL

SELECT *,date_format(DateAdded, '%D %b %Y %T') as DateAddedFormatted FROM $this->tablename

This will bring back something like: 22nd Jan 2008 16:15:27

Anyone got any advice/help on this one...

Thanks



------------------------

http://www.jamesmills.co.uk

 

[JamesGMills]

Got it sorted in the end, thanks.

$yesterday = mktime(0,0,0,date("m"),date("d")-1,date("Y"));
$today = mktime(0,0,0,date("m"),date("d"),date("Y"));
$myDate = strtotime("2008-01-22 00:42:03");

if($myDate > $today)
{
$msg = 'Today ' . date("h:ia", $myDate);
}
else if($myDate > $yesterday && $myDate < $today)
{
$msg ='Yesterday ' . date("h:ia", $myDate);
}
else
{
$msg = date("d/m/Y h:i:s", $myDate);
}

echo $msg;

------------------------

http://www.jamesmills.co.uk