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: Joerg Sobottka <j.sobottka_at_delta-energy.ch>
Date: Fri, 8 Sep 2000 12:54:57 +0200
Message-ID: <8pagjs$q1f$1@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 - 05:54:57 CDT












Original text of this message













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