Why do I get the following results?
mysql> select (1008306000-988344000)/86400/7,
mod((1008306000-988344000)/86400,7.0000);
+--------------------------------+------------------------------------------
+
| (1008306000-988344000)/86400/7 | mod((1008306000-988344000)/86400,7.0000)
|
+--------------------------------+------------------------------------------
+
| 33.0060 | 0
|
+--------------------------------+------------------------------------------
+
1 row in set (0.00 sec)
Shouldn't the value in Column 2 be some number other then 0?
I'm running MySQL 3.23.27.
---------------------------------------------------------------------
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