MS SQL Server Concepts and Programming Question: Download Questions PDF
PHP ODBC - How To Display a Past Time in Days, Hours and Minutes?
![MS SQL Server Interview Answer MS SQL Server Interview Question](https://globalguideline.com/public/images/interview/13.png)
Answers:
Answer #1You 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 = odbc_connect('ggl_SQL_SERVER','sa','GlobalGuideLine');
$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 = odbc_exec($con, $sql);
if (!$res) {
print("SQL statement failed with error: ");
print(odbc_error($con).": ".odbc_errormsg($con)." ");
} else {
odbc_fetch_row($res);
$message
<?php
$con = odbc_connect('ggl_SQL_SERVER','sa','GlobalGuideLine');
$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 = odbc_exec($con, $sql);
if (!$res) {
print("SQL statement failed with error: ");
print(odbc_error($con).": ".odbc_errormsg($con)." ");
} else {
odbc_fetch_row($res);
$message
Answer #2If today is you run this script, you will get something like this:
SELECT 'Posted ' + CONVERT(VARCHAR(40),
DATEDIFF(minute, '2007-05-29 04:09:49',
GETDATE())/(24*60))
+ ' days, ' + CONVERT(VARCHAR(40),
DATEDIFF(minute, '2007-05-29 04:09:49',
GETDATE())%(24*60)/60)
+ ' hours, and ' + CONVERT(VARCHAR(40),
DATEDIFF(minute, '2007-05-29 04:09:49',
GETDATE())%60)
+ ' minutes ago.'
Posted 26 days, 16 hours, and 15 minutes ago.
SELECT 'Posted ' + CONVERT(VARCHAR(40),
DATEDIFF(minute, '2007-05-29 04:09:49',
GETDATE())/(24*60))
+ ' days, ' + CONVERT(VARCHAR(40),
DATEDIFF(minute, '2007-05-29 04:09:49',
GETDATE())%(24*60)/60)
+ ' hours, and ' + CONVERT(VARCHAR(40),
DATEDIFF(minute, '2007-05-29 04:09:49',
GETDATE())%60)
+ ' minutes ago.'
Posted 26 days, 16 hours, and 15 minutes ago.
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
PHP ODBC - How To Include Date and Time Values in SQL Statements? | PHP ODBC - How To Perform Key Word Search in Tables? |