How is the best way to calculate the time...

Franklin

How is the best way to calculate the time it takes to place an order, since it was created until it is registered?

I have created two fields of type TIME. One is informed OnInsert trigger and the other when you register it and then, subtract from each other but the result I get weird numbers ...

X example...

Since time = 11:29:37,197
To time = 11:31:18,23

Total = 101032

:-k

This result isn´t valid for me... I want the result in seconds for example...

jmagno

try applying the time conversion from millisecond to second... multiply the result in 0.001

Franklin

Ohhhh the results is in milisenconds... ](*,)

I´ll ty... thx a lot!!

DenSter

There's also a 'duration' data type, see if that is what you need.

kine

Do you really think that just time is enough? What about before and after midnight? I will use datetime and duration for this...

Franklin

DenSter wrote:

There's also a 'duration' data type, see if that is what you need.

Mmmm i don´t know this function... let me see...

Kine the operations are around 3 or 4 minutes... not more... i think time is enough thx!!

EDIT: DenSter this datatype is perfect... it´s just i was triyng to find!!!

David_Singleton

Franklin wrote:

Kine the operations are around 3 or 4 minutes... not more... i think time is enough thx!!

A short cut is the longest path between two points. Your laziness may save time now, but it will come back and bite you in the future.

kine

Ok, 3 minutes, are you sure that it will not be 23:59 and 00:01?

Franklin

Finally i´m using a field dataype duration as DenSter said... it´s perfect!!

Thx Kine and David Singleton too!!

DenSter

Cool, now all you need to do is make sure that you listened to Kamil and David, and implement datetime data types instead of just Time.

Franklin

Sure!!

:thumbsup: