Re: Converting INTERVALs to and from bare numbers

angrybaldguy_at_gmail.com wrote:
> 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

What is the issue?

For demos of some of the functionality you will need: http://www.psoug.org
click on Morgan's Library
click on Timestamp
or
click on Functions

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)