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 ?