Re: analyse month in a date field

Posted in 1998

Dennis Pimple — Thu, 10 Dec 1998 09:21:55 -0700 — source: Informix-list mailing list archive (1991-1998)

Dirk Emmermacher wrote in message <74jbhm$944$1@news00.btx.dtag.de>... >Hi! >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. > Not sure what you mean by "in a format". You're looking for the MONTH function in ISQL (and 4GL). MONTH(date_value) returns smallint (1 - 12). So you can run queries like: SELECT * FROM table WHERE MONTH(date_column) < 7 AND YEAR(date_column) = YEAR(TODAY) All together now: RTFM (seems to be a theme in posts today). >Can someone help me > >Best regards >Dirk Emmermacher >