TIMEDIFF in MYSQL

Question

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.

score 1 · Answer 1 · answered Dec 19 '11 at 12:56

1

Is [sql-param time] is of datetime cause timediff expects both expression to be of same type. If [sql-param time] is time only then probably you can do like

SELECT TIMEDIFF(TIME(NOW()),'[sql-param time]') as diff

answered Dec 19 '11 at 12:56

Rahul

76,197
13
71
125

Thanks but I am still getting null output on my html page its working fine on mysql – rachel Dec 21 '11 at 06:30

score 1 · Accepted Answer · answered Dec 19 '11 at 12:59

1

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

answered Dec 19 '11 at 12:59

Eugen Rieck

64,175
10
70
92

Thanks but I am working on windows I don know why you have used UNIX_TIMESTAMP – rachel Dec 20 '11 at 06:19
Sry. I wasnt aware of this functionality its working fine on mysql but on html page its not – rachel Dec 20 '11 at 07:33

TIMEDIFF in MYSQL

2 Answers2