List:General Discussion« Previous MessageNext Message »
From:Anvar Hussain K.M. Date:April 5 2002 3:17am
Subject:Re: again date question
View as plain text  
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.

Thread
again date questionsaraswathy saras5 Apr
  • Re: again date questionAnvar Hussain K.M.5 Apr