Re: Help with Date Range Query

[gerald_clark]

Because now - a future date is a negative number, and therefore < 30.

Trevor Sather wrote:

Hello,

Any idea why the following doesn't work?  It's taken from the MySQL manual
which says it should return records in the last 30 days.  As you can see,
I'm getting records spanning some 19 months from last May to December
2004...
mysql> SELECT StartDate FROM Events
   -> WHERE TO_DAYS(NOW()) - TO_DAYS(StartDate) <= 30;
+----------------+
| StartDate      |
+----------------+
| 20041226000000 |
| 20030721000000 |
| 20030806000000 |
| 20030926000000 |
| 20030510000000 |
| 20030630000000 |
| 20030517000000 |
| 20031017000000 |
| 20030507000000 |
| 20030707000000 |
| 20030510000000 |
| 20030517000000 |
| 20030510000000 |
| 20030515000000 |
| 20030628000000 |
| 20030706000000 |
| 20030803000000 |
+----------------+
17 rows in set (0.01 sec)
Thanks very much for any advice!

Trevor

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]