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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 17 Nov 2006 18:50:48 +0100
Message-ID: <455df678$0$30418$426a34cc@news.free.fr>

"Björn Wächter" <bwc_at_p3-solutionsKILL_SPAM.de> a écrit dans le message de news: 4s5htsFsmkpoU1_at_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

If he does not answer our questions, he does not worth an answer.

Regards
Michel Cadot Received on Fri Nov 17 2006 - 11:50:48 CST