Skip to content

Instantly share code, notes, and snippets.

@parzibyte

parzibyte/tiempo_trabajado.txt Secret

Created April 29, 2022 18:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/72e96e81b1c4641e81f528fae57d9c21 to your computer and use it in GitHub Desktop.
Save parzibyte/72e96e81b1c4641e81f528fae57d9c21 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tiempo_trabajado.txt
MariaDB [turnero]> select * from tiempo_trabajado_usuarios;
+----+------------+---------------------+---------------------+----------+
| id | id_usuario | fecha_inicio | fecha_fin | segundos |
+----+------------+---------------------+---------------------+----------+
| 4 | 2 | 2022-03-03 16:55:23 | 2022-03-03 16:55:34 | 11 |
| 5 | 2 | 2022-03-03 16:55:46 | 2022-03-03 16:56:02 | 16 |
| 6 | 2 | 2022-03-03 16:56:13 | 2022-03-03 16:56:20 | 7 |
| 7 | 2 | 2022-03-03 16:58:05 | 2022-03-03 16:59:53 | 108 |
| 8 | 2 | 2022-03-03 17:00:07 | 2022-03-03 17:03:13 | 186 |
| 9 | 1 | 2022-03-03 17:00:17 | 2022-03-03 20:05:28 | 11111 |
| 10 | 2 | 2022-03-03 17:12:23 | 2022-03-03 17:12:29 | 6 |
| 11 | 1 | 2022-03-03 20:06:01 | 2022-03-03 20:06:02 | 1 |
| 12 | 1 | 2022-03-03 20:07:05 | 2022-03-03 20:07:24 | 19 |
| 13 | 1 | 2022-03-03 20:07:33 | 2022-03-03 20:59:29 | 3116 |
| 14 | 3 | 2022-03-03 20:47:24 | 2022-03-03 20:47:27 | 3 |
| 15 | 3 | 2022-03-03 20:47:35 | 2022-03-03 21:10:47 | 1392 |
| 16 | 3 | 2022-03-03 21:10:48 | 2022-03-03 21:10:54 | 6 |
| 17 | 1 | 2022-03-03 21:11:10 | 2022-03-03 21:11:21 | 11 |
| 18 | 4 | 2022-03-03 21:11:42 | 2022-03-03 21:11:47 | 5 |
| 19 | 4 | 2022-03-03 21:11:48 | 2022-03-03 21:11:49 | 1 |
| 20 | 1 | 2022-03-03 21:11:54 | 2022-03-03 21:11:57 | 3 |
| 21 | 1 | 2022-03-03 21:20:49 | 2022-03-03 21:21:07 | 18 |
| 22 | 4 | 2022-03-03 21:21:13 | 2022-03-03 21:33:16 | 723 |
| 23 | 2 | 2022-03-03 21:33:21 | 2022-03-03 21:33:26 | 5 |
| 24 | 2 | 2022-03-03 21:33:27 | 2022-03-03 21:34:37 | 70 |
| 25 | 1 | 2022-03-03 21:34:41 | 2022-03-03 21:34:48 | 7 |
| 26 | 2 | 2022-03-03 21:34:51 | 2022-03-03 21:36:24 | 93 |
| 27 | 3 | 2022-03-03 21:36:27 | 2022-03-03 21:37:10 | 43 |
| 28 | 2 | 2022-03-03 21:37:15 | 2022-03-03 21:38:44 | 89 |
| 29 | 1 | 2022-03-03 21:38:47 | 2022-03-03 21:38:53 | 6 |
| 30 | 2 | 2022-03-03 21:39:01 | 2022-03-03 21:40:22 | 81 |
| 31 | 1 | 2022-03-03 21:40:25 | 2022-03-03 21:41:09 | 44 |
| 32 | 4 | 2022-03-03 21:41:14 | 2022-03-03 21:43:17 | 123 |
| 33 | 1 | 2022-03-03 21:43:25 | 2022-03-03 21:47:17 | 232 |
| 34 | 2 | 2022-03-03 21:47:20 | 2022-03-03 21:48:02 | 42 |
| 35 | 4 | 2022-03-03 21:48:07 | 2022-03-03 21:48:20 | 13 |
| 36 | 1 | 2022-03-03 21:48:26 | 2022-03-03 21:48:59 | 33 |
| 37 | 2 | 2022-03-03 21:49:04 | 2022-03-03 21:51:58 | 174 |
| 38 | 4 | 2022-03-03 21:52:03 | 2022-03-03 21:52:32 | 29 |
| 39 | 1 | 2022-03-04 11:18:19 | 2022-04-29 13:05:36 | 4841237 |
| 40 | 2 | 2022-03-04 11:21:40 | 2022-03-04 11:28:24 | 404 |
| 41 | 2 | 2022-03-04 11:28:50 | 2022-03-04 11:31:41 | 171 |
| 42 | 2 | 2022-03-04 11:34:35 | NULL | 0 |
| 43 | 1 | 2022-04-29 13:06:21 | NULL | 0 |
+----+------------+---------------------+---------------------+----------+
40 rows in set (0.000 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment