sql date function

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 22 Nov 2002 15:31:27 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702F667B6@lnewton.leeds.lfs.co.uk>

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.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

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