Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Count number of days using select

    How can i count number of days from today if there's a date provided using select?
    i have high-school graduation date in my table ....and i wanna view the number of days since the graduation using select.....

    Please help!

  2. #2
    Join Date
    Nov 2003
    I don't know what version of MySQL you're using, but try

    select to_days(graduationdate) - to_days(curdate()) from ...

Posting Permissions

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