Hi,
1. date_format(datecolumn,'%b');
2. date_format(datecolumn,'%d)+0; or
if you want a string result
trim(leading '0' from date_format(datecolumn,'%d));
The manual has very clear description of date functions.
Anvar.
At 01:47 AM 05/04/2002 +0000, you wrote:
>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.
---------------------------------------------------------------------
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
