| Function | Description |
| NUMTODSINTERVAL(x, interval_unit) | Converts the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit, which you may set to DAY, HOUR, MINUTE, or SECOND. |
| NUMTOYMINTERVAL(x, interval_unit) | Converts the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit, which you may set to YEAR or MONTH. |
| TO_DSINTERVAL(x) | Converts the string x to an INTERVAL DAY TO SECOND. |
| TO_YMINTERVAL(x) | Converts the string x to an INTERVAL YEAR TO MONTH. |
Oracle PL/SQL DateTimestamp Functions :Time Interval Related Functions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Please Provide your feedback here