Newbie needing help...

[JukesK]

I have looked every where for an answer but cannot find one..

if i have a MySQL database (MySQL client version: 5.1.30) with a table with 2 timestamps (opened, closed) how can i populate a third column with the live duration of the ticket??

probaly a simple question but i'm new to coding .. :o

Thanks in advance

KeeF

[djjjozsi]

you can use datediff in your SQL query, like:

SELECT `id` , `opened` , `closed` , datediff( `opened` , `closed` )  AS days
FROM `tickets`

It gives you in seconds:

SELECT `opened`, `closed`, (`closed`-`opened`) AS seconds FROM `tickets` WHERE `closed`!='0000-00-00 00:00:00'

You can read about date and time function in the mysql manual:
Here