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 9.0566 2017-05-15 00:00:00.0 9.0566 210
2 16.2627 2017-05-16 00:00:00.0 7.2061 210
3 16.9642 2017-05-17 00:00:00.0 0.7015 210
4 16.9642 2017-05-18 00:00:00.0 0.0000 210
5 21.6560 2017-05-19 00:00:00.0 4.6918 210
6 28.3907 2017-05-20 00:00:00.0 6.7347 210
7 30.6718 2017-05-21 00:00:00.0 2.2811 210
8 33.4468 2017-05-22 00:00:00.0 2.7750 210
9 40.4218 2017-05-23 00:00:00.0 6.9750 210
10 48.5233 2017-05-24 00:00:00.0 8.1015 210
11 56.7473 2017-05-25 00:00:00.0 8.2240 210
12 65.4718 2017-05-26 00:00:00.0 8.7245 210
13 73.9284 2017-05-27 00:00:00.0 8.4566 210
14 78.6202 2017-05-28 00:00:00.0 4.6918 210
15 79.5952 2017-05-29 00:00:00.0 0.9750 210
16 84.9906 2017-05-30 00:00:00.0 5.3954 210
17 93.1539 2017-05-31 00:00:00.0 8.1633 210
18 103.1411 2017-06-01 00:00:00.0 9.9872 210
19 111.3584 2017-06-02 00:00:00.0 8.2173 210
20 121.2794 2017-06-03 00:00:00.0 9.9210 210
21 131.1488 2017-06-04 00:00:00.0 9.8694 210
22 141.1044 2017-06-05 00:00:00.0 9.9556 210
23 150.5069 2017-06-06 00:00:00.0 9.4025 210
24 160.2130 2017-06-07 00:00:00.0 9.7061 210
25 170.1395 2017-06-08 00:00:00.0 9.9265 210
26 180.1145 2017-06-09 00:00:00.0 9.9750 210
27 189.9303 2017-06-10 00:00:00.0 9.8158 210
28 199.7461 2017-06-11 00:00:00.0 9.8158 210
29 208.8027 2017-06-12 00:00:00.0 9.0566 210
30 218.3736 2017-06-13 00:00:00.0 9.5709 210
31 227.8180 2017-06-14 00:00:00.0 9.4444 210
32 236.1603 2017-06-15 00:00:00.0 8.3423 210
33 244.1353 2017-06-16 00:00:00.0 7.9750 210
34 251.0312 2017-06-17 00:00:00.0 6.8959 210
35 258.4593 2017-06-18 00:00:00.0 7.4281 210
36 266.2369 2017-06-19 00:00:00.0 7.7776 210
37 275.3369 2017-06-20 00:00:00.0 9.1000 210
38 283.5002 2017-06-21 00:00:00.0 8.1633 210
39 291.6635 2017-06-22 00:00:00.0 8.1633 210
40 298.3161 2017-06-23 00:00:00.0 6.6526 210
41 303.0079 2017-06-24 00:00:00.0 4.6918 210
42 308.9666 2017-06-25 00:00:00.0 5.9587 210
43 317.8396 2017-06-26 00:00:00.0 8.8730 210
44 327.4947 2017-06-27 00:00:00.0 9.6551 210
45 337.0355 2017-06-28 00:00:00.0 9.5408 210
46 346.6064 2017-06-29 00:00:00.0 9.5709 210
47 355.5268 2017-06-30 00:00:00.0 8.9204 210
48 363.8691 2017-07-01 00:00:00.0 8.3423 210
49 372.8359 2017-07-02 00:00:00.0 8.9668 210
50 382.7211 2017-07-03 00:00:00.0 9.8852 210
51 392.6606 2017-07-04 00:00:00.0 9.9395 210
52 402.5371 2017-07-05 00:00:00.0 9.8765 210
53 412.5243 2017-07-06 00:00:00.0 9.9872 210
54 422.2993 2017-07-07 00:00:00.0 9.7750 210
55 432.2580 2017-07-08 00:00:00.0 9.9587 210
56 442.1718 2017-07-09 00:00:00.0 9.9138 210
57 452.1391 2017-07-10 00:00:00.0 9.9673 210
58 461.0595 2017-07-11 00:00:00.0 8.9204 210
59 469.9325 2017-07-12 00:00:00.0 8.8730 210
60 479.2340 2017-07-13 00:00:00.0 9.3015 210
61 489.0866 2017-07-14 00:00:00.0 9.8526 210
62 498.9560 2017-07-15 00:00:00.0 9.8694 210
63 508.7519 2017-07-16 00:00:00.0 9.7959 210
64 518.5099 2017-07-17 00:00:00.0 9.7580 210
65 527.9201 2017-07-18 00:00:00.0 9.4102 210
66 537.2589 2017-07-19 00:00:00.0 9.3388 210
67 546.9140 2017-07-20 00:00:00.0 9.6551 210
68 556.3916 2017-07-21 00:00:00.0 9.4776 210
69 565.9013 2017-07-22 00:00:00.0 9.5097 210
70 575.8396 2017-07-23 00:00:00.0 9.9383 210
71 585.8198 2017-07-24 00:00:00.0 9.9802 210
72 595.8152 2017-07-25 00:00:00.0 9.9954 210
73 605.8106 2017-07-26 00:00:00.0 9.9954 210
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '210') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/26/2017 10 606
7/25/2017 10 596
7/24/2017 10 586
7/23/2017 10 576
7/22/2017 10 566
7/21/2017 9 556
7/20/2017 10 547
7/19/2017 9 537
7/18/2017 9 528
7/17/2017 10 519
7/16/2017 10 509
7/15/2017 10 499
7/14/2017 10 489
7/13/2017 9 479
7/12/2017 9 470
7/11/2017 9 461
7/10/2017 10 452
7/9/2017 10 442
7/8/2017 10 432
7/7/2017 10 422
7/6/2017 10 413
7/5/2017 10 403
7/4/2017 10 393
7/3/2017 10 383
7/2/2017 9 373
7/1/2017 8 364
6/30/2017 9 356
6/29/2017 10 347
6/28/2017 10 337
6/27/2017 10 327
6/26/2017 9 318
6/25/2017 6 309
6/24/2017 5 303
6/23/2017 7 298
6/22/2017 8 292
6/21/2017 8 284
6/20/2017 9 275
6/19/2017 8 266
6/18/2017 7 258
6/17/2017 7 251
6/16/2017 8 244
6/15/2017 8 236
6/14/2017 9 228
6/13/2017 10 218
6/12/2017 9 209
6/11/2017 10 200
6/10/2017 10 190
6/9/2017 10 180
6/8/2017 10 170
6/7/2017 10 160
6/6/2017 9 151
6/5/2017 10 141
6/4/2017 10 131
6/3/2017 10 121
6/2/2017 8 111
6/1/2017 10 103
5/31/2017 8 93
5/30/2017 5 85
5/29/2017 1 80
5/28/2017 5 79
5/27/2017 8 74
5/26/2017 9 65
5/25/2017 8 57
5/24/2017 8 49
5/23/2017 7 40
5/22/2017 3 33
5/21/2017 2 31
5/20/2017 7 28
5/19/2017 5 22
5/18/2017 0 17
5/17/2017 1 17
5/16/2017 7 16
5/15/2017 9 9