Difference Between 2 field of type time

Question

0.00/5 (No votes)

See more:

Hi I have 2 Textbox on my form. First box for enter input time and second for enter output time.
For example 7:30 in textbox1 and 12:25 in textbox2.

1- In the first ,in SQL Server DB table, what type must be select for these 2 time fields?
There is a type datetime but I wants save only time not date.

2- How can I calculate difference between 2 time fields? following commands is wrong:
DateTime dt1 = new DateTime();
dt1 = Convert.ToDateTime(textBox1.Text) - Convert.ToDateTime(textBox1.Text);

Thanks very much

Posted 30-Nov-13 19:52pm

armm1388

Add a Solution

3 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)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-12-01T09:07:00

Solution 2

DATE.

C#

System.DateTime earlier = //...
System.DateTime later = //...
System.TimeSpan duration = later - earlier;
// even if earlier > later, by some reason, negative time spans are also acceptable

—SA

Posted 1-Dec-13 9:07am

Sergey Alexandrovich Kryukov

Updated 14-Dec-13 21:18pm

v2

Jean-Claude ADIBA · Answer 2 · 2013-11-30T20:26:00

Solution 1

HI

1. which version of SQL SERVER do you use ? in SQL SERVER 2008 R2 there is time type which can store timespan, there is datetime and datetime2 for store date and time

but no matter if you cannot use the time type you can store your time in the datetime type field and then when you retrive this value from your database you take only the time part and work with

VB

Dim objDate As DateTime = CDate( datarow("DateTimeField"))
Dim objTime As String =  objDate.ToShortTimeString()

2. for calculate the difference between two time field you can use TimeSpan or DateDiff like this

VB

Dim timeDiff As Long = DateDiff(DateInterval.Hour, objDate1, objDate2)

or

VB

Dim objDate1 As DateTime = Date.Now()
Threading.Thread.Sleep(3000)
Dim objDate2 As DateTime = Date.Now()
Dim span As TimeSpan = objDate2 - objDate1
Console.WriteLine(span.TotalSeconds)

Posted 30-Nov-13 20:26pm

Jean-Claude ADIBA

Updated 30-Nov-13 20:42pm

v2

Comments

phil.o 1-Dec-13 17:50pm

As Sergey stated in solution 2, TimeSpan structure allows to handle operations between DateTimes without the hassle of converting.
Much more efficient and intuitive :)

Jean-Claude ADIBA 2-Dec-13 2:02am

Have you read my answer with his logic ? Solution 1 use TimeSpan and i show it. but he post his question in VB.NET Section so i wrote the answer in VB.net and i show the Existence of DateDiff (Dim timeDiff As Long = DateDiff(DateInterval.Hour, objDate1, objDate2)
).

He ask 2 Questions i try to give answer for these 2 question but Sergey no so ...
My answer don't need conversion any time. i show ealer how to get the part of time in the date as string (he uses a textbox) : Dim objTime As String = objDate.ToShortTimeString()
after i give how have difference between two date with TimeSpan

Dim objDate1 As DateTime = Date.Now()
Threading.Thread.Sleep(3000)
Dim objDate2 As DateTime = Date.Now()
Dim span As TimeSpan = objDate2 - objDate1
Console.WriteLine(span.TotalSeconds)

phil.o 2-Dec-13 4:06am

I read your solution, yes; what I can see now is that it has been modified and does not use any conversion anymore.

Jean-Claude ADIBA 2-Dec-13 5:38am

I desagree I'm sorry, i inform you that after your post i don't edit the solution
you can see the editions history (http://www.codeproject.com/script/Articles/ListVersions.aspx?aid=690513)
yes i have edit just 20mn after my first publish jusT to add some precision but your comment was send later. i accept to be correct but please read before comment and downvote

Abdul Quader Mamun · Answer 3 · 2013-12-14T22:21:00

Solution 3

You can follow the bellow code to subtract time as an example:

C#

DateTime dt = DateTime.Now;
DateTime dt2 = Convert.ToDateTime("1/2/2013 20:30");
TimeSpan ts = (dt2 - dt);
Response.Write(ts.ToString("hh\\:mm\\:ss"));

-Thanks,
Mamun

Posted 14-Dec-13 22:21pm

Abdul Quader Mamun