Softball question: How to calculate duration

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Softball question: How to calculate duration

Post by tford »

I'm sure this is easy. I have a log with with start and end times of a scheduled process and want to show the duration as well.

3 attributes:
Log_Sync_OIP.Sync_OIP_Duration
Log_Sync_OIP.Nbr_OIP_Sync_End
Log_Sync_OIP.Nbr_OIP_Sync_Start
Tom - V8.8 build 3137 - MySql / PostGres
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Softball question: How to calculate duration

Post by tford »

Duh ,,, I was using the wrong beginning & ending attributes. I was using a couple of beginning & ending integer record counters instead of my timestamp attributes.

Log_Sync_OIP.Sync_OIP_Duration=Log_Sync_OIP.Sync_OIP_Ended_ts-Log_Sync_OIP.Sync_OIP_Started_ts

Even though I have _ts suffixes on my timestamp attributes to make them stand out as such.
Tom - V8.8 build 3137 - MySql / PostGres
Post Reply