By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | timestamp |
---|---|
11 | 2018-01-01 00:00:00 |
12 | 2018-01-02 00:00:00 |
13 | 2000-01-01 00:00:00 |
14 | 2000-01-01 00:00:00 |
15 | 2018-01-05 00:00:00 |
17 | 2018-01-07 00:00:00 |
18 | 2000-01-01 00:00:00 |
19 | 2018-01-09 00:00:00 |
id | timestamp | closest |
---|---|---|
19 | 2018-01-09 00:00:00 | 19 |
18 | 2000-01-01 00:00:00 | 17 |
17 | 2018-01-07 00:00:00 | 17 |
15 | 2018-01-05 00:00:00 | 15 |
14 | 2000-01-01 00:00:00 | 15 |
13 | 2000-01-01 00:00:00 | 12 |
12 | 2018-01-02 00:00:00 | 12 |
11 | 2018-01-01 00:00:00 | 11 |