starofframe wrote:
Thanks a lot Mike... what's a clear explanation...
You're welcome.
Actually I have used WHERE crea_dt + interval 1 day < curdate() before I read ur reply ...but now I guess I better change it to WHERE crea_dt>curdate-interval 1 day
That's probably just a typo, but just in case, you want WHERE crea_dt<curdate-interval 1 day (< instead of >).
again thanks a lot... and thanks to Jeff too. Sukanto
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]