To calculate total number of days using the given date

Question

0.00/5 (No votes)

See more:

Hi
I want to calculate the total number of days using sql
My requirement is I have posted date and a current date using these two dates i want to calculate the total number of days

Posted 19-Jun-12 21:03pm

Shashwath7

Updated 19-Jun-12 21:04pm

Prasad_Kulkarni

v2

Add a Solution

Comments

bhagirathimfs 20-Jun-12 3:05am

I think u want the difference between the current date and posted date.

5 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arul R Ece · Answer 1 · 2012-06-19T21:05:00

SQL

declare 
@startdate date,
@enddate date
set @enddate='20120901'--yyyymmdd'
set @startdate='20120316'--'yyyymmdd'
select @startdate ,@enddate 
,DATEDIFF(YY,@startdate,@enddate)'int.age in years'
,DATEDIFF(DD,@startdate,@enddate )'int.age in days'
,DATEDIFF(mm,@startdate,@enddate)'int.age in months'

codeBegin · Answer 2 · 2012-06-19T21:09:00

Solution 3

How to get difference between 2 date i.e. hire date and joining date[^]

CP Search[^]

Posted 19-Jun-12 21:09pm

codeBegin

Comments

Prasad_Kulkarni 19-Jul-12 4:48am

My 5!

Mohamed Mitwalli · Answer 3 · 2012-06-19T21:53:00

Solution 4

HI,
Check this

SQL

declare @t1 nvarchar(10)
set @t1 ='1/1/2010'
declare @t2 nvarchar(10)
set @t2 ='1/3/2010'

select datediff(DAY,convert(datetime, convert(char(10), @t1,110)),convert(datetime, convert(char(10),@t2, 110)))

Best Regards
M.Mitwalli

Posted 19-Jun-12 21:53pm

Mohamed Mitwalli

Arunprasath Natarajan · Answer 4 · 2012-06-26T06:41:00

Solution 5

Refer this..
Quite easy for beginners

http://www.w3schools.com/sql/func_datediff.asp[^]

http://blog.sqlauthority.com/2011/10/21/sql-server-datediff-accuracy-of-various-dateparts/[^]

http://msdn.microsoft.com/en-us/library/ms189794.aspx[^]

Posted 26-Jun-12 6:41am

Arunprasath Natarajan

bhagirathimfs · Answer 5 · 2012-06-19T21:06:00

Solution 2

Use DateDiff to find the date difference in sql.
This link may help you to use DateDiff
DateDiff[^]

Posted 19-Jun-12 21:06pm

bhagirathimfs

Comments

Tim Corey 26-Jun-12 12:58pm

DateDiff is what you want to use but the link you provided is for Access, not SQL.

To calculate total number of days using the given date

5 solutions

Solution 1

Solution 3

Solution 4

Solution 5

Solution 2

Add your solution here

Preview 0

To calculate total number of days using the given date

5 solutions

Solution 1

Solution 3

Solution 4

Solution 5

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us