Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    5

    Unanswered: Hi All Of You! Please Help Me!

    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

  2. #2
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    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.
    Yves & Willy

  3. #3
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    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)
    Yves & Willy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •