Re: analyse month in a date field

Posted in 1998

Dirk Emmermacher — Fri, 11 Dec 1998 13:26:31 +0100 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler schrieb: > 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> Yes, I want to use this statement function in a format to generate bills. Its for an newspaper .There are people, who get an reduce price the first year, but it is not only january the begin of the contract. Do you any ideas to get the month in a format??? Take care. Dirk Emmermacher