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>
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
--Received on Wed Aug 25 1993 - 07:56:19 CEST
//
// 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