Skip to main content Link Search Menu Expand Document (external link)

secondsBetween() : Calculate Seconds Between Dates

On this page

Summary

Calculate the number of seconds between two datetimes. Returns a positive or negative number depending on whether the second datetime is after or before the first.

Signature 

secondsBetween(startDateTime, endDateTime)

Parameters

Parameter Type Required Description
startDateTime DateTime Yes The starting datetime
endDateTime DateTime Yes The ending datetime

Returns

Type: Number (Integer)

The number of seconds between the two datetimes. Positive if endDateTime is after startDateTime, negative if before.

Examples

Countdown Timer 

<p>T-minus  seconds</p>

Data:

doc.Params["model"] = new {
    currentTime = new DateTime(2024, 3, 15, 10, 0, 0),
    launchTime = new DateTime(2024, 3, 15, 10, 5, 30)
};

Output:

<p>T-minus 330 seconds</p>

Performance Timing 

<h3>Operation Performance</h3>

  <p>: s
  
    (Slow)
  
  </p>

Data:

doc.Params["model"] = new {
    operations = new[] {
        new {
            name = "Database Query",
            startTime = new DateTime(2024, 3, 15, 10, 0, 0),
            endTime = new DateTime(2024, 3, 15, 10, 0, 2),
            threshold = 5
        },
        new {
            name = "API Call",
            startTime = new DateTime(2024, 3, 15, 10, 0, 5),
            endTime = new DateTime(2024, 3, 15, 10, 0, 12),
            threshold = 5
        }
    }
};

Output:

<h3>Operation Performance</h3>
<p>Database Query: 2s</p>
<p>API Call: 7s (Slow)</p>

Video Duration 

<p>Duration: :</p>

Data:

doc.Params["model"] = new {
    startTime = new DateTime(2024, 3, 15, 0, 0, 0),
    endTime = new DateTime(2024, 3, 15, 0, 3, 45)
};

Output:

<p>Duration: 3:45</p>

Response Time Analysis 

<h3>API Response Times</h3>
<p>Average: s</p>
<p>Min: s</p>
<p>Max: s</p>

Data:

doc.Params["model"] = new {
    requests = new[] {
        new { responseTime = 2 },
        new { responseTime = 5 },
        new { responseTime = 3 },
        new { responseTime = 8 }
    }
};

Output:

<h3>API Response Times</h3>
<p>Average: 4.5s</p>
<p>Min: 2s</p>
<p>Max: 8s</p>

Notes

  • Returns integer number of seconds (fractional seconds are truncated)
  • Positive result: endDateTime is after startDateTime
  • Negative result: endDateTime is before startDateTime
  • Includes both date and time components
  • For minute-level precision, use minutesBetween()
  • Most precise standard duration function
  • Does not include milliseconds (use direct calculation if needed)

See Also