you try to select the march 87. 2001 ;)
read the manual about date/time conversion and math:
mysql> select current_date(), current_date()-0, current_date()-14;
| current_date() | current_date()-0 | current_date()-14 |
| 2001-04-12 | 20010412 | 20010398 |
1 row in set (0.00 sec)
gl
----- Original Message -----
From: "Chris Harshman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 8:32 PM
Subject: Is this a bug?
> At the first of the month (no changes made to the database; this script is
> just running SELECT statements at present) the number of rows returned by
> this query dropped noticeably. Is this a bug, is my query just fubar'd,
> or...?
>
> SELECT account.username AS account_username, customers.username AS
> customers_username, account.accout_no, account.email, customers.last_mod
> FROM account LEFT JOIN customers ON account.username = customers.username
> WHERE (customers.username IS NULL OR customers.username LIKE
> \"%_expired\") OR (customers.last_mod <= current_date() - 14 AND
> customers.access_status = 'D') ORDER BY last_mod";
>
> The number of rows returned:
> 4/10 253
> 4/9 247
> 4/8 243
> 4/7 241
> 4/6 234
> 4/5 226
> 4/4 221
> 4/3 216
> 4/2 207
> 4/1 197
> 3/31 333
> 3/30 312
>
>
> Thanks!
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
