SQL SERVER Get total days between two dates

Question

I m trying to get the total number of days between two days   1 1 2011 3 1 2011  RETURN 62   Is it possible to do in SQL Server

User · Answer

This is working for me -   SELECT DATEDIFF DAY  startdate  enddate  AS DayCount  Example   SELECT DATEDIFF DAY   11 30 2019   GETDATE    AS DayCount

User · Answer

DECLARE  FDate DATETIME  05-05-2019    This is first date    GETDATE    This is Current date   SELECT  DATEDIFF DAY   LastDate  GETDATE     As DifferenceDays  this query will return no of days between firstdate  amp  Current date

User · Answer

PRINT DATEDIFF DAY   1 1 2011    3 1 2011   will give you what you re after   This gives the number of times the midnight boundary is crossed between the two dates   You may decide to need to add one to this if you re including both dates in the count - or subtract one if you don t want to include either date

User · Answer

See DateDiff   DECLARE  startdate date    2011 1 1  DECLARE  enddate date    2011 3 1  SELECT DATEDIFF day   startdate   enddate

User · Answer

You can try this MSDN link  DATEDIFF   datepart   startdate   enddate   SELECT DATEDIFF DAY   1 1 2011    3 1 2011

User · Answer

SQL Server DateDiff  DECLARE  startdate datetime2    2007-05-05 12 10 09 3312722   DECLARE  enddate datetime2    2009-05-04 12 10 09 3312722    SELECT DATEDIFF day   startdate   enddate

User · Answer

SELECT DATEDIFF day   2005-12-31 23 59 59 9999999    2006-01-01 00 00 00 0000000

User · Answer

if you want to do same thing Store Procedure then you need to apply below code   select   datediff dd   CHAR 39   convert varchar 10   FromDate   101     CHAR 39      CHAR 39   convert varchar 10   ToDate   101    CHAR 39         Daysdiff   where  fromdate and  todate is Parameter of the SP

User · Answer

Another date format  select datediff day  20110101   20110301

[sql] SQL SERVER: Get total days between two dates

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008

Examples related to date