session datetime value

Question

0.00/5 (No votes)

See more:

i have store login_time and logout_time in table.now i have to store difference of logout_time-login_time intable.what i can do.i have try following but i can't do...

SqlCommand cmd3 = new SqlCommand("update logininfo set totaltime=logouttime-logintime where log_id=" + logid, cnn);

Posted 7-Jan-13 7:50am

Member 9511889

Updated 7-Jan-13 8:26am

v2

Add a Solution

1 solution

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)

OriginalGriff · Accepted Answer · 2013-01-07T08:08:00

Solution 1

Why?
Why store something that you have already, in the sense that you can calculate it whenever you need to? Storing it as separate information just increases your database size and provides a route for error to creep in - as it does - when somehow the difference between the In and Out times, and the stores value do not match.

SQL

SELECT DATEDIFF(second, logintime, logouttime) as loggedInSeconds FROM logininfo

If you really must store it, then you can use the same command:

SQL

UPDATE logininfo SET totaltime=DATEDIFF(second, logintime, logouttime)

But I wouldn't do it myself.

Posted 7-Jan-13 8:08am

OriginalGriff

Comments

__TR__ 7-Jan-13 14:10pm

Was about to post the same solution.
I guess you read my mind and posted it :laugh:
+5

OriginalGriff 7-Jan-13 14:14pm

Damn! There must be a hole in my tin-foil helmet...:laugh:

Sergey Alexandrovich Kryukov 7-Jan-13 15:44pm

No, you just miscalculated the skin layer thickness, for such a high-frequency radiation. You just need to use thicker foil for your helmet. Upgrade it as soon as possible, as I'm already sensing what you are up to... (don't worry, I won't tell anyone). My 5, by the way.
—SA

fjdiewornncalwe 7-Jan-13 14:11pm

+5. Same thing I was going to say.