Hello collegues,
I need your help.
I'm trying to calculate the time enlapsed between login and logout of each user in specifc function of my application.
I don't have rights on the database to create procedures and triggers...
Can you help me to create a query?
Example:
ID | User | Function | Date | Time | Task |
1 | User1 | X | 2016-09-02 | 06:08:00 | Login |
2 | User2 | Z | 2016-09-02 | 06:08:32 | Login |
3 | User1 | X | 2016-09-02 | 06:09:00 | Logout |
4 | User2 | Z | 2016-09-02 | 06:09:32 | Logout |
5 | User1 | X | 2016-09-02 | 06:09:38 | Login |
6 | User1 | X | 2016-09-02 | 06:10:38 | Logout |
7 | User2 | A | 2016-09-03 | 06:10:35 | Login |
8 | User2 | A | 2016-09-03 | 06:11:36 | Logout |
The desired result:
User | Function | Date | Time enlapsed |
User1 | X | 2016-09-02 | 00:02:00 |
User2 | Z | 2016-09-02 | 00:01:00 |
User2 | A | 2016-09-03 | 00:01:01 |
Thanks in advance!!
Best Regardss