Get time value from datediff of two dates

Question

0.00/5 (No votes)

See more:

SQL

Hi,
I want a value of time data type from datediff of two dates in sql server 2008.

Posted 28-Mar-12 2:43am

mayankkarki

Updated 28-Mar-12 3:32am

Wes Aday

v2

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Liju Sankar · Answer 1 · 2012-03-28T04:20:00

Please use the

SQL

datepart paramter in DATEDIFF ( datepart , startdate , enddate )

SQL

datepart

Is the part of startdate and enddate that specifies the type of boundary crossed. The following table lists all valid datepart arguments. User-defined variable equivalents are not valid.

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

V. · Answer 2 · 2012-03-28T02:48:00

Solution 1

C#

DateTime startdts = new DateTime(29, 3, 2012, 14, 0, 0);
TimeSpan span = DateTime.Now - startdts;

Then you can use span.Total...... to get the total time difference of the two DateTime objects.

Hope this helps.

Posted 28-Mar-12 2:48am

V.

Comments

mayankkarki 28-Mar-12 8:53am

Thanks,
I am using view in database,there is two datetime columns and on their datediff I have to calculate time.

V. 28-Mar-12 8:57am

You mean this: http://www.dotnetspider.com/forum/148751-How-get-difference-between-two-times-sql.aspx?

Not Active · Answer 3 · 2012-03-28T02:48:00

Solution 2

TimeSpan diff = DateTime.Now.AddHours(2) - DateTime.Now;

TimeSpan has properties for time, hours, minutes, seconds, etc. What more do you need?

Posted 28-Mar-12 2:48am

Not Active

Comments

mayankkarki 28-Mar-12 8:52am

Thanks,
I am using view in database,there is two datetime columns and on their datediff I have to calculate time.

[no name] 28-Mar-12 9:08am

You tagged this as C# not database. Provide accurate information up front and you will get better answers. DATEDIFF has time. What is it that you want?

Saral S Stalin · Answer 4 · 2012-03-28T03:39:00

Solution 3

Try this

SQL

SELECT DATEDIFF(dd, '3/26/2012', '3/28/2012') [Day Difference]

Result

SQL

Day Difference
--------------
2

Other datepart types

SQL

SELECT DATEDIFF(HH, '3/26/2012 3:30 PM', '3/26/2012 5:30 PM') [Hour Difference]
SELECT DATEDIFF(MINUTE, '3/26/2012 3:30 PM', '3/26/2012 5:30 PM') [minute difference]

Similary you can add keywords like Month, SS (Second), MS (millisecond), MCS (microsecond) for differences

Posted 28-Mar-12 3:39am

Saral S Stalin

Updated 28-Mar-12 3:49am

v2

Comments

mayankkarki 29-Mar-12 2:32am

I am doing like that where tasksDurationDays column has no. of days calculated by datediff of startdate and enddate.Is there some other way in c# or sql,I am using view to fill datatable.
dataSet.Tables["Tasks"].Columns.Add("TaskDuration", typeof(TimeSpan));
foreach (DataRow dr in dataSet.Tables["Tasks"].Rows)
{
dr["TaskDuration"] = TimeSpan.FromDays(dr["TaskDurationDays"].ToString().ToInt32());
}

Tarun Dutt · Answer 5 · 2012-03-29T00:25:00

Solution 5

Sure this help you..

if time in second or Minutes then this help you.. to calculate.

select CAST(CallEndTime as datetime) - CAST( CallStTime AS datetime)as Actualtime from DB_Table/View.

Posted 29-Mar-12 0:25am

Tarun Dutt

Comments

mayankkarki 29-Mar-12 6:35am

Thanks,
But this is not working.

Tarun Dutt 29-Mar-12 8:19am

post some values from your table/view then tell me what value exact you want..

[no name] 30-Mar-12 23:42pm

please try datediff

Get time value from datediff of two dates

5 solutions

Solution 4

Solution 1

Solution 2

Solution 3

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us