query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.5057 |
2025-06-01 00:00:00.0 |
7.5057 |
239 |
2 |
14.4863 |
2025-06-02 00:00:00.0 |
6.9806 |
239 |
3 |
22.5441 |
2025-06-03 00:00:00.0 |
8.0578 |
239 |
4 |
29.2770 |
2025-06-04 00:00:00.0 |
6.7329 |
239 |
5 |
35.2156 |
2025-06-05 00:00:00.0 |
5.9386 |
239 |
6 |
40.5860 |
2025-06-06 00:00:00.0 |
5.3704 |
239 |
7 |
47.3877 |
2025-06-07 00:00:00.0 |
6.8017 |
239 |
8 |
55.4696 |
2025-06-08 00:00:00.0 |
8.0819 |
239 |
9 |
59.6948 |
2025-06-09 00:00:00.0 |
4.2252 |
239 |
10 |
66.1797 |
2025-06-10 00:00:00.0 |
6.4849 |
239 |
11 |
73.8554 |
2025-06-11 00:00:00.0 |
7.6757 |
239 |
12 |
79.7571 |
2025-06-12 00:00:00.0 |
5.9017 |
239 |
13 |
86.7612 |
2025-06-13 00:00:00.0 |
7.0041 |
239 |
14 |
93.8932 |
2025-06-14 00:00:00.0 |
7.1320 |
239 |
15 |
101.4585 |
2025-06-15 00:00:00.0 |
7.5653 |
239 |
16 |
109.3038 |
2025-06-16 00:00:00.0 |
7.8453 |
239 |
17 |
118.6674 |
2025-06-17 00:00:00.0 |
9.3636 |
239 |
18 |
127.1933 |
2025-06-18 00:00:00.0 |
8.5259 |
239 |
19 |
135.3268 |
2025-06-19 00:00:00.0 |
8.1335 |
239 |
20 |
143.6209 |
2025-06-20 00:00:00.0 |
8.2941 |
239 |
|
CACHED |
false |
EXECUTIONTIME |
0 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '239') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-06-20'}
ORDER BY ddate ASC |