Physiological Days

P-Days Maps have ended for the season and will begin again on June 1st.

  • DAILY
  • TOTAL
Pdays Forrest Carberry Wawanesa Glenboro Glenora Treherne Holland Gladstone Portage East High Bluff Oakland Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler Kane Brunkild Austin Bagot Elie Kenton Neepawa St. Claude


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 0.0000 2018-05-01 00:00:00.0 0.0000 534
2 2.3275 2018-05-02 00:00:00.0 2.3275 534
3 4.0951 2018-05-03 00:00:00.0 4.0951 534
4 4.8747 2018-05-04 00:00:00.0 4.8747 534
5 5.0196 2018-05-05 00:00:00.0 5.0196 534
6 5.4691 2018-05-06 00:00:00.0 5.4691 534
7 5.8111 2018-05-07 00:00:00.0 5.8111 534
8 5.5260 2018-05-08 00:00:00.0 5.5260 534
9 2.4768 2018-05-09 00:00:00.0 2.4768 534
10 0.4783 2018-05-10 00:00:00.0 0.4783 534
11 2.3423 2018-05-11 00:00:00.0 2.3423 534
12 4.0770 2018-05-12 00:00:00.0 4.0770 534
13 7.1657 2018-05-13 00:00:00.0 7.1657 534
14 4.8407 2018-05-14 00:00:00.0 4.8407 534
15 5.2431 2018-05-15 00:00:00.0 5.2431 534
16 4.0182 2018-05-16 00:00:00.0 4.0182 534
17 2.9239 2018-05-17 00:00:00.0 2.9239 534
18 2.2927 2018-05-18 00:00:00.0 2.2927 534
19 3.4168 2018-05-19 00:00:00.0 3.4168 534
20 6.0246 2018-05-20 00:00:00.0 6.0246 534
21 6.6352 2018-05-21 00:00:00.0 6.6352 534
22 7.0240 2018-05-22 00:00:00.0 7.0240 534
23 7.0065 2018-05-23 00:00:00.0 7.0065 534
24 8.6109 2018-05-24 00:00:00.0 8.6109 534
25 7.1183 2018-05-25 00:00:00.0 7.1183 534
26 8.5827 2018-05-26 00:00:00.0 8.5827 534
27 8.0717 2018-05-27 00:00:00.0 8.0717 534
28 8.1010 2018-05-28 00:00:00.0 8.1010 534
29 7.2072 2018-05-29 00:00:00.0 7.2072 534
30 8.6413 2018-05-30 00:00:00.0 8.6413 534
31 7.8407 2018-05-31 00:00:00.0 7.8407 534
32 5.8211 2018-06-01 00:00:00.0 5.8211 534
33 7.3377 2018-06-02 00:00:00.0 7.3377 534
34 7.0890 2018-06-03 00:00:00.0 7.0890 534
35 5.5183 2018-06-04 00:00:00.0 5.5183 534
36 7.5969 2018-06-05 00:00:00.0 7.5969 534
37 7.5203 2018-06-06 00:00:00.0 7.5203 534
38 7.3847 2018-06-07 00:00:00.0 7.3847 534
39 8.3335 2018-06-08 00:00:00.0 8.3335 534
40 9.6176 2018-06-09 00:00:00.0 9.6176 534
41 7.4664 2018-06-10 00:00:00.0 7.4664 534
42 8.4595 2018-06-11 00:00:00.0 8.4595 534
43 7.9248 2018-06-12 00:00:00.0 7.9248 534
44 6.8986 2018-06-13 00:00:00.0 6.8986 534
45 8.3760 2018-06-14 00:00:00.0 8.3760 534
46 9.1306 2018-06-15 00:00:00.0 9.1306 534
47 8.7896 2018-06-16 00:00:00.0 8.7896 534
48 9.0746 2018-06-17 00:00:00.0 9.0746 534
49 6.8832 2018-06-18 00:00:00.0 6.8832 534
50 7.9627 2018-06-19 00:00:00.0 7.9627 534
51 6.9971 2018-06-20 00:00:00.0 6.9971 534
52 7.2062 2018-06-21 00:00:00.0 7.2062 534
53 7.0505 2018-06-22 00:00:00.0 7.0505 534
54 8.9680 2018-06-23 00:00:00.0 8.9680 534
55 9.5370 2018-06-24 00:00:00.0 9.5370 534
56 9.1694 2018-06-25 00:00:00.0 9.1694 534
57 8.1861 2018-06-26 00:00:00.0 8.1861 534
58 8.9688 2018-06-27 00:00:00.0 8.9688 534
59 7.4328 2018-06-28 00:00:00.0 7.4328 534
60 9.3670 2018-06-29 00:00:00.0 9.3670 534
61 9.5235 2018-06-30 00:00:00.0 9.5235 534
62 8.1727 2018-07-01 00:00:00.0 8.1727 534
63 8.7773 2018-07-02 00:00:00.0 8.7773 534
64 8.1585 2018-07-03 00:00:00.0 8.1585 534
65 9.3800 2018-07-04 00:00:00.0 9.3800 534
66 8.3304 2018-07-05 00:00:00.0 8.3304 534
67 7.7717 2018-07-06 00:00:00.0 7.7717 534
68 5.0860 2018-07-07 00:00:00.0 5.0860 534
69 8.1962 2018-07-08 00:00:00.0 8.1962 534
70 7.9479 2018-07-09 00:00:00.0 7.9479 534
71 8.0985 2018-07-10 00:00:00.0 8.0985 534
72 8.6479 2018-07-11 00:00:00.0 8.6479 534
73 7.6656 2018-07-12 00:00:00.0 7.6656 534
74 7.3243 2018-07-13 00:00:00.0 7.3243 534
75 6.3717 2018-07-14 00:00:00.0 6.3717 534
76 8.5359 2018-07-15 00:00:00.0 8.5359 534
77 7.1305 2018-07-16 00:00:00.0 7.1305 534
78 6.0411 2018-07-17 00:00:00.0 6.0411 534
79 7.2899 2018-07-18 00:00:00.0 7.2899 534
80 8.8668 2018-07-19 00:00:00.0 8.8668 534
81 8.7482 2018-07-20 00:00:00.0 8.7482 534
82 7.4027 2018-07-21 00:00:00.0 7.4027 534
83 9.2935 2018-07-22 00:00:00.0 9.2935 534
84 9.0500 2018-07-23 00:00:00.0 9.0500 534
85 8.4356 2018-07-24 00:00:00.0 8.4356 534
86 6.9939 2018-07-25 00:00:00.0 6.9939 534
87 8.4862 2018-07-26 00:00:00.0 8.4862 534
88 8.0548 2018-07-27 00:00:00.0 8.0548 534
89 7.3739 2018-07-28 00:00:00.0 7.3739 534
90 7.6998 2018-07-29 00:00:00.0 7.6998 534
91 7.4586 2018-07-30 00:00:00.0 7.4586 534
92 8.6925 2018-07-31 00:00:00.0 8.6925 534
93 5.8425 2018-08-01 00:00:00.0 5.8425 534
94 6.1892 2018-08-02 00:00:00.0 6.1892 534
95 7.4985 2018-08-03 00:00:00.0 7.4985 534
96 7.6829 2018-08-04 00:00:00.0 7.6829 534
97 7.9814 2018-08-05 00:00:00.0 7.9814 534
98 7.2913 2018-08-06 00:00:00.0 7.2913 534
99 7.3339 2018-08-07 00:00:00.0 7.3339 534
100 8.5970 2018-08-08 00:00:00.0 8.5970 534
101 7.4328 2018-08-09 00:00:00.0 7.4328 534
102 6.9922 2018-08-10 00:00:00.0 6.9922 534
103 5.8491 2018-08-11 00:00:00.0 5.8491 534
104 5.2799 2018-08-12 00:00:00.0 5.2799 534
105 9.2993 2018-08-13 00:00:00.0 9.2993 534
106 6.5345 2018-08-14 00:00:00.0 6.5345 534
107 6.3412 2018-08-15 00:00:00.0 6.3412 534
108 7.8700 2018-08-16 00:00:00.0 7.8700 534
109 6.2931 2018-08-17 00:00:00.0 6.2931 534
110 6.8271 2018-08-18 00:00:00.0 6.8271 534
111 7.6137 2018-08-19 00:00:00.0 7.6137 534
112 5.8527 2018-08-20 00:00:00.0 5.8527 534
113 6.0578 2018-08-21 00:00:00.0 6.0578 534
114 7.8363 2018-08-22 00:00:00.0 7.8363 534
115 7.5832 2018-08-23 00:00:00.0 7.5832 534
116 7.2986 2018-08-24 00:00:00.0 7.2986 534
117 5.8350 2018-08-25 00:00:00.0 5.8350 534
118 3.8751 2018-08-26 00:00:00.0 3.8751 534
119 5.9287 2018-08-27 00:00:00.0 5.9287 534
120 7.2907 2018-08-28 00:00:00.0 7.2907 534
121 6.5425 2018-08-29 00:00:00.0 6.5425 534
122 7.1462 2018-08-30 00:00:00.0 7.1462 534
123 8.1481 2018-08-31 00:00:00.0 8.1481 534
124 6.1631 2018-09-01 00:00:00.0 6.1631 534
125 7.6488 2018-09-02 00:00:00.0 7.6488 534
126 6.0924 2018-09-03 00:00:00.0 6.0924 534
127 6.8496 2018-09-04 00:00:00.0 6.8496 534
128 4.2629 2018-09-05 00:00:00.0 4.2629 534
129 5.7660 2018-09-06 00:00:00.0 5.7660 534
130 6.3287 2018-09-07 00:00:00.0 6.3287 534
131 8.7174 2018-09-08 00:00:00.0 8.7174 534
132 8.6415 2018-09-09 00:00:00.0 8.6415 534
133 6.3398 2018-09-10 00:00:00.0 6.3398 534
134 7.3836 2018-09-11 00:00:00.0 7.3836 534
135 3.0400 2018-09-12 00:00:00.0 3.0400 534
136 6.1611 2018-09-13 00:00:00.0 6.1611 534
137 5.7118 2018-09-14 00:00:00.0 5.7118 534
138 5.9671 2018-09-15 00:00:00.0 5.9671 534
139 3.6992 2018-09-16 00:00:00.0 3.6992 534
140 2.3078 2018-09-17 00:00:00.0 2.3078 534
141 2.6827 2018-09-18 00:00:00.0 2.6827 534
142 1.8102 2018-09-19 00:00:00.0 1.8102 534
143 0.5061 2018-09-20 00:00:00.0 0.5061 534
144 1.2370 2018-09-21 00:00:00.0 1.2370 534
145 0.1722 2018-09-22 00:00:00.0 0.1722 534
146 0.0000 2018-09-23 00:00:00.0 0.0000 534
147 0.8033 2018-09-24 00:00:00.0 0.8033 534
148 2.5833 2018-09-25 00:00:00.0 2.5833 534
149 0.8661 2018-09-26 00:00:00.0 0.8661 534
150 0.0704 2018-09-27 00:00:00.0 0.0704 534
151 0.0000 2018-09-28 00:00:00.0 0.0000 534
152 0.5602 2018-09-29 00:00:00.0 0.5602 534
153 0.0000 2018-09-30 00:00:00.0 0.0000 534
154 0.3918 2018-10-01 00:00:00.0 0.3918 534
155 0.1887 2018-10-02 00:00:00.0 0.1887 534
156 0.0000 2018-10-03 00:00:00.0 0.0000 534
157 0.0000 2018-10-04 00:00:00.0 0.0000 534
158 0.0000 2018-10-05 00:00:00.0 0.0000 534
159 0.0000 2018-10-06 00:00:00.0 0.0000 534
160 0.0000 2018-10-07 00:00:00.0 0.0000 534
161 0.0000 2018-10-08 00:00:00.0 0.0000 534
162 0.0000 2018-10-09 00:00:00.0 0.0000 534
163 0.0000 2018-10-10 00:00:00.0 0.0000 534
164 0.0000 2018-10-11 00:00:00.0 0.0000 534
165 0.2535 2018-10-12 00:00:00.0 0.2535 534
166 0.0000 2018-10-13 00:00:00.0 0.0000 534
167 0.0000 2018-10-14 00:00:00.0 0.0000 534
168 0.1556 2018-10-15 00:00:00.0 0.1556 534
169 0.0000 2018-10-16 00:00:00.0 0.0000 534
170 0.4642 2018-10-17 00:00:00.0 0.4642 534
171 6.1585 2018-10-18 00:00:00.0 6.1585 534
172 1.2040 2018-10-19 00:00:00.0 1.2040 534
173 0.0000 2018-10-20 00:00:00.0 0.0000 534
174 2.5495 2018-10-21 00:00:00.0 2.5495 534
175 0.0877 2018-10-22 00:00:00.0 0.0877 534
176 0.1722 2018-10-23 00:00:00.0 0.1722 534
177 0.9261 2018-10-24 00:00:00.0 0.9261 534
178 0.4500 2018-10-25 00:00:00.0 0.4500 534
179 1.2152 2018-10-26 00:00:00.0 1.2152 534
180 0.0704 2018-10-27 00:00:00.0 0.0704 534
181 0.0000 2018-10-28 00:00:00.0 0.0000 534
182 0.0000 2018-10-29 00:00:00.0 0.0000 534
183 0.0000 2018-10-30 00:00:00.0 0.0000 534
184 0.0000 2018-10-31 00:00:00.0 0.0000 534
CACHED false
EXECUTIONTIME 3
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '534') AND ddate < '2018-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/31/2018 0 0
10/30/2018 0 0
10/29/2018 0 0
10/28/2018 0 0
10/27/2018 0 0
10/26/2018 1 1
10/25/2018 0 0
10/24/2018 1 1
10/23/2018 0 0
10/22/2018 0 0
10/21/2018 3 3
10/20/2018 0 0
10/19/2018 1 1
10/18/2018 6 6
10/17/2018 0 0
10/16/2018 0 0
10/15/2018 0 0
10/14/2018 0 0
10/13/2018 0 0
10/12/2018 0 0
10/11/2018 0 0
10/10/2018 0 0
10/9/2018 0 0
10/8/2018 0 0
10/7/2018 0 0
10/6/2018 0 0
10/5/2018 0 0
10/4/2018 0 0
10/3/2018 0 0
10/2/2018 0 0
10/1/2018 0 0
9/30/2018 0 0
9/29/2018 1 1
9/28/2018 0 0
9/27/2018 0 0
9/26/2018 1 1
9/25/2018 3 3
9/24/2018 1 1
9/23/2018 0 0
9/22/2018 0 0
9/21/2018 1 1
9/20/2018 1 1
9/19/2018 2 2
9/18/2018 3 3
9/17/2018 2 2
9/16/2018 4 4
9/15/2018 6 6
9/14/2018 6 6
9/13/2018 6 6
9/12/2018 3 3
9/11/2018 7 7
9/10/2018 6 6
9/9/2018 9 9
9/8/2018 9 9
9/7/2018 6 6
9/6/2018 6 6
9/5/2018 4 4
9/4/2018 7 7
9/3/2018 6 6
9/2/2018 8 8
9/1/2018 6 6
8/31/2018 8 8
8/30/2018 7 7
8/29/2018 7 7
8/28/2018 7 7
8/27/2018 6 6
8/26/2018 4 4
8/25/2018 6 6
8/24/2018 7 7
8/23/2018 8 8
8/22/2018 8 8
8/21/2018 6 6
8/20/2018 6 6
8/19/2018 8 8
8/18/2018 7 7
8/17/2018 6 6
8/16/2018 8 8
8/15/2018 6 6
8/14/2018 7 7
8/13/2018 9 9
8/12/2018 5 5
8/11/2018 6 6
8/10/2018 7 7
8/9/2018 7 7
8/8/2018 9 9
8/7/2018 7 7
8/6/2018 7 7
8/5/2018 8 8
8/4/2018 8 8
8/3/2018 7 7
8/2/2018 6 6
8/1/2018 6 6
7/31/2018 9 9
7/30/2018 7 7
7/29/2018 8 8
7/28/2018 7 7
7/27/2018 8 8
7/26/2018 8 8
7/25/2018 7 7
7/24/2018 8 8
7/23/2018 9 9
7/22/2018 9 9
7/21/2018 7 7
7/20/2018 9 9
7/19/2018 9 9
7/18/2018 7 7
7/17/2018 6 6
7/16/2018 7 7
7/15/2018 9 9
7/14/2018 6 6
7/13/2018 7 7
7/12/2018 8 8
7/11/2018 9 9
7/10/2018 8 8
7/9/2018 8 8
7/8/2018 8 8
7/7/2018 5 5
7/6/2018 8 8
7/5/2018 8 8
7/4/2018 9 9
7/3/2018 8 8
7/2/2018 9 9
7/1/2018 8 8
6/30/2018 10 10
6/29/2018 9 9
6/28/2018 7 7
6/27/2018 9 9
6/26/2018 8 8
6/25/2018 9 9
6/24/2018 10 10
6/23/2018 9 9
6/22/2018 7 7
6/21/2018 7 7
6/20/2018 7 7
6/19/2018 8 8
6/18/2018 7 7
6/17/2018 9 9
6/16/2018 9 9
6/15/2018 9 9
6/14/2018 8 8
6/13/2018 7 7
6/12/2018 8 8
6/11/2018 8 8
6/10/2018 7 7
6/9/2018 10 10
6/8/2018 8 8
6/7/2018 7 7
6/6/2018 8 8
6/5/2018 8 8
6/4/2018 6 6
6/3/2018 7 7
6/2/2018 7 7
6/1/2018 6 6
5/31/2018 8 8
5/30/2018 9 9
5/29/2018 7 7
5/28/2018 8 8
5/27/2018 8 8
5/26/2018 9 9
5/25/2018 7 7
5/24/2018 9 9
5/23/2018 7 7
5/22/2018 7 7
5/21/2018 7 7
5/20/2018 6 6
5/19/2018 3 3
5/18/2018 2 2
5/17/2018 3 3
5/16/2018 4 4
5/15/2018 5 5
5/14/2018 5 5
5/13/2018 7 7
5/12/2018 4 4
5/11/2018 2 2
5/10/2018 0 0
5/9/2018 2 2
5/8/2018 6 6
5/7/2018 6 6
5/6/2018 5 5
5/5/2018 5 5
5/4/2018 5 5
5/3/2018 4 4
5/2/2018 2 2
5/1/2018 0 0