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

Home -> Community -> Usenet -> comp.databases.oracle -> Converting a bare number to an interval and back

Converting a bare number to an interval and back

From: <angrybaldguy_at_gmail.com>
Date: 11 Mar 2005 16:54:44 -0800
Message-ID: <1110588884.928174.121360@l41g2000cwc.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 Fri Mar 11 2005 - 18:54:44 CST












Original text of this message













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