Re: week of year function

In article <34C61A5C.4674@informix.com>, Dennis Pimple <dennisp@informix.com> writes >Steffen Kuebler wrote: >> >> Hi there, >> >> I'm searching for a date function which returns me the week of the year. >> >> Can somebody help me ! >Attached is a 4gl module that has two versions, depending on what you >mean by "week of the year" (Does the week start on a given day of the >week like Sunday (so the first week can be shorter than 7 days), or does >the week start on the first weekday of the year (e.g. Thursday for >1998)?) > >This could translate into SPL or NewEra quite readily (I think all base >functions like MDY that are used are in both syntaxes), and there's a >quite dense single line approach commented in the examples so that you >could include it in in-line SQL as well. > >I believe this was posted in the appropriate FAQ sections some time ago. > I assume you mean Section 5. Common SQL Questions:? I cannot find it, another one to add...Thanks!!! -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care