Details
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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions