可以再加个extend限制,如下 显示到月 select extend(((extend(current-interval(2) day to day))),year to month) from users; 显示到天 select extend(((extend(current-interval(2) month to month))),year to day) from users; 显示到秒 select extend(((extend(current-interval(2) year to year))),year to second) from users;