Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.18
-
CentOS 7
-
10.0.20
Description
timediff function does not correctly convert decimal values to datetime when comparing a decimal time to a string time, returning null. Problem does not manifest in the datediff function.
select |
timediff('2014-01-01 00:00:00' , '2014-01-01 01:00:00' ), |
timediff(20140101000000.000 , 20140101010000.000 ),
|
timediff(20140101000000.000 , '2014-01-01 01:00:00' ), |
datediff('2014-01-01 00:00:00' , '2014-01-02 01:00:00' ), |
datediff(20140101000000.000 , 20140102010000.000 ),
|
datediff(20140101000000.000 , '2014-01-02 01:00:00' ); |
|