Advanced Search

Oracle TO_DSINTERVAL Function

/ Published in: SQL
Save to your folder(s)
A few examples of the TO_DSINTERVAL function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. --TO_DSINTERVAL
  2.  
  3. --Example 1
  4. SELECT TO_DSINTERVAL('120 6:31:14') AS output
  5. FROM dual;
  6.  
  7. --Example 2
  8. SELECT TO_DSINTERVAL('3 14:09:32') AS output
  9. FROM dual;
  10.  
  11. --Example 3
  12. SELECT TO_DSINTERVAL('0 2:06:00') AS output
  13. FROM dual;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.