Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    14

    Unanswered: Find duration in decimal

    How to find duration from two TimeStamp/DateTime field, without truncation of decimal values

    say if this is the function to find the duration datediff ( minute, startDateTime, completeDateTime) the answer comes as 0 if the value is less than a minute.

    How can i get the duration, like 0.6 mins ???
    Vikram RM

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    datediff ( second, startDateTime, completeDateTime) / 60.0

Tags for this Thread

Posting Permissions

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