Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    8

    Unanswered: difference between two dates

    hi guys...

    anyone help me with this...

    I'm trying to get the number of day between a date and today, this must be pretty easy but I'm new in this....so will appreciate any help

    thanks......

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    Hi,

    Try to alter the following as per your need:

    select
    date(current) ,created, day(date(current) - created) ,
    ("1/1/2000" - created),
    (date(current) - created)
    from systables where tabid =99


    Hope it helps you.

    Nitin

  3. #3
    Join Date
    May 2006
    Posts
    8
    hi nitin...

    well let me tell that works perfectly !!! , I really thank you....

    regards....

Posting Permissions

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