...

View Full Version : diff between UTC time and stored timestamp



nzkronic
05-15-2008, 09:20 AM
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.

Fumigator
05-15-2008, 10:42 AM
Try timediff() instead.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum