select date_format(DATEFIELD, "%d-%m") from YOURTABLE; -- Jason
On Thu, 2002-04-04 at 19:45, saraswathy saras wrote: > hi, > > Can anyone help me.how to query out only day and month from the table. > The result should be like this:- > ------- > |05-04| > ------- > |06-04| > ------- > |07-04| > ------- > is there any way to do this.Please help me. > thanks in advance. > > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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