[CALCITE-2178] Extend expression simplifier to work on datetime CEIL/FLOOR functions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Component/s: core
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 14/Feb/18 22:24
• Updated: 27/Feb/24 22:24
• Resolved: 15/Feb/18 23:51

Description

Extend expression simplifier to support:

FLOOR(FLOOR(CAST( '2010-01-10 00:00:00' AS TIMESTAMP) TO HOUR) TO DAY) => FLOOR(CAST( '2010-01-10 00:00:00' AS TIMESTAMP) TO DAY)