Re: Date/Month

Posted in 1996

Stefanie Vario — 6 Mar 1996 21:48:00 -0500 — source: Informix-list mailing list archive (1991-1998)

Joseph Arcieri (arcieri@pilot.njin.net) wrote: : Hi, if I have date fields in a table, is it possible to use the month : function to automatically return values for the current month? e.g. : if entries are from 010165 through 013198 can I retriev all the 03's or : March's? I'm having a mental block here! Thanks for any help, Joe select col1, col2, etc from table where month(date_col) = 3 -- Stefanie Vario svario@zenacomp.com ZenaComp Incorporated http://www.zenacomp.com/zenacomp