Incorrect type coercion rule for date + interval

[waitingkuo]

Describe the bug A clear and concise description of what the bug is.

coercion rule for date + interval('1 day' ) works but fails for hours/min/sec

To Reproduce Steps to reproduce the behavior:

❯ select now()::date + interval '1 hour';
+----------------------------------------------------+
| CAST(now() AS Date32) + IntervalDayTime("3600000") |
+----------------------------------------------------+
| +11879-01-27                                       |
+----------------------------------------------------+
1 row in set. Query took 0.000 seconds.

Expected behavior A clear and concise description of what you expected to happen.

Cast to Timestamp like what postgresql does

willy=# select now()::date + interval '1 hour';
      ?column?       
---------------------
 2022-08-10 01:00:00
(1 row)

Additional context Add any other context about the problem here.

[waitingkuo]

related issue/pr: #194 #2235

[JasonLi-cn]

My reproduce

❯ select now()::date + interval '1 hour';
+----------------------------------------------------+
| CAST(now() AS Date32) + IntervalDayTime("3600000") |
+----------------------------------------------------+
| 2022-08-12                                         |
+----------------------------------------------------+

[waitingkuo]

@JasonLi-cn thank you, looks like this is solved in some pr. I'll close this issue as this is similar as #3103 now.