By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
| OrderDate | x | y | with_decimals |
|---|---|---|---|
| 05/06/2016 00:00:00 | 1008 | 1008 | 1008.000000 |
| 06/06/2016 00:00:00 | 1008 | 1008 | 1008.000000 |
| 06/06/2017 00:00:00 | 1008 | 1008 | 1008.500000 |
| 07/06/2017 00:00:00 | 1008 | 1008 | 1008.500000 |
| 07/06/2017 00:00:00 | 1008 | 1008 | 1008.500000 |
| 08/06/2018 00:00:00 | 1009 | 1009 | 1009.000000 |
| 03/06/2018 00:00:00 | 1009 | 1009 | 1009.000000 |
| 05/06/2019 00:00:00 | 1009 | 1009 | 1009.500000 |
| 09/06/2019 00:00:00 | 1009 | 1009 | 1009.500000 |