This function returns the number of times the specified date part boundaries were crossed between the supplied dates (as a signed big integer value). The
Tag: SQL Server Date Time Functions
SQL Server – Date Time Functions
Here are a few examples of functions that can help you manipulate DATE in different manners. These will comprise most of your daily job routines.