Re: sql distress

Posted in 1999

Octav Chiriac — Fri, 11 Jun 1999 17:37:48 +0300 — source: Informix-list mailing list archive (1991-1998)

I think it's really simple. Just use EXTEND(date_column, MONTH TO DAY) in your WHERE part. Best Regards, Octav On Fri, Jun 11, 1999 at 09:22:24AM -0400, 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 > > -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com

Related threads

Different instances with markedly different times