I am porting an application from Oracle to mySQL and I have this query which
I need to port:
select id, senderID, recipientFirstName, recipientLastName, recipientGender,
occasion, month, day, sentDate
from reminderclub
where (sentDate is null or sentdate-sysdate>30)
and
(to_date(month||'/'||day||'/'||($yearNow+1-sign(sign(month-$monthNow)+1)),
'MM/DD/YYYY'))
between to_date('$dateNow', 'DD-MON-YYYY') and
to_date('$dateThen', 'DD-MON-YYYY')
Help?
Thanks.
****************************************************
Jonathan R. Karlen
President
Karlen Internet Solutions, Inc.
Web Site and Application Development
http://www.karlen.com
[EMAIL PROTECTED]
(914)-923-2116
