Tags: database, date, dates, guys, informix, mysql, number, oracle, pretty, sql

difference between two dates

On Database » Informix

600 words with 2 Comments; publish: Fri, 07 Dec 2007 19:00:00 GMT; (250109.38, « »)

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.....

All Comments

Leave a comment...

  • 2 Comments
    • 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

      #1; Tue, 11 Dec 2007 19:17:00 GMT
    • hi nitin...

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

      regards...

      #2; Tue, 11 Dec 2007 19:18:00 GMT