Random Date Generator
Generate a batch of random dates
As many random dates as you need, in a range, sorted or shuffled, with the format you want — CSV, JSON, SQL literals or Unix timestamps.
Questions people ask
The things that come up about random date generators, answered plainly.
What is this for?
Test fixtures, mostly — seeding a database, load-testing a report, or checking that a chart handles a year's worth of points. Real-looking dates catch bugs that a column of identical values does not.
Can I export them?
As CSV, as a JSON array, as SQL literals for your dialect, or as raw Unix timestamps. Copy or download.
Related tools
Julian days, Excel serials, GPS time, cron expressions and format validators.
Date RandomizerOne random date between two bounds, with a seed so the same seed always gives the same date — for anything you need to be able to reproduce.
Random Time GeneratorRandom times within a window — working hours, overnight, anything — one at a time or in bulk, with a seed for repeatability.
SQL Date FormatterOne instant, rendered as a literal for PostgreSQL, MySQL, SQL Server, Oracle, SQLite, BigQuery and Snowflake — plus how each spells 'now' and how each reads a Unix timestamp.
Unix Time GeneratorThe current timestamp in every precision, ticking, plus generators for a relative time — an hour from now, a token expiry, a cache header — in one click.