Our Training Programs

All contents are copyright of their authors.

calculate time difference

calculate time difference

simon macharia

10yAsked Jul 24, 2016, 1:07 PM894.NET

I'm try to us the following code

string timespent1 = "SELECT DATEDIFF(minute ,departureTime,entryTime) AS timespent FROM mambo where plateno = '" + TextBox1.Text + "'";

SqlCommand comman = new SqlCommand(timespent1, conn);

comman.Parameters.AddWithValue("@timespent", ToString());

comman.ExecuteNonQuery();

where departureTime is the departure time and entryTime is the entry time both in data type of datetime

unfortunately is returnining a null value in the database.

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Suthish Nair10y ago
Hi Simon, is this a duplicate post or different?
http://www.c-sharpcorner.com/Forums/time-difference3
ali tuncer10y ago
DATEDIFF will return null if one or both columns(departureTime,entryTime) have null values..
simon macharia10y ago
I have tried the code given below but still returning a null value in the column timespent in database
Manas Mohapatra10y ago
You need to do as per following code:
stringtimespent1="SELECT DATEDIFF(minute,departureTime,entryTime)AS timespent
FROM mambo where plateno=@plateNo";

SqlCommand comman=new SqlCommand(timespent1,conn);
comman.Parameters.AddWithValue(@plateNo,TextBox1.Text);
SqlDataReader reader=comman.ExecuteReader();

while(reader.Read())
{
Console.WriteLine(reader[0]));
}
Note: Always use parameterized query to avoid SQL injection.