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

Home -> Community -> Usenet -> c.d.o.server -> DATE Format: iw vs. ww for returning week

DATE Format: iw vs. ww for returning week

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 02 Oct 2000 23:02:03 GMT
Message-ID: <37f68e9b.25271388@news.earthlink.net> 






OK,


I've been trying to find docs on this, and wasn't able to.
iw seems to be the ISO standard for weeks
ww seems to be an Oracle standard for weeks
iw would sometimes return 53 for Jan 1st
one would start thinking that iw returns week assuming that a new week
starts on monday, but it returns week one when Jan 1st falls on a thur
(1998)... anyway, I can't figure it out, does anybody know how these
'formats' calculate week #?



Thanx.
Received on Mon Oct 02 2000 - 18:02:03 CDT












Original text of this message













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