Re: sql date function

Hi Norman
Thanks, I didn't use 'IW' before...

Dirk

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> schrieb im Newsbeitrag news:E2F6A70FE45242488C865C3BC1245DA702F667B6_at_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 Mon Nov 25 2002 - 06:17:24 CST