Re: HELP - How to Do this Query?

Posted in 1997

Dragi Raos — Fri, 24 Oct 1997 00:45:04 +0200 — source: Informix-list mailing list archive (1991-1998)

Yan Liu wrote: > > We have a DATE field of a table. Now I need to select all the records > around a day. For example between "97/10/10" - 10 days and "97/10/10" +10 days. > How shall I write the WHERE statement? > > I know it would be easy for a datetime field by using 10 UNITS DAY. > But what to do for DATE field? Any body have any ideas? Thanks! > > -- > Yan Also take a look at INTERVAL funsction (or whatever it is). Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+