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
74 615.7797 2017-07-27 00:00:00.0 9.9691 210
75 625.5711 2017-07-28 00:00:00.0 9.7914 210
76 634.8600 2017-07-29 00:00:00.0 9.2889 210
77 643.5958 2017-07-30 00:00:00.0 8.7358 210
78 652.4094 2017-07-31 00:00:00.0 8.8136 210
79 662.2441 2017-08-01 00:00:00.0 9.8347 210
80 670.8645 2017-08-02 00:00:00.0 8.6204 210
81 680.0482 2017-08-03 00:00:00.0 9.1837 210
82 689.1482 2017-08-04 00:00:00.0 9.1000 210
83 698.2482 2017-08-05 00:00:00.0 9.1000 210
84 707.7258 2017-08-06 00:00:00.0 9.4776 210
85 717.5217 2017-08-07 00:00:00.0 9.7959 210
86 726.9661 2017-08-08 00:00:00.0 9.4444 210
87 735.8391 2017-08-09 00:00:00.0 8.8730 210
88 745.0631 2017-08-10 00:00:00.0 9.2240 210
89 754.4733 2017-08-11 00:00:00.0 9.4102 210
90 764.1284 2017-08-12 00:00:00.0 9.6551 210
91 773.9034 2017-08-13 00:00:00.0 9.7750 210
92 783.7886 2017-08-14 00:00:00.0 9.8852 210
93 793.6233 2017-08-15 00:00:00.0 9.8347 210
94 803.3294 2017-08-16 00:00:00.0 9.7061 210
95 812.8070 2017-08-17 00:00:00.0 9.4776 210
96 822.6029 2017-08-18 00:00:00.0 9.7959 210
97 832.6029 2017-08-19 00:00:00.0 10.0000 210
98 842.4723 2017-08-20 00:00:00.0 9.8694 210
99 849.8274 2017-08-21 00:00:00.0 7.3551 210
100 857.3274 2017-08-22 00:00:00.0 7.5000 210
101 861.8090 2017-08-23 00:00:00.0 4.4816 210
102 867.8580 2017-08-24 00:00:00.0 6.0490 210
103 877.0003 2017-08-25 00:00:00.0 9.1423 210
104 885.7248 2017-08-26 00:00:00.0 8.7245 210
105 895.4059 2017-08-27 00:00:00.0 9.6811 210
106 905.3977 2017-08-28 00:00:00.0 9.9918 210
107 915.3957 2017-08-29 00:00:00.0 9.9980 210
108 924.0161 2017-08-30 00:00:00.0 8.6204 210
109 933.5870 2017-08-31 00:00:00.0 9.5709 210
110 943.0646 2017-09-01 00:00:00.0 9.4776 210
111 952.5090 2017-09-02 00:00:00.0 9.4444 210
112 961.0758 2017-09-03 00:00:00.0 8.5668 210
113 968.7166 2017-09-04 00:00:00.0 7.6408 210
114 975.1166 2017-09-05 00:00:00.0 6.4000 210
115 980.7038 2017-09-06 00:00:00.0 5.5872 210
116 989.2160 2017-09-07 00:00:00.0 8.5122 210
117 996.8568 2017-09-08 00:00:00.0 7.6408 210
118 1006.3976 2017-09-09 00:00:00.0 9.5408 210
119 1016.1198 2017-09-10 00:00:00.0 9.7222 210
120 1025.9356 2017-09-11 00:00:00.0 9.8158 210
121 1035.8912 2017-09-12 00:00:00.0 9.9556 210
122 1044.9478 2017-09-13 00:00:00.0 9.0566 210
123 1051.1743 2017-09-14 00:00:00.0 6.2265 210
124 1054.8881 2017-09-15 00:00:00.0 3.7138 210
125 1055.9983 2017-09-16 00:00:00.0 1.1102 210
126 1059.0141 2017-09-17 00:00:00.0 3.0158 210
127 1065.4993 2017-09-18 00:00:00.0 6.4852 210
128 1074.0661 2017-09-19 00:00:00.0 8.5668 210
CACHED false
EXECUTIONTIME 2
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
9/19/2017 9 1074
9/18/2017 6 1065
9/17/2017 3 1059
9/16/2017 1 1056
9/15/2017 4 1055
9/14/2017 6 1051
9/13/2017 9 1045
9/12/2017 10 1036
9/11/2017 10 1026
9/10/2017 10 1016
9/9/2017 10 1006
9/8/2017 8 997
9/7/2017 9 989
9/6/2017 6 981
9/5/2017 6 975
9/4/2017 8 969
9/3/2017 9 961
9/2/2017 9 953
9/1/2017 9 943
8/31/2017 10 934
8/30/2017 9 924
8/29/2017 10 915
8/28/2017 10 905
8/27/2017 10 895
8/26/2017 9 886
8/25/2017 9 877
8/24/2017 6 868
8/23/2017 4 862
8/22/2017 8 857
8/21/2017 7 850
8/20/2017 10 842
8/19/2017 10 833
8/18/2017 10 823
8/17/2017 9 813
8/16/2017 10 803
8/15/2017 10 794
8/14/2017 10 784
8/13/2017 10 774
8/12/2017 10 764
8/11/2017 9 754
8/10/2017 9 745
8/9/2017 9 736
8/8/2017 9 727
8/7/2017 10 718
8/6/2017 9 708
8/5/2017 9 698
8/4/2017 9 689
8/3/2017 9 680
8/2/2017 9 671
8/1/2017 10 662
7/31/2017 9 652
7/30/2017 9 644
7/29/2017 9 635
7/28/2017 10 626
7/27/2017 10 616
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