By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) Jul 25 2020 11:26:55 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
8 rows affected
heuteBzwJetzt_TypDatetime | heuteMinus5Tage |
---|---|
2022-08-06 09:06:08.753 | 2022-08-01 09:06:08.753 |
id | datum | heuteMinus5 | heuteMinus1 |
---|---|---|---|
B | 2022-08-05 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 |
C | 2022-08-04 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 |
D | 2022-08-03 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 |
E | 2022-08-02 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 |
id | datum | HeuteMinus5Tage | HeuteMinus1Tag | Monatsanfang |
---|---|---|---|---|
A | 2022-08-06 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-08-01 00:00:00.000 |
B | 2022-08-05 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-08-01 00:00:00.000 |
C | 2022-08-04 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-08-01 00:00:00.000 |
D | 2022-08-03 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-08-01 00:00:00.000 |
E | 2022-08-02 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-08-01 00:00:00.000 |
id | datum | HeuteMinus5Tage | HeuteMinus1Tag | MonatsanfangMinus1 |
---|---|---|---|---|
A | 2022-08-06 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-31 00:00:00.000 |
B | 2022-08-05 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-31 00:00:00.000 |
C | 2022-08-04 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-31 00:00:00.000 |
D | 2022-08-03 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-31 00:00:00.000 |
E | 2022-08-02 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-31 00:00:00.000 |
F | 2022-08-01 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-31 00:00:00.000 |
id | datum | HeuteMinus5Tage | HeuteMinus1Tag | MonatsanfangMinus2 |
---|---|---|---|---|
A | 2022-08-06 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-30 00:00:00.000 |
B | 2022-08-05 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-30 00:00:00.000 |
C | 2022-08-04 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-30 00:00:00.000 |
D | 2022-08-03 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-30 00:00:00.000 |
E | 2022-08-02 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-30 00:00:00.000 |
F | 2022-08-01 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-30 00:00:00.000 |
G | 2022-07-31 | 2022-08-01 09:06:08.770 | 2022-08-05 09:06:08.770 | 2022-07-30 00:00:00.000 |