Hello,
I'd like to understand which is the unit of measure of the fields that describes timing for tickets on database.
For example on the ticket table there are escalation_start_time, escalation_solution_time,...
My target is querying my database to publish on a report which are the timings to resolve requests group by client, category,...
Thanks in advance,bye
Unit of measure of time fields on DB[SOLVED]
Moderator: crythias
Unit of measure of time fields on DB[SOLVED]
Last edited by dxor on 16 Feb 2011, 16:30, edited 1 time in total.
OTRS 2.2 on Linux with MySQL database
Re: Unit of measure of time fields on DB
As per my knowledge that's in minutes. That's why there is a conversion in brackets, 1440 minutes = 24 hour.
OTRS 3.1.10
Re: Unit of measure of time fields on DB
Thank you for your answer, but there's something that I don't understand.kool_kid wrote:As per my knowledge that's in minutes.
For example I've a ticket that has:
- create_time:2011-01-28 09:50:05, creation_,Escalation_start_time=1296206104, escalation_solution_time=1296204873.
- From the history of the ticket I see that the ticket has been closed in 12 minutes and 44 seconds.
With the unit of measure in minutes,a s you said, the solution time is not right.
Sorry but I can't see the conversion hint.That's why there is a conversion in brackets, 1440 minutes = 24 hour.
OTRS 2.2 on Linux with MySQL database
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Unit of measure of time fields on DB
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Unit of measure of time fields on DB
Unix time, thanks a lot!!!
OTRS 2.2 on Linux with MySQL database