Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
5.5.25, 5.3.7
-
None
-
None
Description
SELECT NOW(257);
|
+-----------------------+
|
| NOW(257) |
|
+-----------------------+
|
| 2012-08-07 04:07:25.8 |
|
+-----------------------+
|
1 row in set (0.01 sec)
|
Works the same way in MySQL 5.6. It seems harmless, just somewhat embarrassing, so unless it's a cool feature, maybe it makes sense to fix it some day.
With columns it's different though:
CREATE TABLE t (a DATETIME(257));
|
ERROR 1426 (42000): Too big precision 257 specified for 'a'. Maximum is 6.
|