Re: sql distress
Posted in 1999
ADIMULAM SRINIVAS — — source: Informix-list mailing list archive (1991-1998)
Hey Kevin
select * from table
where day(date_field) in (02,03)
and month(date_field) in (03,04)
Srinivas.A
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
>
>
>