Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.18
-
Fix Version/s: 10.0.20
-
Component/s: Temporal Types
-
Environment:CentOS 7
-
Sprint: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' ); |
|