mysqlhtmlperldatetimeinterchange

TIMEDIFF in MYSQL

TIMEDIFF in MYSQL
I am using Interchange IC (http://interchange.rtfm.info/icdocs/index.html)

[query list=1 sql="SELECT TIMEDIFF(NOW(),'[sql-param time]') as diff"]
my $vardifftime = [sql-param diff];

$vardifftime It is giving output blank.
I want no of hours between current time and datetime type column in mysql database. [sql-param time] stores datetime.

Solution 
  • SELECT ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP('[sql-param time]'))/3600);