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' );
|
|
Bug
Major
