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.
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 +, you wrote:
hi,
I have some more