By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
cDate | cDay | cDayOfWeek | cDayName |
---|---|---|---|
06/01/2018 00:00:00 | 6 | 7 | Saturday |
07/01/2018 00:00:00 | 7 | 1 | Sunday |
13/01/2018 00:00:00 | 13 | 7 | Saturday |
14/01/2018 00:00:00 | 14 | 1 | Sunday |
20/01/2018 00:00:00 | 20 | 7 | Saturday |
21/01/2018 00:00:00 | 21 | 1 | Sunday |
27/01/2018 00:00:00 | 27 | 7 | Saturday |
28/01/2018 00:00:00 | 28 | 1 | Sunday |
ObjectName | IndexName | IndexType | StartTime | EndTime |
---|---|---|---|---|
OBJ1 | INDEX1 | 1 | 13/01/2018 00:43:00 | 13/01/2018 00:43:38 |
OBJ1 | INDEX1 | 1 | 21/01/2018 11:49:00 | 21/01/2018 11:49:22 |
OBJ1 | INDEX1 | 1 | 07/01/2018 08:22:00 | 07/01/2018 08:22:10 |
OBJ1 | INDEX1 | 1 | 11/01/2018 09:17:00 | 11/01/2018 09:17:19 |
OBJ1 | INDEX1 | 1 | 23/01/2018 00:02:00 | 23/01/2018 00:02:37 |
OBJ1 | INDEX1 | 1 | 24/01/2018 04:17:00 | 24/01/2018 04:17:23 |
OBJ1 | INDEX1 | 1 | 16/01/2018 21:24:00 | 16/01/2018 21:24:12 |
OBJ1 | INDEX1 | 1 | 21/01/2018 11:30:00 | 21/01/2018 11:30:25 |
OBJ1 | INDEX1 | 1 | 04/01/2018 14:01:00 | 04/01/2018 14:01:58 |
OBJ1 | INDEX1 | 1 | 11/01/2018 08:43:00 | 11/01/2018 08:43:38 |
ObjectName | IndexName | IndexType | cDayName | FormatDate | DiffSeconds |
---|---|---|---|---|---|
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 24 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 3 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 54 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 52 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 5 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 14 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 17 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 26 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 19 |
OBJ1 | INDEX1 | 1 | Saturday | [20-40 06-01] | 16 |
ObjectName | IndexName | IndexType | 20-40 06-01 | 5-40 07-01 | 20-40 13-01 | 5-40 14-01 | 20-40 20-01 | 5-40 21-01 | 20-40 27-01 | 5-40 28-01 |
---|---|---|---|---|---|---|---|---|---|---|
OBJ1 | INDEX1 | 1 | 1132 | 867 | 1339 | 1234 | 1312 | 923 | 978 | 839 |
ObjectName | IndexName | IndexType | 20-40 06-01 | 5-40 07-01 | 20-40 13-01 | 5-40 14-01 | 20-40 20-01 | 5-40 21-01 | 20-40 27-01 | 5-40 28-01 |
---|---|---|---|---|---|---|---|---|---|---|
OBJ1 | INDEX1 | 1 | 1132 | 867 | 1339 | 1234 | 1312 | 923 | 978 | 839 |
ObjectName | IndexName | IndexType | 20-40 06-01 | 5-40 07-01 | 20-40 13-01 | 5-40 14-01 | 20-40 20-01 | 5-40 21-01 | 20-40 27-01 | 5-40 28-01 |
---|---|---|---|---|---|---|---|---|---|---|
OBJ1 | INDEX1 | 1 | 1132 | 867 | 1339 | 1234 | 1312 | 923 | 978 | 839 |
ObjectName | IndexName | IndexType | 20-40 06-01 | 5-40 07-01 | 20-40 13-01 | 5-40 14-01 | 20-40 20-01 | 5-40 21-01 | 20-40 27-01 | 5-40 28-01 |
---|---|---|---|---|---|---|---|---|---|---|
OBJ1 | INDEX1 | 1 | 1132 | 867 | 1339 | 1234 | 1312 | 923 | 978 | 839 |