Oracle TO_DSINTERVAL Function - SQL Snipplr Social Repository

Revision: 71365

at February 23, 2017 05:38 by bbrumm

Initial Code

--TO_DSINTERVAL

--Example 1
SELECT TO_DSINTERVAL('120 6:31:14') AS output
FROM dual;

--Example 2
SELECT TO_DSINTERVAL('3 14:09:32') AS output
FROM dual;

--Example 3
SELECT TO_DSINTERVAL('0 2:06:00') AS output
FROM dual;

Initial URL

http://www.databasestar.com/oracle-to_dsinterval/

Initial Description

A few examples of the TO_DSINTERVAL function.

Initial Title

Oracle TO_DSINTERVAL Function

Initial Tags

sql, Oracle

Initial Language

SQL

Choose a language for easy browsing: