Week of year

Posted in 2004

Ruben Dutan — Wed, 01 Dec 2004 15:27:29 — source: IIUG Forums & Mailing Lists

Hi folks Exists a function to return the number of week in the year or month? Thanks in advance for your help Ruben

↪ replying to Ruben Dutan

June C. Hunt — Wed, 01 Dec 2004 16:34:53 — source: IIUG Forums & Mailing Lists

Ruben Dutan wrote: > > Exists a function to return the number of week in the year or month? > I believe you are going to have to go with a stored procedure. Jonathan Leffler has already created one; the link below takes you to the thread at groups.google.com. http://tinyurl.com/3zbz4 You can find the same thing by searching the CDI archives via the IIUG web site. The subject of the thread is: ISO 8601 Week Number Stored Procedures. -- June Hunt

↪ replying to Ruben Dutan

Martin Fuerderer — Thu, 02 Dec 2004 08:54:10 — source: IIUG Forums & Mailing Lists

Hi, you may want to look at ISO C function: #include <time.h> size_t strftime(char *restrict s, size_t maxsize, const char *restrict format, const struct tm *restrict timeptr); Look for the format string specifiers "%U", "%V" or "%W" according to your taste. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Data Management Solutions forum.subscriber@iiug.org wrote on 01.12.2004 16:27:33: > Hi folks > > Exists a function to return the number of week in the year or month? > > Thanks in advance for your help > > Ruben > > >