Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Date-Week conversion
It should be fine to give us your solution!
-- Cheers Michel Joerg Sobottka <j.sobottka_at_delta-energy.ch> a écrit dans le message : 8pagjs$q1f$1_at_read01.news.ch.uu.net...Received on Fri Sep 08 2000 - 08:28:10 CDT
> Hi James,
>
> this is not, what I had needed, but I have now a working version.
> Input: Weekno. and year
> Output: Monday of this week as date.
>
> Regards
> Jörg
>
> James Lorenzen <jlorenzen_at_my-deja.com> schrieb in im Newsbeitrag:
> 8p68dp$bv9$1_at_nnrp1.deja.com...
> > Joerg; user the ISO year and week date formats. I.E.
> > "TO_CHAR(sysdate,'iyyyy-iw')"
> > This is the ISO standard for week and year.
> >
> > HTH
> > James
> >
>
>
>