Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sql date function
Dirk,
Using 'WW' and 'IW' on the same date gives different results for, say 07-04-2000 (7th April if anyone from USA is reading !). 'WW' gives week 15, 'IW' gives week 14 so I suspect the OP needs to knewo if he wants ISO week numbers (IW) or not (WW).
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Dirk Tschentscher
[mailto:dirk.tschentscherREMOVE_at_THISvolkswagen.de]
Posted At: Friday, November 22, 2002 11:34 AM
Posted To: server
Conversation: sql date function
Subject: Re: sql date function
Hi Maros,
select to_char(datefield,'WW') from...
Look for date functions in the manual.
Rgds
Dirk Received on Fri Nov 22 2002 - 09:31:27 CST