Newbie sql question (YYYYWW -->YYYYMMDD)

Hello, As I'm not familiar with Informix, I would like to drop here a question. I only need to extract some information from an Informix database (version 7.3) , using aan ODBC-driver Question: Is there an easy way to convert an ISO-year plus ISO-week to a date (for example the date of monday) and v.v: Is there an (easy) way to convert a date to the ISO week-number and ISO-year ? I know how to do this in Oracle but in Informix I can't find the necessary date functions. In this question is to trivial or if this forum is not the right place, excuse me ! With regards, Ben Jongbloed

Roland Wintgen <rw@evg.de> posted an answer to your question under the subject "Re: Week function in SQL" on Thursday 2nd December 1999. Ben Jongbloed wrote: > As I'm not familiar with Informix, I would like to drop here a question. > I only need to extract some information from an Informix database (version > 7.3), using aan ODBC-driver > > Question: > Is there an easy way to convert an ISO-year plus ISO-week to a date (for > example the date of monday) and v.v: > Is there an (easy) way to convert a date to the ISO week-number and ISO-year? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>