Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    38

    Unanswered: datetime to minutes?

    hey all, i need to find the ratio of difference in 2 datetime variables and the difference of another 2 datetime vars. I figured the best way to do it is to convert the difference in both numerator and denominator to number of minutes.

    can anyone help ??

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd use something like:
    Code:
    SELECT 1e2 * DateDiff(minute, colA, colB) / DateDiff(minute, colC, colD)
       FROM myTable
    -PatP

Posting Permissions

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