hi, I have some more problem with date query. 1.how to return month from numeric to aalpabet.04->Apr. 2.how to return day or month without 0 in front. i mean if day is 01->1,same also month if 02-2.
Is it possible.please help me. Thanks in advance. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. --------------------------------------------------------------------- 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