date_floor与date_ceil不能使用,提示找不到函数,不是预期的函数名

Viewed 35

image.png

select date_ceil("2023-07-13 22:28:18",interval 5 second);
select date_ceil("2023-07-13 22:28:18",interval 5 minute);
select date_floor("0001-01-01 00:00:16",interval 5 second);
select date_floor("0001-01-01 00:00:18",interval 5 second);
1 Answers