SELECT FROM_UNIXTIME(RAND() * UNIX_TIMESTAMP());
実行結果
mysql> SELECT FROM_UNIXTIME(RAND() * UNIX_TIMESTAMP());
+------------------------------------------+
| FROM_UNIXTIME(RAND() * UNIX_TIMESTAMP()) |
+------------------------------------------+
| 2001-03-01 06:30:36 |
+------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT FROM_UNIXTIME(RAND() * UNIX_TIMESTAMP());
+------------------------------------------+
| FROM_UNIXTIME(RAND() * UNIX_TIMESTAMP()) |
+------------------------------------------+
| 1971-03-12 22:29:16 |
+------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT FROM_UNIXTIME(RAND() * UNIX_TIMESTAMP());
+------------------------------------------+
| FROM_UNIXTIME(RAND() * UNIX_TIMESTAMP()) |
+------------------------------------------+
| 1974-08-03 01:52:59 |
+------------------------------------------+
1 row in set (0.00 sec)