Returns the date indicated in the @date parameter truncated up to the part specified in the @datePart parameter.

Syntax

DATETRUNC(@datePart, @date)

Parameters

•@datePart: Indication of the date part, or time unit, that users want to keep. For more information about possible values for this parameter, please check the DATEPART function

•@date: Date to truncate