Converting a bare number to an interval and back

[angrybaldguy@gmail.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

[Frank van Bortel]

Re: Converting a bare number to an interval and back

angrybaldguy@gm ail.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
>

This ng is dead - please repost in c.d.o.database

--
Regards,
Frank van Bortel