Skip to content

Instantly share code, notes, and snippets.

@andyfowler

andyfowler/random-time-from-range.sql

Created November 2, 2010 14:26
Show Gist options
  • Save andyfowler/659673 to your computer and use it in GitHub Desktop.
Save andyfowler/659673 to your computer and use it in GitHub Desktop.
Download ZIP
Generate a random SQL time from a given range. For generating lots of fake data.
Raw
random-time-from-range.sql
FROM_UNIXTIME(RAND() * (
UNIX_TIMESTAMP('2010-12-30 15:00:00') -
UNIX_TIMESTAMP('2010-10-25 12:00:00')) +
UNIX_TIMESTAMP('2010-10-25 12:00:00')
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment