|
A warning is returned in this query:
mysql> SELECT TIME('00:00:00.');
|
+-------------------+
|
| TIME('00:00:00.') |
|
+-------------------+
|
| 00:00:00 |
|
+-------------------+
|
1 row in set, 1 warning (1.38 sec)
|
|
mysql> show warnings;
|
+---------+------+---------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+---------------------------------------------+
|
| Warning | 1292 | Truncated incorrect time value: '00:00:00.' |
|
+---------+------+---------------------------------------------+
|
1 row in set (0.00 sec)
|
No significant information gets lost in this case, so the warning looks unnecessary.
|