Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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.

This post has been answered by thatJeffSmith-Oracle on Mar 19 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2018
Added on Mar 19 2018
9 comments
281 views