By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
HASTA_ID | PROTOKOL_ID | STARTDATE | ENDDATE | CHG | GRP | EX_STARTDATE | EX_ENDDATE |
---|---|---|---|---|---|---|---|
273065 | 11 | 24/01/2018 00:00:00 | 30/01/2018 00:00:00 | 1 | 1 | 24/01/2018 00:00:00 | 10/02/2018 00:00:00 |
273065 | 12 | 25/01/2018 00:00:00 | 10/02/2018 00:00:00 | 0 | 1 | 24/01/2018 00:00:00 | 10/02/2018 00:00:00 |
273065 | 13 | 30/01/2018 00:00:00 | 30/01/2018 00:00:00 | 0 | 1 | 24/01/2018 00:00:00 | 10/02/2018 00:00:00 |
273065 | 14 | 23/02/2018 00:00:00 | 28/02/2018 00:00:00 | 1 | 2 | 23/02/2018 00:00:00 | 28/02/2018 00:00:00 |
273065 | 15 | 21/03/2018 00:00:00 | 29/03/2018 00:00:00 | 1 | 3 | 21/03/2018 00:00:00 | 29/03/2018 00:00:00 |
273065 | 16 | 03/05/2018 00:00:00 | 04/05/2018 00:00:00 | 1 | 4 | 03/05/2018 00:00:00 | 23/05/2018 00:00:00 |
273065 | 17 | 03/05/2018 00:00:00 | 08/05/2018 00:00:00 | 0 | 4 | 03/05/2018 00:00:00 | 23/05/2018 00:00:00 |
273065 | 18 | 14/05/2018 00:00:00 | 22/05/2018 00:00:00 | 0 | 4 | 03/05/2018 00:00:00 | 23/05/2018 00:00:00 |
273065 | 19 | 22/05/2018 00:00:00 | 23/05/2018 00:00:00 | 0 | 4 | 03/05/2018 00:00:00 | 23/05/2018 00:00:00 |
273065 | 20 | 20/09/2018 00:00:00 | 30/09/2018 00:00:00 | 1 | 5 | 20/09/2018 00:00:00 | 30/09/2018 00:00:00 |