By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
season | utc | gmt/bst | gmt/bst -> utc | utc -> gmt/bst |
---|---|---|---|---|
winter | 2019-02-10 15:00:00.000 | 2019-02-10 15:00:00.000 | 2019-02-10 15:00:00.000 +00:00 | 2019-02-10 15:00:00.000 +00:00 |
winter | 2019-03-30 15:00:00.000 | 2019-03-30 15:00:00.000 | 2019-03-30 15:00:00.000 +00:00 | 2019-03-30 15:00:00.000 +00:00 |
summer | 2019-03-31 01:00:00.000 | 2019-03-31 02:00:00.000 | 2019-03-31 01:00:00.000 +00:00 | 2019-03-31 02:00:00.000 +01:00 |
summer | 2019-03-30 14:00:00.000 | 2019-04-15 15:00:00.000 | 2019-04-15 14:00:00.000 +00:00 | 2019-03-30 14:00:00.000 +00:00 |
summer | 2019-10-27 00:59:59.000 | 2019-10-27 01:59:59.000 | 2019-10-27 00:59:59.000 +00:00 | 2019-10-27 01:59:59.000 +01:00 |
winter | 2019-10-27 03:00:00.000 | 2019-10-27 03:00:00.000 | 2019-10-27 03:00:00.000 +00:00 | 2019-10-27 03:00:00.000 +00:00 |