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 -> date format WW(week number) question

date format WW(week number) question

From: guerillot gil <gilgue_at_freesurf.fr>
Date: Sat, 25 Sep 1999 09:08:18 GMT
Message-ID: <6i0H3.28876$Ze2.915976@nnrp3.clara.net>


i know only the week number A and the year B.

what kind of sql select query to write for obtain X the first day and Y the last day of the week
with only the two parameters A and B?

for example A=40 and B=1999.

X=4/10/1999
Y=10/10/1999 (in french format)

thanks for help !!! Received on Sat Sep 25 1999 - 04:08:18 CDT

Original text of this message

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