Mysql insert random datetime in a given datetime range

by

Here is an example that should help:

INSERT INTO `sometable` VALUES(
    FROM_UNIXTIME(
        UNIX_TIMESTAMP('2010-04-30 14:53:27') + FLOOR(0 + (RAND() * 63072000))
    )
)

It uses the date 2010-04-30 14:53:27 as the base, converts that to a Unix timestamp, and adds a random number of seconds from 0 to +2 years to the base date and converts it back to a DATETIME.

It should be pretty close but over longer time periods leap years and other adjustments will throw it off.

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. In SQL Server how to get the count of child if both parent and child are available [closed]
  3. Delete the entire content of all table in a Database [closed]
  4. Rank function in MySQL
  5. MySQL select 10 random rows from 600K rows fast
  6. Get a list of dates between two dates
  7. Calculate a running total in MySQL
  8. Find nearest latitude/longitude with an SQL query
  9. Simulate lag function in MySQL
  10. Get record counts for all tables in MySQL database
  11. How do I check if a column is empty or null in MySQL?
  12. Use MySQL spatial extensions to select points inside circle
  13. INSERT … ON DUPLICATE KEY (do nothing)
  14. Subqueries with EXISTS vs IN – MySQL
  15. What is this operator in MySQL?
  16. MySQL create stored procedure syntax with delimiter
  17. 60 million entries, select entries from a certain month. How to optimize database?
  18. Is it possible to GROUP BY multiple columns using MySQL?
  19. MySQL monthly Sale of last 12 months including months with no Sale
  20. How to find non-existing data from another Table by JOIN?
  21. MySQL/SQL: Update with correlated subquery from the updated table itself
  22. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  23. MySQL LIKE query with underscore
  24. Compare only day and month with date field in mysql
  25. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  26. What is the difference between SQL and MySQL? [closed]
  27. how to use a like with a join in sql?
  28. SQL query with avg and group by
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment