9
Duration Modeling and Calculations
Data and time values represent the finest processing precision and do not reflect any duration; just one point in time is referenced. Using the DATE data type, a granularity of up to one second can be used. Based on the definition, the granularity precision can be of the order of nanoseconds when dealing with TIMESTAMP. Oracle does not provide a specific data type for dealing with date elements with no time element. Therefore, the meaning of the DATE data type value depends on precision, and time elements do not need to be taken into account. Typically, an employment contract is in days rather than hours. Consequently, dealing with more precise granularity frames, such as hours, minutes, or even seconds, ...
Get Developing Robust Date and Time Oriented Applications in Oracle Cloud now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
