Oracle and week of Year

From: Harkki Jukka <jht_at_cs.tut.fi>
Date: Wed, 25 Aug 1993 05:56:19 GMT
Message-ID: <1993Aug25.055619.10490_at_news.cs.tut.fi>


Today ORACLE RDBMS V6.0.33.2.3 says:

SQL> select sysdate, to_char(sysdate,'WW'), to_char(to_date('27-aug-93'),'WW')

     from system.dual

SYSDATE TO_CHAR(SYSDATE,'WW') TO_CHAR(TO_DATE('27-AUG-93'),'WW')

---------  ---------------------  ----------------------------------
25-AUG-93  34                     35

But according my (Finnish) calendar week 34 ends at sunday 29.8.1993. And week 35 starts at Monday 30.8.1993, not Friday 27.8.1993.

Is NLS going to support our calendar some day? And scandinavian characters too? Or is it already supporting - am I missing something?

-- 

//
// Jukka Harkki Net: jht_at_cs.tut.fi Addr: Joinex Oy
// Tel: +358 31 222 4680 Pyh{j{rvenkatu 5B
// Fax: +358 31 222 4685 33200 TAMPERE, FINLAND
Received on Wed Aug 25 1993 - 07:56:19 CEST

Original text of this message