How Do I Subract 00:01:13 And 23:58:13 And Get 3 Minutes?

Question

1.00/5 (1 vote)

See more:

I have a code in which i want to subract 19-06-2014 00:01:13 with 18-06-2014 23:58:13 to get 3 minutes as difference but currently i am getting -23:57:00.I am using timespan and timeofday to get the time only from this date.

Posted 19-Jun-14 6:16am

HakimKanchwala

Add a Solution

Comments

Richard MacCutchan 19-Jun-14 12:20pm

Use the DateTime type for your two values then the TimeSpan calculation will take the date portions into account.

2 solutions

Solution 3

SELECT DATEDIFF(MINUTE,'2014-06-18 23:58:13','2014-06-19 00:01:13') AS MinuteDiff

Posted 19-Jun-14 18:34pm

Namith Krishnan E

Comments

ArunRajendra 20-Jun-14 0:39am

Requirement is in C# not in SQL.

Add a Solution

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

DamithSL · Accepted Answer · 2014-06-19T06:29:00

Solution 1

I'm trying to recreate your problem.

C#

DateTime dt1 =DateTime.ParseExact("19-06-2014 00:01:13", "dd-MM-yyyy HH:mm:ss",null);
DateTime dt2 =DateTime.ParseExact("18-06-2014 23:58:13", "dd-MM-yyyy HH:mm:ss",null);

with above two DateTime objects,

C#

var minutes = (dt1-dt2).TotalMinutes; // result is 3.

Posted 19-Jun-14 6:29am

DamithSL

Comments

Sergey Alexandrovich Kryukov 19-Jun-14 21:02pm

Correct, a 5.
—SA

DamithSL 19-Jun-14 22:01pm

Thank you SA

agent_kruger 20-Jun-14 0:00am

+5 very simple solution

DamithSL 20-Jun-14 0:01am

Thank you Agent_Spock

agent_kruger 20-Jun-14 0:02am

you're welocme

How Do I Subract 00:01:13 And 23:58:13 And Get 3 Minutes?

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

How Do I Subract 00:01:13 And 23:58:13 And Get 3 Minutes?

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us