Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Date-Week conversion

Re: Date-Week conversion

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Fri, 8 Sep 2000 15:28:10 +0200
Message-ID: <8papj1$t40$1@s1.read.news.oleane.net>

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...

> 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
> >
>
>
>
Received on Fri Sep 08 2000 - 08:28:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US