What is an ISO 8601 timestamp, and how does it relate to Unix time?
ISO 8601 writes a moment as 2026-09-23T10:15:00+03:00 — largest unit first, with an explicit UTC offset or Z — so it sorts as text and is unambiguous across locales; RFC 3339 is the Internet profile APIs use. Unix time is the same moment as a count of seconds (or milliseconds in JavaScript) since 1970-01-01T00:00:00Z, with no time zone at all. Most date bugs are an offset applied twice or a local time stored as if it were UTC.
How to use Date Range Generator
- Choose Sequence or Random ranges.
- Enter the From/To dates and the step (or the number and length of ranges).
- Pick a date format and output format, then press Generate.
Date Range Generator features
- Sequences by hour, day, week, month, quarter or year between two dates (up to 1,000 entries)
- Weekdays-only filter
- Month and year steps clamp to the shorter month (31 Jan → 29 Feb → 31 Mar)
- Random start/end pairs with min/max length, optionally non-overlapping
- Every row carries ISO, weekday and year/month/day parts
- Seedable; JSON, CSV, SQL, XML, JSON Lines or table output
Date Range Generator example
Month ends of Q1
Input:
Mode: Sequence · From 2025-01-31 to 2025-03-31 · Step: Monthly · Format: EUOutput:
index,date,weekday
1,31/01/2025,Friday
2,28/02/2025,Friday
3,31/03/2025,MondayFrequently asked questions about Date Range Generator
What does sequence mode produce?
Every hour, day, week, month, quarter or year between two dates (up to 1,000 entries), optionally weekdays only. Month steps keep the day-of-month and clamp to shorter months (31 Jan → 29 Feb).
What about random ranges?
Random start/end pairs with a configurable length in days; with "non-overlapping" enabled the ranges never intersect, which is what booking and scheduling tests usually need.
Which date formats are available?
ISO, ISO date-time, US, EU, Unix seconds/milliseconds, RFC 2822, tabular Hijri and long form.
Which time zone are the dates in, and what happens around DST changes?
Everything is computed in UTC. A plain YYYY-MM-DD is read as midnight UTC, hourly/daily/weekly steps add exact multiples of 60 minutes or 24 hours, month steps use UTC calendar arithmetic, and the weekday comes from the UTC date. No local time zone or DST rule is applied, so a daily sequence never skips or duplicates a day.
References
- RFC 3339: Date and Time on the Internet: TimestampsThe Internet timestamp profile of ISO 8601 (2026-09-23T10:15:00Z) and its offset rules.
- ISO 8601 — Date and time formatThe international standard for writing dates, times, durations and intervals unambiguously.
- Date — JavaScript reference — MDNHow JavaScript represents time as milliseconds since the Unix epoch and parses ISO 8601 strings.
- RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) FilesThe commonly implemented CSV rules: comma separators, CRLF line ends, quoting of fields that contain commas, quotes or line breaks.