Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Carberry North Wawanesa Glenboro Glenora Treherne Holland Gladstone Portage East High Bluff Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Macdonald 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 9.3388 2017-05-15 00:00:00.0 9.3388 244
2 16.5449 2017-05-16 00:00:00.0 7.2061 244
3 18.5730 2017-05-17 00:00:00.0 2.0281 244
4 19.9506 2017-05-18 00:00:00.0 1.3776 244
5 24.3256 2017-05-19 00:00:00.0 4.3750 244
6 28.5929 2017-05-20 00:00:00.0 4.2673 244
7 29.7031 2017-05-21 00:00:00.0 1.1102 244
8 33.0725 2017-05-22 00:00:00.0 3.3694 244
9 40.1256 2017-05-23 00:00:00.0 7.0531 244
10 48.1006 2017-05-24 00:00:00.0 7.9750 244
11 56.1394 2017-05-25 00:00:00.0 8.0388 244
12 64.1144 2017-05-26 00:00:00.0 7.9750 244
13 72.3981 2017-05-27 00:00:00.0 8.2837 244
14 78.3568 2017-05-28 00:00:00.0 5.9587 244
15 81.3726 2017-05-29 00:00:00.0 3.0158 244
16 87.5109 2017-05-30 00:00:00.0 6.1383 244
17 96.7742 2017-05-31 00:00:00.0 9.2633 244
18 103.9298 2017-06-01 00:00:00.0 7.1556 244
19 112.5026 2017-06-02 00:00:00.0 8.5728 244
20 122.0088 2017-06-03 00:00:00.0 9.5062 244
21 131.9675 2017-06-04 00:00:00.0 9.9587 244
22 141.9070 2017-06-05 00:00:00.0 9.9395 244
23 151.6984 2017-06-06 00:00:00.0 9.7914 244
24 161.6249 2017-06-07 00:00:00.0 9.9265 244
25 171.6244 2017-06-08 00:00:00.0 9.9995 244
26 181.5509 2017-06-09 00:00:00.0 9.9265 244
27 191.5096 2017-06-10 00:00:00.0 9.9587 244
28 201.5076 2017-06-11 00:00:00.0 9.9980 244
29 210.9520 2017-06-12 00:00:00.0 9.4444 244
30 220.1760 2017-06-13 00:00:00.0 9.2240 244
31 229.8311 2017-06-14 00:00:00.0 9.6551 244
32 239.0148 2017-06-15 00:00:00.0 9.1837 244
33 248.4250 2017-06-16 00:00:00.0 9.4102 244
34 256.7673 2017-06-17 00:00:00.0 8.3423 244
35 264.3382 2017-06-18 00:00:00.0 7.5709 244
36 272.8504 2017-06-19 00:00:00.0 8.5122 244
37 281.7234 2017-06-20 00:00:00.0 8.8730 244
38 291.0984 2017-06-21 00:00:00.0 9.3750 244
39 300.1106 2017-06-22 00:00:00.0 9.0122 244
40 307.8882 2017-06-23 00:00:00.0 7.7776 244
41 312.3698 2017-06-24 00:00:00.0 4.4816 244
42 318.3285 2017-06-25 00:00:00.0 5.9587 244
43 326.8953 2017-06-26 00:00:00.0 8.5668 244
44 336.7111 2017-06-27 00:00:00.0 9.8158 244
45 346.2208 2017-06-28 00:00:00.0 9.5097 244
46 355.6652 2017-06-29 00:00:00.0 9.4444 244
47 364.6320 2017-06-30 00:00:00.0 8.9668 244
48 373.4070 2017-07-01 00:00:00.0 8.7750 244
49 382.3274 2017-07-02 00:00:00.0 8.9204 244
50 392.3146 2017-07-03 00:00:00.0 9.9872 244
51 401.2763 2017-07-04 00:00:00.0 8.9617 244
52 410.7319 2017-07-05 00:00:00.0 9.4556 244
53 420.4159 2017-07-06 00:00:00.0 9.6840 244
54 430.2118 2017-07-07 00:00:00.0 9.7959 244
55 440.1920 2017-07-08 00:00:00.0 9.9802 244
56 450.0685 2017-07-09 00:00:00.0 9.8765 244
57 460.0376 2017-07-10 00:00:00.0 9.9691 244
58 470.0364 2017-07-11 00:00:00.0 9.9988 244
59 478.9094 2017-07-12 00:00:00.0 8.8730 244
60 488.0931 2017-07-13 00:00:00.0 9.1837 244
61 498.0196 2017-07-14 00:00:00.0 9.9265 244
62 508.0191 2017-07-15 00:00:00.0 9.9995 244
63 517.9574 2017-07-16 00:00:00.0 9.9383 244
64 527.7796 2017-07-17 00:00:00.0 9.8222 244
65 537.5755 2017-07-18 00:00:00.0 9.7959 244
66 546.7592 2017-07-19 00:00:00.0 9.1837 244
67 556.6730 2017-07-20 00:00:00.0 9.9138 244
68 566.6619 2017-07-21 00:00:00.0 9.9889 244
69 576.4369 2017-07-22 00:00:00.0 9.7750 244
70 586.3956 2017-07-23 00:00:00.0 9.9587 244
71 596.3166 2017-07-24 00:00:00.0 9.9210 244
72 606.2968 2017-07-25 00:00:00.0 9.9802 244
73 616.2963 2017-07-26 00:00:00.0 9.9995 244
74 626.2654 2017-07-27 00:00:00.0 9.9691 244
75 635.8197 2017-07-28 00:00:00.0 9.5543 244
76 645.3259 2017-07-29 00:00:00.0 9.5062 244
77 653.8136 2017-07-30 00:00:00.0 8.4877 244
78 662.0309 2017-07-31 00:00:00.0 8.2173 244
79 672.0181 2017-08-01 00:00:00.0 9.9872 244
80 680.3604 2017-08-02 00:00:00.0 8.3423 244
81 689.5844 2017-08-03 00:00:00.0 9.2240 244
82 698.9946 2017-08-04 00:00:00.0 9.4102 244
83 708.3334 2017-08-05 00:00:00.0 9.3388 244
84 717.6722 2017-08-06 00:00:00.0 9.3388 244
85 727.4472 2017-08-07 00:00:00.0 9.7750 244
86 737.2819 2017-08-08 00:00:00.0 9.8347 244
87 746.5452 2017-08-09 00:00:00.0 9.2633 244
88 756.2753 2017-08-10 00:00:00.0 9.7301 244
89 765.7850 2017-08-11 00:00:00.0 9.5097 244
90 775.5600 2017-08-12 00:00:00.0 9.7750 244
91 785.4126 2017-08-13 00:00:00.0 9.8526 244
92 795.2652 2017-08-14 00:00:00.0 9.8526 244
93 805.0402 2017-08-15 00:00:00.0 9.7750 244
94 814.7933 2017-08-16 00:00:00.0 9.7531 244
95 824.4484 2017-08-17 00:00:00.0 9.6551 244
96 834.3749 2017-08-18 00:00:00.0 9.9265 244
97 844.3305 2017-08-19 00:00:00.0 9.9556 244
98 854.2157 2017-08-20 00:00:00.0 9.8852 244
99 862.4397 2017-08-21 00:00:00.0 8.2240 244
100 871.2642 2017-08-22 00:00:00.0 8.8245 244
101 877.4025 2017-08-23 00:00:00.0 6.1383 244
102 884.9734 2017-08-24 00:00:00.0 7.5709 244
103 894.4510 2017-08-25 00:00:00.0 9.4776 244
104 903.7898 2017-08-26 00:00:00.0 9.3388 244
105 913.5857 2017-08-27 00:00:00.0 9.7959 244
106 923.5808 2017-08-28 00:00:00.0 9.9951 244
107 933.2648 2017-08-29 00:00:00.0 9.6840 244
108 942.4071 2017-08-30 00:00:00.0 9.1423 244
109 951.9479 2017-08-31 00:00:00.0 9.5408 244
110 961.5188 2017-09-01 00:00:00.0 9.5709 244
111 971.1999 2017-09-02 00:00:00.0 9.6811 244
112 980.8810 2017-09-03 00:00:00.0 9.6811 244
113 989.6055 2017-09-04 00:00:00.0 8.7245 244
114 997.0336 2017-09-05 00:00:00.0 7.4281 244
115 1003.0826 2017-09-06 00:00:00.0 6.0490 244
116 1012.3459 2017-09-07 00:00:00.0 9.2633 244
117 1019.8459 2017-09-08 00:00:00.0 7.5000 244
118 1029.2209 2017-09-09 00:00:00.0 9.3750 244
119 1039.0715 2017-09-10 00:00:00.0 9.8506 244
120 1048.9715 2017-09-11 00:00:00.0 9.9000 244
121 1058.6937 2017-09-12 00:00:00.0 9.7222 244
122 1068.3218 2017-09-13 00:00:00.0 9.6281 244
123 1076.2320 2017-09-14 00:00:00.0 7.9102 244
124 1080.4993 2017-09-15 00:00:00.0 4.2673 244
125 1082.5274 2017-09-16 00:00:00.0 2.0281 244
126 1086.1274 2017-09-17 00:00:00.0 3.6000 244
127 1092.0861 2017-09-18 00:00:00.0 5.9587 244
128 1101.0529 2017-09-19 00:00:00.0 8.9668 244
129 1109.8279 2017-09-20 00:00:00.0 8.7750 244
130 1118.8845 2017-09-21 00:00:00.0 9.0566 244
131 1125.8595 2017-09-22 00:00:00.0 6.9750 244
132 1131.4467 2017-09-23 00:00:00.0 5.5872 244
133 1135.2732 2017-09-24 00:00:00.0 3.8265 244
134 1138.8732 2017-09-25 00:00:00.0 3.6000 244
135 1141.1543 2017-09-26 00:00:00.0 2.2811 244
136 1146.3538 2017-09-27 00:00:00.0 5.1995 244
137 1152.0354 2017-09-28 00:00:00.0 5.6816 244
138 1154.1905 2017-09-29 00:00:00.0 2.1551 244
139 1161.2436 2017-09-30 00:00:00.0 7.0531 244
140 1169.1538 2017-10-01 00:00:00.0 7.9102 244
141 1175.9696 2017-10-02 00:00:00.0 6.8158 244
142 1178.2507 2017-10-03 00:00:00.0 2.2811 244
143 1180.5318 2017-10-04 00:00:00.0 2.2811 244
144 1180.5318 2017-10-05 00:00:00.0 0.0000 244
145 1184.3583 2017-10-06 00:00:00.0 3.8265 244
146 1190.7583 2017-10-07 00:00:00.0 6.4000 244
147 1194.3583 2017-10-08 00:00:00.0 3.6000 244
148 1194.3583 2017-10-09 00:00:00.0 0.0000 244
149 1195.0598 2017-10-10 00:00:00.0 0.7015 244
150 1197.0879 2017-10-11 00:00:00.0 2.0281 244
151 1200.9144 2017-10-12 00:00:00.0 3.8265 244
152 1200.9144 2017-10-13 00:00:00.0 0.0000 244
153 1200.9144 2017-10-14 00:00:00.0 0.0000 244
154 1200.9144 2017-10-15 00:00:00.0 0.0000 244
155 1202.5552 2017-10-16 00:00:00.0 1.6408 244
156 1208.5139 2017-10-17 00:00:00.0 5.9587 244
157 1215.1665 2017-10-18 00:00:00.0 6.6526 244
158 1218.1823 2017-10-19 00:00:00.0 3.0158 244
159 1226.3456 2017-10-20 00:00:00.0 8.1633 244
160 1234.6879 2017-10-21 00:00:00.0 8.3423 244
161 1239.2751 2017-10-22 00:00:00.0 4.5872 244
162 1239.2751 2017-10-23 00:00:00.0 0.0000 244
163 1239.2751 2017-10-24 00:00:00.0 0.0000 244
164 1240.6527 2017-10-25 00:00:00.0 1.3776 244
165 1240.6527 2017-10-26 00:00:00.0 0.0000 244
166 1240.6527 2017-10-27 00:00:00.0 0.0000 244
167 1240.6527 2017-10-28 00:00:00.0 0.0000 244
168 1240.6527 2017-10-29 00:00:00.0 0.0000 244
169 1240.6527 2017-10-30 00:00:00.0 0.0000 244
170 1240.6527 2017-10-31 00:00:00.0 0.0000 244
171 1240.6527 2017-11-01 00:00:00.0 0.0000 244
172 1240.6527 2017-11-02 00:00:00.0 0.0000 244
173 1240.6527 2017-11-03 00:00:00.0 0.0000 244
174 1240.6527 2017-11-04 00:00:00.0 0.0000 244
175 1240.6527 2017-11-05 00:00:00.0 0.0000 244
176 1240.6527 2017-11-06 00:00:00.0 0.0000 244
177 1240.6527 2017-11-07 00:00:00.0 0.0000 244
178 1240.6527 2017-11-08 00:00:00.0 0.0000 244
179 1240.6527 2017-11-09 00:00:00.0 0.0000 244
180 1240.6527 2017-11-10 00:00:00.0 0.0000 244
181 1240.6527 2017-11-11 00:00:00.0 0.0000 244
182 1240.6527 2017-11-12 00:00:00.0 0.0000 244
183 1240.6527 2017-11-13 00:00:00.0 0.0000 244
184 1240.6527 2017-11-14 00:00:00.0 0.0000 244
185 1240.6527 2017-11-15 00:00:00.0 0.0000 244
186 1240.6527 2017-11-16 00:00:00.0 0.0000 244
187 1240.6527 2017-11-17 00:00:00.0 0.0000 244
188 1240.6527 2017-11-18 00:00:00.0 0.0000 244
189 1240.6527 2017-11-19 00:00:00.0 0.0000 244
190 1240.6527 2017-11-20 00:00:00.0 0.0000 244
191 1240.6527 2017-11-21 00:00:00.0 0.0000 244
192 1240.6527 2017-11-22 00:00:00.0 0.0000 244
193 1240.6527 2017-11-23 00:00:00.0 0.0000 244
194 1240.6527 2017-11-24 00:00:00.0 0.0000 244
195 1240.6527 2017-11-25 00:00:00.0 0.0000 244
196 1240.6527 2017-11-26 00:00:00.0 0.0000 244
197 1240.6527 2017-11-27 00:00:00.0 0.0000 244
198 1240.6527 2017-11-28 00:00:00.0 0.0000 244
199 1240.6527 2017-11-29 00:00:00.0 0.0000 244
200 1240.6527 2017-11-30 00:00:00.0 0.0000 244
201 1240.6527 2017-12-01 00:00:00.0 0.0000 244
202 1240.6527 2017-12-02 00:00:00.0 0.0000 244
203 1240.6527 2017-12-03 00:00:00.0 0.0000 244
204 1240.6527 2017-12-04 00:00:00.0 0.0000 244
205 1240.6527 2017-12-05 00:00:00.0 0.0000 244
206 1240.6527 2017-12-06 00:00:00.0 0.0000 244
207 1240.6527 2017-12-07 00:00:00.0 0.0000 244
208 1240.6527 2017-12-08 00:00:00.0 0.0000 244
209 1240.6527 2017-12-09 00:00:00.0 0.0000 244
210 1240.6527 2017-12-10 00:00:00.0 0.0000 244
211 1240.6527 2017-12-11 00:00:00.0 0.0000 244
212 1240.6527 2017-12-12 00:00:00.0 0.0000 244
213 1240.6527 2017-12-13 00:00:00.0 0.0000 244
214 1240.6527 2017-12-14 00:00:00.0 0.0000 244
215 1240.6527 2017-12-15 00:00:00.0 0.0000 244
216 1240.6527 2017-12-16 00:00:00.0 0.0000 244
217 1240.6527 2017-12-17 00:00:00.0 0.0000 244
218 1240.6527 2017-12-18 00:00:00.0 0.0000 244
219 1240.6527 2017-12-19 00:00:00.0 0.0000 244
220 1240.6527 2017-12-20 00:00:00.0 0.0000 244
221 1240.6527 2017-12-21 00:00:00.0 0.0000 244
CACHED false
EXECUTIONTIME 3
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '244') AND ddate < '2018-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total