Insert/ Update random date in MySQL

by

You can get a random integer with this expression:

To obtain a random integer R in the
range i <= R < j, use the expression
FLOOR(i + RAND() * (j - i)). For
example, to obtain a random integer in
the range the range 7 <= R < 12, you
could use the following statement:

SELECT FLOOR(7 + (RAND() * 5));

https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_rand

Use that to generate a random number of days, hours or minutes (depending on the resolution) and add that number to current date.

Full expression would be:

-- Date only
SELECT CURRENT_DATE - INTERVAL FLOOR(RAND() * 14) DAY;

-- Date and time
SELECT CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14 * 24 * 60 *60) SECOND;

Demo

More Related Contents:

  1. MySQL select 10 random rows from 600K rows fast
  2. Left Outer Join doesn’t return all rows from my left table?
  3. Get a list of dates between two dates
  4. How to populate a table with a range of dates?
  5. MySQL Query GROUP BY day / month / year
  6. quick selection of a random row from a large table in mysql
  7. Error in MySQL when setting default value for DATE or DATETIME
  8. Difference between two dates in MySQL
  9. Simple Random Samples from a Sql database
  10. Get the latest date from grouped MySQL data
  11. How to select the most recent set of dated records from a mysql table
  12. How to select one row randomly taking into account a weight?
  13. quick selection of a random row from a large table in mysql
  14. Compare only day and month with date field in mysql
  15. Simple Random Samples from a MySQL Sql database
  16. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  17. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  18. MYSQL Select One Random record from each Category
  19. How do I extract Month and Year in a MySQL date and compare them?
  20. mysql unique number generation
  21. get first occurrence of last changed value of a column [closed]
  22. MySQL – Rows to Columns
  23. ROW_NUMBER() in MySQL
  24. How can I temporarily disable a foreign key constraint in MySQL?
  25. Creating a “Numbers Table” in MySQL
  26. In SQL, how to select the top 2 rows for each group
  27. Mysql query to dynamically convert rows to columns on the basis of two columns
  28. MySQL: How do I join same table multiple times?
  29. How to insert a file in MySQL database?
  30. INSERT INTO Table from multiple tables

Leave a Comment