Re: again date question

[Anvar Hussain K.M.]

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.