SQL Server DATEDIFF () function

Definition and usage

The DATEDIFF () function returns the number of days between two dates.

Grammar

DATEDIFF (Datepart,startdate,enddate)

The datepart parameter can be the following value:

DatePart abbreviation year         yy, yyyy quarter         QQ, Q month         mm, M-year of the day dy, y         dd, D week         wk, WW week         DW, W hour         hh minutes         mi, N sec         SS, s Ms         ms Subtle         MCS nanosecond         NS

Example

DECLARE @q datetimeset @q = getdate () Select id,u_name,u_sex,u_age,u_address from test1 where u_name like ' I% ' SELECT [like Line takes time (milliseconds)]=datediff (Ms,@q,getdate ())

Query results

SQL Server DATEDIFF () function