Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Converting INTERVALs to and from bare numbers

Converting INTERVALs to and from bare numbers

From: <angrybaldguy_at_gmail.com>
Date: 13 Mar 2005 17:35:36 -0800
Message-ID: <1110764136.070606.115000@z14g2000cwz.googlegroups.com> 





Salve.



I have an application in which I would like to convert a number of
seconds into an INTERVAL DAY TO SECOND value and, later, back to a
number of seconds.  For reasons relating to inter-database portability,
I'd like to do this in a stored function, not in the database client
application.



Some time spent on google hasn't shown any good ways to approach this.
Any suggestions?



Owen
Received on Sun Mar 13 2005 - 19:35:36 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US