Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
-
None
Description
SET sql_mode=''; -- Allow zero date |
SELECT
|
CAST(TIMESTAMP'0000-00-00 00:00:00.123456' AS DECIMAL(10,6)) AS c1, |
CAST(TIME'00:00:00.123456' AS DECIMAL(10,6)) AS c2; |
+----------+----------+
|
| c1 | c2 |
|
+----------+----------+
|
| 0.000000 | 0.000000 |
|
+----------+----------+
|
The expected result would be 0.123456 for both columns.