P-Days Maps have ended for the season and will begin again on June 1st.
query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
5.8469 |
2017-06-05 00:00:00.0 |
5.8469 |
474 |
2 |
15.6691 |
2017-06-06 00:00:00.0 |
9.8222 |
474 |
3 |
25.5038 |
2017-06-07 00:00:00.0 |
9.8347 |
474 |
4 |
35.4840 |
2017-06-08 00:00:00.0 |
9.9802 |
474 |
5 |
45.1121 |
2017-06-09 00:00:00.0 |
9.6281 |
474 |
6 |
54.9468 |
2017-06-10 00:00:00.0 |
9.8347 |
474 |
7 |
64.8162 |
2017-06-11 00:00:00.0 |
9.8694 |
474 |
8 |
74.3259 |
2017-06-12 00:00:00.0 |
9.5097 |
474 |
9 |
83.1504 |
2017-06-13 00:00:00.0 |
8.8245 |
474 |
10 |
92.4137 |
2017-06-14 00:00:00.0 |
9.2633 |
474 |
11 |
101.1887 |
2017-06-15 00:00:00.0 |
8.7750 |
474 |
12 |
110.4520 |
2017-06-16 00:00:00.0 |
9.2633 |
474 |
13 |
118.3622 |
2017-06-17 00:00:00.0 |
7.9102 |
474 |
14 |
125.9331 |
2017-06-18 00:00:00.0 |
7.5709 |
474 |
15 |
134.2168 |
2017-06-19 00:00:00.0 |
8.2837 |
474 |
16 |
143.0413 |
2017-06-20 00:00:00.0 |
8.8245 |
474 |
17 |
152.1413 |
2017-06-21 00:00:00.0 |
9.1000 |
474 |
18 |
161.0617 |
2017-06-22 00:00:00.0 |
8.9204 |
474 |
19 |
168.4898 |
2017-06-23 00:00:00.0 |
7.4281 |
474 |
20 |
172.5388 |
2017-06-24 00:00:00.0 |
4.0490 |
474 |
21 |
178.3138 |
2017-06-25 00:00:00.0 |
5.7750 |
474 |
22 |
187.0888 |
2017-06-26 00:00:00.0 |
8.7750 |
474 |
23 |
197.0378 |
2017-06-27 00:00:00.0 |
9.9490 |
474 |
24 |
206.8725 |
2017-06-28 00:00:00.0 |
9.8347 |
474 |
25 |
216.3169 |
2017-06-29 00:00:00.0 |
9.4444 |
474 |
26 |
225.1414 |
2017-06-30 00:00:00.0 |
8.8245 |
474 |
27 |
233.8144 |
2017-07-01 00:00:00.0 |
8.6730 |
474 |
28 |
242.5894 |
2017-07-02 00:00:00.0 |
8.7750 |
474 |
29 |
252.5848 |
2017-07-03 00:00:00.0 |
9.9954 |
474 |
30 |
261.6848 |
2017-07-04 00:00:00.0 |
9.1000 |
474 |
31 |
270.7848 |
2017-07-05 00:00:00.0 |
9.1000 |
474 |
32 |
280.3391 |
2017-07-06 00:00:00.0 |
9.5543 |
474 |
33 |
290.1917 |
2017-07-07 00:00:00.0 |
9.8526 |
474 |
34 |
300.0139 |
2017-07-08 00:00:00.0 |
9.8222 |
474 |
35 |
309.9349 |
2017-07-09 00:00:00.0 |
9.9210 |
474 |
36 |
319.8349 |
2017-07-10 00:00:00.0 |
9.9000 |
474 |
37 |
329.8329 |
2017-07-11 00:00:00.0 |
9.9980 |
474 |
38 |
338.1166 |
2017-07-12 00:00:00.0 |
8.2837 |
474 |
39 |
347.3003 |
2017-07-13 00:00:00.0 |
9.1837 |
474 |
40 |
357.2590 |
2017-07-14 00:00:00.0 |
9.9587 |
474 |
41 |
367.2544 |
2017-07-15 00:00:00.0 |
9.9954 |
474 |
42 |
377.1927 |
2017-07-16 00:00:00.0 |
9.9383 |
474 |
43 |
386.9149 |
2017-07-17 00:00:00.0 |
9.7222 |
474 |
44 |
396.6210 |
2017-07-18 00:00:00.0 |
9.7061 |
474 |
45 |
405.4940 |
2017-07-19 00:00:00.0 |
8.8730 |
474 |
46 |
415.4205 |
2017-07-20 00:00:00.0 |
9.9265 |
474 |
47 |
425.4021 |
2017-07-21 00:00:00.0 |
9.9816 |
474 |
48 |
435.0021 |
2017-07-22 00:00:00.0 |
9.6000 |
474 |
49 |
444.9771 |
2017-07-23 00:00:00.0 |
9.9750 |
474 |
50 |
454.8277 |
2017-07-24 00:00:00.0 |
9.8506 |
474 |
51 |
464.8272 |
2017-07-25 00:00:00.0 |
9.9995 |
474 |
52 |
474.8223 |
2017-07-26 00:00:00.0 |
9.9951 |
474 |
53 |
484.6988 |
2017-07-27 00:00:00.0 |
9.8765 |
474 |
54 |
493.9272 |
2017-07-28 00:00:00.0 |
9.2284 |
474 |
55 |
503.6112 |
2017-07-29 00:00:00.0 |
9.6840 |
474 |
56 |
512.2668 |
2017-07-30 00:00:00.0 |
8.6556 |
474 |
57 |
520.0890 |
2017-07-31 00:00:00.0 |
7.8222 |
474 |
58 |
530.0563 |
2017-08-01 00:00:00.0 |
9.9673 |
474 |
59 |
537.7660 |
2017-08-02 00:00:00.0 |
7.7097 |
474 |
60 |
547.1048 |
2017-08-03 00:00:00.0 |
9.3388 |
474 |
61 |
556.6145 |
2017-08-04 00:00:00.0 |
9.5097 |
474 |
62 |
565.9160 |
2017-08-05 00:00:00.0 |
9.3015 |
474 |
63 |
575.2910 |
2017-08-06 00:00:00.0 |
9.3750 |
474 |
64 |
585.1604 |
2017-08-07 00:00:00.0 |
9.8694 |
474 |
65 |
594.9762 |
2017-08-08 00:00:00.0 |
9.8158 |
474 |
66 |
603.9430 |
2017-08-09 00:00:00.0 |
8.9668 |
474 |
67 |
613.6961 |
2017-08-10 00:00:00.0 |
9.7531 |
474 |
68 |
623.2961 |
2017-08-11 00:00:00.0 |
9.6000 |
474 |
69 |
633.0492 |
2017-08-12 00:00:00.0 |
9.7531 |
474 |
70 |
642.8242 |
2017-08-13 00:00:00.0 |
9.7750 |
474 |
71 |
652.7380 |
2017-08-14 00:00:00.0 |
9.9138 |
474 |
72 |
662.3931 |
2017-08-15 00:00:00.0 |
9.6551 |
474 |
73 |
672.2089 |
2017-08-16 00:00:00.0 |
9.8158 |
474 |
74 |
682.0048 |
2017-08-17 00:00:00.0 |
9.7959 |
474 |
75 |
691.9538 |
2017-08-18 00:00:00.0 |
9.9490 |
474 |
76 |
701.7760 |
2017-08-19 00:00:00.0 |
9.8222 |
474 |
77 |
711.6286 |
2017-08-20 00:00:00.0 |
9.8526 |
474 |
78 |
720.0852 |
2017-08-21 00:00:00.0 |
8.4566 |
474 |
79 |
728.9582 |
2017-08-22 00:00:00.0 |
8.8730 |
474 |
80 |
735.2720 |
2017-08-23 00:00:00.0 |
6.3138 |
474 |
81 |
742.6271 |
2017-08-24 00:00:00.0 |
7.3551 |
474 |
82 |
752.1047 |
2017-08-25 00:00:00.0 |
9.4776 |
474 |
83 |
761.6144 |
2017-08-26 00:00:00.0 |
9.5097 |
474 |
84 |
771.4996 |
2017-08-27 00:00:00.0 |
9.8852 |
474 |
85 |
781.2576 |
2017-08-28 00:00:00.0 |
9.7580 |
474 |
86 |
790.7638 |
2017-08-29 00:00:00.0 |
9.5062 |
474 |
87 |
800.1026 |
2017-08-30 00:00:00.0 |
9.3388 |
474 |
88 |
809.5802 |
2017-08-31 00:00:00.0 |
9.4776 |
474 |
89 |
819.4328 |
2017-09-01 00:00:00.0 |
9.8526 |
474 |
90 |
829.2854 |
2017-09-02 00:00:00.0 |
9.8526 |
474 |
91 |
839.1548 |
2017-09-03 00:00:00.0 |
9.8694 |
474 |
92 |
847.8793 |
2017-09-04 00:00:00.0 |
8.7245 |
474 |
|
CACHED |
false |
EXECUTIONTIME |
2 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '474') AND ddate < '2020-11-01'
ORDER BY ddate ASC |