Re: sql distress
Hello,
i have tested this, it seems to work (in kshell) :
less <<%EOF%
`
dbaccess sesame <<!
select log_datetime
from t_log
where
extend(log_datetime, month to day ) >= extend( "$1", month to day )
and
extend(log_datetime, month to day ) <= extend( "$2", month to day )
order by log_datetime desc
!
`
%EOF%
A+
PGineste
______________________________ Reply Separator _________________________________
Subject: sql distress
Author: Non-HP-Kevin-Burdish (Kevin_Burdish@timeinc.com) at HP-Europe,mimegw4
Date: 11/06/99 15:22
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