diff between UTC time and stored timestamp

Hi there,

I have searched around and have absolutly no clue on how to use the DateDiff function in this situation. I have a query which returns four fields,


SELECT matches.matchid,
clan.cname,
gametype.gtname,
matches.starttime
FROM matches,
clan,
gametype
WHERE matches.t2id = #session.clan_id#
AND matches.t1id = clan.cid
AND matches.mgametype = gametype.gtid

I would like a fifth column which returns the difference between the matches.startime value and the current UTC timestamp, (select utc_timestamp), I have tried using the DateDiff function but have really no clue how to do this.

All help is appreciated.

Try timediff() instead.