sql distress

Posted in 1999

Kevin_Burdish@timeinc.com — Fri, 11 Jun 1999 09:22:24 -0400 — source: Informix-list mailing list archive (1991-1998)

Hey Gang: My mind has a cramp, hoping somebody can help! I want to query a date field for all rows between 02/03 and 03/04 in any year. I've tried some stuff, but can't seem to get it yet. Any help would be greatly appreciated! Thanks, Kevin

↪ replying to Kevin_Burdish@timeinc.com

Art S. Kagel — Fri, 11 Jun 1999 13:11:46 -0400 — source: Informix-list mailing list archive (1991-1998)

WHERE (month(datef) = 2 and day(datef) > 3) OR (month(datef) = 3 and day(datef) <= 4) Art S. Kagel Kevin_Burdish@timeinc.com wrote: > > Hey Gang: > My mind has a cramp, hoping somebody can help! > I want to query a date field for all rows between 02/03 and 03/04 in > any year. I've tried some stuff, but can't seem to get it yet. Any > help would be greatly appreciated! > Thanks, > Kevin