difference between login time and logout time?

i have to tried displaying login time and logout time from database.now  i am getting hours only and minutes,seconds didn't displayed from database.


This is my link.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ray PaseurCommented:
There is no time display - that link asks for authentication.  Maybe these learning resources can help.

Here is how to handle date and time in PHP and MySQL:

In a nutshell, you want to define your database columns as DATETIME.  In some cases you can use TIMESTAMP.  These definitions are documented in the MySQL manual.  Then you want to store values in the DATETIME columns by using the ISO-8601 date format (the article explains it).  

You can know the client login time.  But unless your client is cooperative and specifically logs out via a script on your server, you cannot know the "logout" time.  For example, ask yourself whether I am logged in to Experts-Exchange right now?  I might be, or I might have left to get coffee and E-E "logged me out" for inactivity.  So trying to get the exact time for a "logout" event is not really a good design principle.  Because HTTP client/server is a stateless protocol, there really is no such thing as a "logged in" user.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Is this in Crystal?

Is the field a datetime field?

Ray PaseurCommented:
Why the bad grade?  The question gave us a link that did not work, and we pointed that out more than a month ago.

Please read the grading guidelines then explain why you gave a marked-down grade without any questions or explanation!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.