Oracle – Interval Datatype – Extracting Components (Years/Months/Days/Hours/Minutues/Seconds)- Usage Example Reference

If you have not checked my quick intro to the Interval datatype here, please do so before reading on. Now, that we know the “interval” data type, let us see how we can extract out the individual components within it for both the “DAY TO SECOND” and “YEAR TO MONTH” variations. The following example should … Continue reading Oracle – Interval Datatype – Extracting Components (Years/Months/Days/Hours/Minutues/Seconds)- Usage Example Reference

Advertisements

Oracle’s INTERVAL Datatype Basics & Usage Examples

Oracle “Interval” data type is a new data type that was introduced in version 9i. In simple, terms, prior to 9i, if one needed to find the “duration” between a start time and end time, the query syntax was not too awkward but results were not human friendly. Without INTERVAL's help In the example below, … Continue reading Oracle’s INTERVAL Datatype Basics & Usage Examples