By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| col | (col + interval 10 * row_number() over (order by col) - 10 minute) |
|---|---|
| 2020-01-01 23:50:00 | 2020-01-01 23:50:00 |
| 2020-01-01 23:50:00 | 2020-01-02 00:00:00 |
| 2020-01-01 23:50:00 | 2020-01-02 00:10:00 |
| 2020-01-01 23:50:00 | 2020-01-02 00:20:00 |
| 2020-01-01 23:50:00 | 2020-01-02 00:30:00 |
| col |
|---|
| 2020-01-01 23:50:00 |
| 2020-01-02 00:00:00 |
| 2020-01-02 00:10:00 |
| 2020-01-02 00:20:00 |
| 2020-01-02 00:30:00 |