ITNinja

The "time open" column is the difference between the current timestamp and the TIME_OPENED field. The TIME_OPENED field represents the last time the ticket was first placed in an opened state. Usually that will be the same as the last time it was place in an opened state but if a ticket is moving from one opened state directly to another then it's not. It is stored in the database as a timestamp (YYYY-MM-DD HH:mm:ss).

It is not a calculation of the time a ticket has been opened.
To add TIME_OPENED it to a report you have something like this:


select -- columns here,
HD_TICKET.TIME_OPENED
-- , columns here
FROM HD_TICKET
/* joins, etc */
WHERE
1=1
/*and where filters */

to add an equivalent of "Time Open" you would have this. this is in seconds so you have to massage it with a function:


select -- columns here,
UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(HD_TICKET.TIME_OPENED) -- add some translation to it
-- , columns here
FROM HD_TICKET
/* joins, etc */
WHERE
1=1
/*and where filters */

If you truly want a timer then see this:
http://itninja.com/question/servers-installation-help03&mpage=1&key=&#