[BUG] DATE and TIME function may result in different times/date in one query

[MitchellGale]

What is the bug?
Date/time run in one query may result in different results within the date and time functions in datetime.

How can one reproduce the bug?
run SELECT DATE(TIME("10:32:30")), DATE(TIME("10:32:30")) on border of day and observe that dates can differ.

What is the expected behavior?
One query should result in one uniform date/time used as a result from all. The exam same date/time should be used for all values.

Do you have any additional context?
Fix may involve #1047.

[dai-chen]

wondering is this fixed in #1047 finally?

[Yury-Fridlyand]

DATE function is not updated yet. If you call SELECT DATE(TIME("10:32:30")), DATE(TIME("10:32:30")) on the very edge of two days, you get different results.