CREATE TABLE test.ints(i tinyint); INSERT INTO test.ints VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); SELECT CURDATE() + INTERVAL t1.i*100 + t2.i*10 + t3.i DAY AS Date FROM test.ints AS t1 JOIN test.ints AS t2 JOIN test.ints AS t3 WHERE ( t1.i*100 + t2.i*10 + t3.i ) < 1000 ORDER BY Date;
Saturday, July 3, 2010
Generate a thousand daily dates starting today
at 2:22 AM
Labels: MySQL, MySQL Query
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment