TRUNC(value)
Returns the truncated value. If value is of type datetime, the hours, minutes, and seconds are set to zero. Otherwise, it is treated as a number and the fractional part is removed.