By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
5.7.35 |
@@session.time_zone | NOW() |
---|---|
SYSTEM | 2022-05-09 18:22:57 |
@@session.time_zone | NOW() |
---|---|
+07:00 | 2022-05-10 00:22:57 |
d | t |
---|---|
2022-05-10 00:22:58 | 2022-05-10 00:22:57.562008 |
DateTime | TimeStamp | Now | DT diff | TS diff | Now wall time here | Now wall +7 (e.g. Utah, US relative to UTC) Small rounding difference? |
---|---|---|---|---|---|---|
1652142178 | 1652116977.562008 | 1652116977.564732 | 07:00:01 | 00:00:00.562008 | 2022-05-09 17:22:57.562008 | 2022-05-10 00:22:58 |