By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 12 Duplicates: 0 Warnings: 0
| timestamp | floored_timestamp | floored_date |
|---|---|---|
| 1514768400 | 1514768400 | 2018-01-01 01:00:00 |
| 1514768401 | 1514768400 | 2018-01-01 01:00:00 |
| 1514769299 | 1514768400 | 2018-01-01 01:00:00 |
| 1514769300 | 1514769300 | 2018-01-01 01:15:00 |
| 1514769301 | 1514769300 | 2018-01-01 01:15:00 |
| 1514770199 | 1514769300 | 2018-01-01 01:15:00 |
| 1514770200 | 1514770200 | 2018-01-01 01:30:00 |
| 1514770201 | 1514770200 | 2018-01-01 01:30:00 |
| 1514771099 | 1514770200 | 2018-01-01 01:30:00 |
| 1514771100 | 1514771100 | 2018-01-01 01:45:00 |
| 1514771101 | 1514771100 | 2018-01-01 01:45:00 |
| 1514771999 | 1514771100 | 2018-01-01 01:45:00 |
| date | floored_date |
|---|---|
| 2018-01-01 01:00:00 | 2018-01-01 01:00:00 |
| 2018-01-01 01:00:01 | 2018-01-01 01:00:00 |
| 2018-01-01 01:14:59 | 2018-01-01 01:00:00 |
| 2018-01-01 01:15:00 | 2018-01-01 01:15:00 |
| 2018-01-01 01:15:01 | 2018-01-01 01:15:00 |
| 2018-01-01 01:29:59 | 2018-01-01 01:15:00 |
| 2018-01-01 01:30:00 | 2018-01-01 01:30:00 |
| 2018-01-01 01:30:01 | 2018-01-01 01:30:00 |
| 2018-01-01 01:44:59 | 2018-01-01 01:30:00 |
| 2018-01-01 01:45:00 | 2018-01-01 01:45:00 |
| 2018-01-01 01:45:01 | 2018-01-01 01:45:00 |
| 2018-01-01 01:59:59 | 2018-01-01 01:45:00 |