Unit of measure of time fields on DB[SOLVED]

Moderator: crythias

Locked
dxor
Znuny newbie
Posts: 7
Joined: 20 Jan 2011, 12:47
Znuny Version: 2.2
Location: Bologna,Italy

Unit of measure of time fields on DB[SOLVED]

Post by dxor »

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
Last edited by dxor on 16 Feb 2011, 16:30, edited 1 time in total.
OTRS 2.2 on Linux with MySQL database
kool_kid
Znuny newbie
Posts: 86
Joined: 13 Feb 2011, 13:51
Znuny Version: 3

Re: Unit of measure of time fields on DB

Post by kool_kid »

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
dxor
Znuny newbie
Posts: 7
Joined: 20 Jan 2011, 12:47
Znuny Version: 2.2
Location: Bologna,Italy

Re: Unit of measure of time fields on DB

Post by dxor »

kool_kid wrote:As per my knowledge that's in minutes.
Thank you for your answer, but there's something that I don't understand.
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.
That's why there is a conversion in brackets, 1440 minutes = 24 hour.
Sorry but I can't see the conversion hint.
OTRS 2.2 on Linux with MySQL database
crythias
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

Post by crythias »

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
dxor
Znuny newbie
Posts: 7
Joined: 20 Jan 2011, 12:47
Znuny Version: 2.2
Location: Bologna,Italy

Re: Unit of measure of time fields on DB

Post by dxor »

Unix time, thanks a lot!!!
OTRS 2.2 on Linux with MySQL database
Locked