SqlServer Series Notes-date function

GETDATE (): get the current date and time

DATEADD (datepart, number, date) to calculate the date after the increase. Parameter date is the date to be calculated; parameter number is increment; parameter datepart is the unit of measurement. For optional values, please see remarks.

DATEADD (DAY, 3 ~ date) is the date after the calculation date date3, while DATEADD (MONTH,-8 ~ ~ date) is the date before the calculation date date8

DATEDIFF (datepart, startdate, enddate): calculates the difference between two dates. Datepart is the unit of measurement, and the available value is referred to DateAdd.

Count the number of employees with different seniority:

Select DateDiff (year,FInDate,getdate ()), count (*) from T_Employee group by DateDiff (year,FInDate,getdate ())

DATEPART (datepart,date): returns a specific part of a date

The function of common date function

GETDATE () gets the current time of the system

DAY () gets the number of days in a date

MONTH () gets the month of a date

YEAR () gets the year in a date

DateDiff (date element, date 1, date 2) finds the difference between the date elements of two dates

DateName (date element, date) returns a date element as a character

DatePart (date element, date) returns the date element as an integer