You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the DATEDIFF() SQL function The following tutorial exercise shows you how to use DATEDIFF() to present a past time in days, hours, and minutes:

<?php

$con = mssql_connect('LOCALHOST','sa','GlobalGuideLine');

mssql_select_db('GlobalGuideLineDatabase', $con);

$submit_time = "2007-05-29 04:09:49";

$sql = "SELECT 'Posted '"

. " + CONVERT(VARCHAR(40),"

. " DATEDIFF(minute, '$submit_time',"

. " GETDATE())/(24*60))"

. " + ' days, '"

. " + CONVERT(VARCHAR(40),"

. " DATEDIFF(minute, '$submit_time',"

. " GETDATE())%(24*60)/60)"

. " + ' hours, and '"

. " + CONVERT(VARCHAR(40),"

. " DATEDIFF(minute, '$submit_time',"

. " GETDATE())%60)"

. " + ' minutes ago.'";

print(" $sql ");

$res = mssql_query($sql, $con);

if (!$res) {

print("SQL statement failed with error: ");

print(" ".mssql_get_last_message()." ");

} else