Skip to Main Content

Best practice to save lasting time of .... ?

2877737Mar 19 2018 — edited Mar 19 2018

Hi,

I have to keep in my table time of lasting tasks in my system. Time of lasting a task it means time, from start to end the task.

I wondered which data type to apply ? Varchar2 ? - it's problematic to count avg time, max time etc. Data ? it's not an hour Timestamp ? it's not an hour ?

Which practice is the best ? Mayby there is any standard ?

Thx.

Paul.

Comments
Post Details
Added on Mar 19 2018
9 comments
140 views