Nobody is there in these forums to solve my problem... please help me.
Please Give me one example using month function, Using month function Month(some date) will give that month how we can diffretiate that..
My problem is, i had two years of applications(in that i have to fetch below three months pending, more than three months pending, more than six month pending) How can do that please help me....show one example..Data type is DATE

I didn't very good understand your problem.
Could these examples with month() resolves it ?

export DBDATE=MDY4/
dbaccess sysmaster -
Database selected.
> create table AA (a date );
Table created.
> insert into AA (a) values ('10/12/2004');
1 row(s) inserted.
> insert into AA (a) values ('12/1/2004');
1 row(s) inserted.
> select month(a) from yds1 ;
(expression)
10
12
2 row(s) retrieved.
> select month(a)+3 from AA ;
(expression)
13
15
2 row(s) retrieved.
>select * from AA where month(a)-3=7;
a
10/12/2004
1 row(s) retrieved
>select * from AA where month(a + 3 units month) = 1 ;
a
10/12/2004
1 row(s) retrieved.

Hi,

for a full and clear and short explanation about date functions with examples look at :
http://gethelp.devx.com/techtips/inf...0min1000-1.asp

(very slow site, but extr. good pages)