Ask a Question

How to get Hours difference between login and logout

in Education by
How to get time in hours and the hour difference between login and logout times? I used the below query: select LoginDateTime,LogoutDateTime from Fleet_DriverQueueList I have attached a screenshot of my data below. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
Try the following: SELECT ISNULL(DATEDIFF(HOUR, LoginDateTime, LogoutDateTime), 1) FROM Table

Related questions

0 votes
Q: How to get Hours difference between login and logout
    How to get time in hours and the hour difference between login and logout times? I used the below ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 12, 2022 in Education by JackTerrance
0 votes
Q: How to get Hours difference between login and logout
    How to get time in hours and the hour difference between login and logout times? I used the below ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 3, 2022 in Education by JackTerrance
0 votes
Q: Change NULL values in Datetime format to empty string
    I have a table which contains 'NULL' values which are of type 'Datetime'. Now i have to convert ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 22, 2022 in Education by JackTerrance
0 votes
Q: Bypass .Net v3.5 verification when installing SQL Server 2008 Express
    For some reason, when I try to install SQL Server 2008 Express, I get an error saying that I need ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 21, 2022 in Education by JackTerrance
0 votes
Q: Bypass .Net v3.5 verification when installing SQL Server 2008 Express
    For some reason, when I try to install SQL Server 2008 Express, I get an error saying that I need ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 21, 2022 in Education by JackTerrance
0 votes
Q: How do I get logout to work on RubyCAS-Server?
    I have installed and setup RubyCAS-Server and RubyCAS-Client on my machine. Login works perfectly but when ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 30, 2022 in Education by JackTerrance
0 votes
Q: How do I get logout to work on RubyCAS-Server?
    I have installed and setup RubyCAS-Server and RubyCAS-Client on my machine. Login works perfectly but when ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 29, 2022 in Education by JackTerrance
0 votes
Q: How can I use the jwt token for authentication that i get from my login view
    I need to create JWT token authentication, but I don't know how, could you explain me how to do ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 17, 2022 in Education by JackTerrance
0 votes
Q: Sharing login-system between classic ASP and ASP.Net
    A client uses classic ASP to log in to their web based backoffice. I have written a new ASP.Net ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 13, 2022 in Education by JackTerrance
0 votes
Q: How to get difference between two dates?
    How to get difference between two dates? (a) long diffInMilli = java.time.Duration.between(dateTime1, ... questions and answers pdf, java interview questions for beginners...
asked Oct 28, 2021 in Education by JackTerrance
0 votes
Q: how to make a Timer.schedule() for specific hours and minutes?
    i tried to make the schedule() method wait till a specific hour and minute comes and start to execute ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 26, 2022 in Education by JackTerrance
0 votes
Q: how to make a Timer.schedule() for specific hours and minutes?
    i tried to make the schedule() method wait till a specific hour and minute comes and start to execute ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 25, 2022 in Education by JackTerrance
0 votes
Q: How many hours to learn Salesforce?
    Can anyone tell me how many hours to learn Salesforce? Select the correct answer from above options...
asked Jan 10, 2022 in Education by JackTerrance
0 votes
Q: If a current of `0.5A` flows through a metallic wire for 2 hours, then how many electrons would flow through the wire ?
    If a current of 0.5A flows through a metallic wire for 2 hours, then how many electrons would flow through the wire ? Select the correct answer from above options...
asked Jan 5, 2022 in Education by JackTerrance
0 votes
Q: Minute hand overlaps hour hand in 65 mins. In how many days it will gain 1440 hours ?
    Minute hand overlaps hour hand in 65 mins. In how many days it will gain 1440 hours ? A) 57 days B) 58 days C) 60 days D) 61 days...
asked Feb 14, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...