Hi In mysql I found a problem with between query.
For example select * from bugdetail where dbugcreate_date between from_days(to_days('2002-03-01')) and from_days(to_days('2002-03-04')) this query shows only those records up to '2002-03-03' instead of '2002-03-04' pl. help Manish --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php