Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Carberry North Wawanesa Glenboro Glenora Treherne 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


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
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '474') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/23/2017 10 445
7/22/2017 10 435
7/21/2017 10 425
7/20/2017 10 415
7/19/2017 9 405
7/18/2017 10 397
7/17/2017 10 387
7/16/2017 10 377
7/15/2017 10 367
7/14/2017 10 357
7/13/2017 9 347
7/12/2017 8 338
7/11/2017 10 330
7/10/2017 10 320
7/9/2017 10 310
7/8/2017 10 300
7/7/2017 10 290
7/6/2017 10 280
7/5/2017 9 271
7/4/2017 9 262
7/3/2017 10 253
7/2/2017 9 243
7/1/2017 9 234
6/30/2017 9 225
6/29/2017 9 216
6/28/2017 10 207
6/27/2017 10 197
6/26/2017 9 187
6/25/2017 6 178
6/24/2017 4 173
6/23/2017 7 168
6/22/2017 9 161
6/21/2017 9 152
6/20/2017 9 143
6/19/2017 8 134
6/18/2017 8 126
6/17/2017 8 118
6/16/2017 9 110
6/15/2017 9 101
6/14/2017 9 92
6/13/2017 9 83
6/12/2017 10 74
6/11/2017 10 65
6/10/2017 10 55
6/9/2017 10 45
6/8/2017 10 35
6/7/2017 10 26
6/6/2017 10 16
6/5/2017 6 6