Timestamp List
Browse Unix timestamps for every month, week, or day of any year.
| Month | Start Date | Start Timestamp | |
|---|---|---|---|
| Jan 2026 | 2026-01-01 | 1767225600 | |
| Feb 2026 | 2026-02-01 | 1769904000 | |
| Mar 2026 | 2026-03-01 | 1772323200 | |
| Apr 2026 | 2026-04-01 | 1775001600 | |
| May 2026 | 2026-05-01 | 1777593600 | |
| Jun 2026Current | 2026-06-01 | 1780272000 | |
| Jul 2026 | 2026-07-01 | 1782864000 | |
| Aug 2026 | 2026-08-01 | 1785542400 | |
| Sep 2026 | 2026-09-01 | 1788220800 | |
| Oct 2026 | 2026-10-01 | 1790812800 | |
| Nov 2026 | 2026-11-01 | 1793491200 | |
| Dec 2026 | 2026-12-01 | 1796083200 |
Unix Timestamps for Dates and Periods
Knowing the Unix timestamp for the start and end of a time period is essential for database queries, log filtering, and analytics. Instead of using date functions that vary across SQL dialects, you can query directly against integer timestamps with range operators — which are faster (index-friendly) and portable.
For example, to fetch all records created in January 2024:
SELECT * FROM events WHERE created_at >= 1704067200 AND created_at < 1706745600This timestamp list gives you those boundary values instantly for any month, week, or day without manual calculation.
Unix Timestamps for Key Dates
| Date (UTC) | Unix Timestamp |
|---|---|
| Jan 1, 2020 00:00:00 UTC | 1577836800 |
| Jan 1, 2021 00:00:00 UTC | 1609459200 |
| Jan 1, 2022 00:00:00 UTC | 1640995200 |
| Jan 1, 2023 00:00:00 UTC | 1672531200 |
| Jan 1, 2024 00:00:00 UTC | 1704067200 |
| Jan 1, 2025 00:00:00 UTC | 1735689600 |
| Jan 1, 2026 00:00:00 UTC | 1767225600 |
| Jan 1, 2030 00:00:00 UTC | 1893456000 |
Common Use Cases for Timestamp Lists
SQL date range queries
Use start/end timestamps in WHERE clauses for efficient indexed queries
Log file filtering
Grep or awk log files with timestamp ranges for incident analysis
Analytics bucketing
Group events by day, week, or month using integer division on timestamps
Billing periods
Define subscription start/end as Unix timestamps for consistent billing cycles
Cache expiry
Set cache-control headers using the end-of-day timestamp as the expiry
Report generation
Pass timestamp boundaries to APIs for date-scoped data exports
Frequently Asked Questions
How do I get the Unix timestamp for the end of a day?▼
End of day (last second) = start_of_day + 86399. End of day (exclusive boundary) = start_of_next_day = start_of_day + 86400. Use the exclusive boundary for SQL range queries to avoid off-by-one errors.
What is the Unix timestamp range for a specific month?▼
Start = Unix timestamp of the 1st of the month at 00:00:00 UTC. End = Unix timestamp of the 1st of the next month at 00:00:00 UTC (use exclusive <). This timestamp list provides both values for every month in any year.
How do I get the Unix timestamp for midnight tonight?▼
In Python: int(datetime.combine(date.today() + timedelta(1), time.min, tzinfo=timezone.utc).timestamp()). In JavaScript: new Date(new Date().toDateString() + " UTC").getTime() / 1000 + 86400.
Are timestamps the same in all timezones?▼
Unix timestamps are always UTC-based. "Midnight Jan 1, 2024" in Tokyo (JST, UTC+9) is a different Unix timestamp than "midnight Jan 1, 2024" in New York (EST, UTC−5). The timestamp list uses UTC midnight by default.