Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Minutes to Interval day(2) to second(6)
"Michel Cadot" <micadot{at}altern{dot}org> schreef in bericht
news:455df678$0$30418$426a34cc_at_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
>
>
And he should use MI in stead of MM (there's an other one!!!!!!)
Shakespeare
(What's in a minute?)
Received on Mon Nov 20 2006 - 08:20:38 CST