Re: analyse month in a date field

Posted in 1998

Jonathan Leffler — Thu, 10 Dec 1998 20:49:27 -0800 — source: Informix-list mailing list archive (1991-1998)

Dirk Emmermacher wrote: > I 've got a problem to analyse the month in date field. > The month has to be analysed in a format. > Is it possible??? > We are working with Informix 4.00 SE. > Format generator is on the system. I suspect you're looking for a minor variant on: SELECT MONTH(date_column) month_num FROM SomeTable WHERE MONTH(date_col2) > 9; -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>