date_trunc Truncates a time value based on the specified date part, such as year, day, hour, or minute. StarRocks also provides the year, quarter, month, week, day, and hour functions for you to ...

The TRUNC (datetime) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. This function is not sensitive to the NLS_CALENDAR session ...