Calculate a cutoff for logs, expiration windows, or database searches. Enter a starting timestamp and a signed offset. Negative values subtract; positive values add.
Elapsed time: every day here is exactly 24 hours. This is not calendar arithmetic: across a daylight-saving change, adding one day may change the local clock hour.
Result and search cutoffs
- Original timestamp
- Original UTC date
- Original local date
- Result timestamp
- Result UTC date
- Result local date
- Elapsed seconds added
Start — inclusive
End — exclusive
The range runs from the earlier instant up to, but not including, the later instant. A zero offset produces an empty range.
Replace event_timestamp with your numeric timestamp column. Both boundaries use the selected timestamp unit; match it to your stored data.
Quick duration reference
| Duration | Seconds | Milliseconds |
|---|---|---|
| 1 minute | 60 | 60,000 |
| 5 minutes | 300 | 300,000 |
| 15 minutes | 900 | 900,000 |
| 30 minutes | 1,800 | 1,800,000 |
| 1 hour | 3,600 | 3,600,000 |
| 24 hours | 86,400 | 86,400,000 |
| 7 × 24 hours | 604,800 | 604,800,000 |
Example: records from the preceding 15 minutes
Starting at Unix timestamp 1700000000, subtract 900 seconds to get 1699999100. Use event_timestamp >= 1699999100 AND event_timestamp < 1700000000 for a window that includes its start and excludes its end.
Elapsed time versus calendar time
In America/New_York, adding 24 elapsed hours to noon on March 7, 2026 reaches 1 p.m. on March 8. “Noon tomorrow” is only 23 elapsed hours later because the clocks move forward. This calculator always adds a fixed duration to the instant; the display timezone does not change the arithmetic.
For local date interpretation, use the time zone converter. For a column of timestamps, use the batch converter.