Re: sql distress

On Fri, Jun 11, 1999 at 08:47:51PM +0530, Nayan Jain wrote: > > BTW< I tried one another query which didnt work... > > SELECT * FROM table1 > WHERE EXTEND(date_field, MONTH TO DAY) > BETWEEN EXTEND("01/01/1999", MONTH TO DAY) > AND > EXTEND("20/06/1999", MONTH TO DAY)> Why haven't you tried: SELECT * FROM table1 WHERE EXTEND(date_field, MONTH TO DAY) BETWEEN EXTEND(DATE("01/01/1999"), MONTH TO DAY) AND EXTEND(DATE("20/06/1999"), MONTH TO DAY) OR try this SELECT * FROM table1 WHERE EXTEND(date_field, MONTH TO DAY) BETWEEN EXTEND(MDY(1,1,1999), MONTH TO DAY) AND EXTEND(MDY(06,20,1999), MONTH TO DAY) Best Regards, Octav > On Fri, 11 Jun 1999 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