Re: Minutes to Interval day(2) to second(6)

From: Björn Wächter <bwc_at_p3-solutionsKILL_SPAM.de>
Date: Fri, 17 Nov 2006 11:41:00 +0100
Message-ID: <4s5htsFsmkpoU1@mid.dfncis.de>

Michel Cadot wrote:
> "RJ" <ridwan.jeena_at_gmail.com> a écrit dans le message de news: 1163576118.786769.117510_at_i42g2000cwa.googlegroups.com...
> | Hi All,
> |
> | How do I convert Minutes to Interval format?
> | I can get the values in the format HH:MM:SS, but how will I update a
> | column with these values that has a datatype if Interval day to second?
> |
> | Thanks in advance..
> |
>
> Test case?
> Oracle version?
>
> Regards
> Michel Cadot
>
>

SELECT numtodsinterval(22,'MINUTE') FROM DUAL

Björn Received on Fri Nov 17 2006 - 04:41:00 CST