Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    Paris, FRANCE
    Posts
    132

    Post Unanswered: Percentage of progession between 2 dates

    I need to get a percentage of progression between 2 given dates.
    Do anyone know how to that by mySQL?

    to give an idea:
    Code:
    SELECT ((NOW() - start_date)/(end_date - start_date))*100 AS 'progression'
    thx

  2. #2
    Join Date
    Oct 2004
    Location
    Paris, FRANCE
    Posts
    132
    forget it, I got it.
    Code:
    SELECT ((CURDATE() - start_date)/(end_date - start_date))*100 AS 'progression'

Posting Permissions

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