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

Home -> Community -> Usenet -> c.d.o.misc -> Week numbers and days

Week numbers and days

From: Chris Kruiper <c.a.kruiper_at_home.nl>
Date: Fri, 07 Feb 2003 09:42:42 GMT
Message-ID: <mcL0a.1237507$xm4.48152766@Flipper> 





Hi,



I want to know the following:



I have a week number in a certain year (format YYYYWW) I want to know what
date is the wednesday in that week.



Example:


Year/week:    200306


Day wednesday



Date: 20020205



Anyone an idea how I can do this from sql?



Thank you,



Chris
Received on Fri Feb 07 2003 - 03:42:42 CST












Original text of this message













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