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 7.7776 2017-05-15 00:00:00.0 7.7776 240
2 14.9837 2017-05-16 00:00:00.0 7.2061 240
3 15.1260 2017-05-17 00:00:00.0 0.1423 240
4 15.1260 2017-05-18 00:00:00.0 0.0000 240
5 18.2607 2017-05-19 00:00:00.0 3.1347 240
6 24.2194 2017-05-20 00:00:00.0 5.9587 240
7 28.0459 2017-05-21 00:00:00.0 3.8265 240
8 33.5377 2017-05-22 00:00:00.0 5.4918 240
9 40.8188 2017-05-23 00:00:00.0 7.2811 240
10 49.3856 2017-05-24 00:00:00.0 8.5668 240
11 56.5157 2017-05-25 00:00:00.0 7.1301 240
12 63.0009 2017-05-26 00:00:00.0 6.4852 240
13 70.0540 2017-05-27 00:00:00.0 7.0531 240
14 75.8290 2017-05-28 00:00:00.0 5.7750 240
15 79.6555 2017-05-29 00:00:00.0 3.8265 240
16 86.0555 2017-05-30 00:00:00.0 6.4000 240
17 95.2392 2017-05-31 00:00:00.0 9.1837 240
18 105.2194 2017-06-01 00:00:00.0 9.9802 240
19 113.7071 2017-06-02 00:00:00.0 8.4877 240
20 123.7066 2017-06-03 00:00:00.0 9.9995 240
21 133.5413 2017-06-04 00:00:00.0 9.8347 240
22 143.5163 2017-06-05 00:00:00.0 9.9750 240
23 153.2224 2017-06-06 00:00:00.0 9.7061 240
24 162.5974 2017-06-07 00:00:00.0 9.3750 240
25 172.3505 2017-06-08 00:00:00.0 9.7531 240
26 181.3173 2017-06-09 00:00:00.0 8.9668 240
27 190.9173 2017-06-10 00:00:00.0 9.6000 240
28 200.3949 2017-06-11 00:00:00.0 9.4776 240
29 209.3153 2017-06-12 00:00:00.0 8.9204 240
30 217.4168 2017-06-13 00:00:00.0 8.1015 240
31 225.8168 2017-06-14 00:00:00.0 8.4000 240
32 233.9801 2017-06-15 00:00:00.0 8.1633 240
33 242.5469 2017-06-16 00:00:00.0 8.5668 240
34 249.9750 2017-06-17 00:00:00.0 7.4281 240
35 257.5459 2017-06-18 00:00:00.0 7.5709 240
36 265.7699 2017-06-19 00:00:00.0 8.2240 240
37 274.2821 2017-06-20 00:00:00.0 8.5122 240
38 283.6923 2017-06-21 00:00:00.0 9.4102 240
39 291.8556 2017-06-22 00:00:00.0 8.1633 240
40 298.1694 2017-06-23 00:00:00.0 6.3138 240
41 302.3281 2017-06-24 00:00:00.0 4.1587 240
42 308.1954 2017-06-25 00:00:00.0 5.8673 240
43 316.5377 2017-06-26 00:00:00.0 8.3423 240
44 326.5357 2017-06-27 00:00:00.0 9.9980 240
45 336.5107 2017-06-28 00:00:00.0 9.9750 240
46 345.9209 2017-06-29 00:00:00.0 9.4102 240
47 354.4877 2017-06-30 00:00:00.0 8.5668 240
48 363.6714 2017-07-01 00:00:00.0 9.1837 240
49 372.3959 2017-07-02 00:00:00.0 8.7245 240
50 382.3848 2017-07-03 00:00:00.0 9.9889 240
51 391.4169 2017-07-04 00:00:00.0 9.0321 240
52 401.2391 2017-07-05 00:00:00.0 9.8222 240
53 411.2280 2017-07-06 00:00:00.0 9.9889 240
54 421.0030 2017-07-07 00:00:00.0 9.7750 240
55 430.9832 2017-07-08 00:00:00.0 9.9802 240
56 440.9388 2017-07-09 00:00:00.0 9.9556 240
57 450.6228 2017-07-10 00:00:00.0 9.6840 240
58 460.5611 2017-07-11 00:00:00.0 9.9383 240
59 469.4341 2017-07-12 00:00:00.0 8.8730 240
60 478.6178 2017-07-13 00:00:00.0 9.1837 240
61 488.5980 2017-07-14 00:00:00.0 9.9802 240
62 498.5730 2017-07-15 00:00:00.0 9.9750 240
63 508.5220 2017-07-16 00:00:00.0 9.9490 240
64 518.4615 2017-07-17 00:00:00.0 9.9395 240
65 527.6855 2017-07-18 00:00:00.0 9.2240 240
66 536.8692 2017-07-19 00:00:00.0 9.1837 240
67 546.6442 2017-07-20 00:00:00.0 9.7750 240
68 556.5580 2017-07-21 00:00:00.0 9.9138 240
69 566.0024 2017-07-22 00:00:00.0 9.4444 240
70 575.8550 2017-07-23 00:00:00.0 9.8526 240
71 585.4982 2017-07-24 00:00:00.0 9.6432 240
72 595.2732 2017-07-25 00:00:00.0 9.7750 240
73 605.2604 2017-07-26 00:00:00.0 9.9872 240
74 615.2295 2017-07-27 00:00:00.0 9.9691 240
75 624.9875 2017-07-28 00:00:00.0 9.7580 240
76 634.7097 2017-07-29 00:00:00.0 9.7222 240
77 643.6714 2017-07-30 00:00:00.0 8.9617 240
78 652.3270 2017-07-31 00:00:00.0 8.6556 240
79 662.1964 2017-08-01 00:00:00.0 9.8694 240
80 669.7673 2017-08-02 00:00:00.0 7.5709 240
81 678.8239 2017-08-03 00:00:00.0 9.0566 240
82 688.2341 2017-08-04 00:00:00.0 9.4102 240
83 697.5729 2017-08-05 00:00:00.0 9.3388 240
84 706.6729 2017-08-06 00:00:00.0 9.1000 240
85 716.4887 2017-08-07 00:00:00.0 9.8158 240
86 726.3739 2017-08-08 00:00:00.0 9.8852 240
87 734.8861 2017-08-09 00:00:00.0 8.5122 240
88 744.5142 2017-08-10 00:00:00.0 9.6281 240
89 754.2892 2017-08-11 00:00:00.0 9.7750 240
90 763.7336 2017-08-12 00:00:00.0 9.4444 240
91 773.4147 2017-08-13 00:00:00.0 9.6811 240
92 783.2494 2017-08-14 00:00:00.0 9.8347 240
93 792.5127 2017-08-15 00:00:00.0 9.2633 240
94 802.4877 2017-08-16 00:00:00.0 9.9750 240
95 811.9321 2017-08-17 00:00:00.0 9.4444 240
96 821.8459 2017-08-18 00:00:00.0 9.9138 240
97 831.8348 2017-08-19 00:00:00.0 9.9889 240
98 840.8470 2017-08-20 00:00:00.0 9.0122 240
99 849.6220 2017-08-21 00:00:00.0 8.7750 240
100 858.2424 2017-08-22 00:00:00.0 8.6204 240
101 865.5235 2017-08-23 00:00:00.0 7.2811 240
102 873.1643 2017-08-24 00:00:00.0 7.6408 240
103 882.9602 2017-08-25 00:00:00.0 9.7959 240
104 892.4699 2017-08-26 00:00:00.0 9.5097 240
105 902.0980 2017-08-27 00:00:00.0 9.6281 240
106 912.0980 2017-08-28 00:00:00.0 10.0000 240
107 922.0960 2017-08-29 00:00:00.0 9.9980 240
108 930.8205 2017-08-30 00:00:00.0 8.7245 240
109 940.6363 2017-08-31 00:00:00.0 9.8158 240
110 950.6358 2017-09-01 00:00:00.0 9.9995 240
111 960.2909 2017-09-02 00:00:00.0 9.6551 240
112 969.9460 2017-09-03 00:00:00.0 9.6551 240
113 978.1093 2017-09-04 00:00:00.0 8.1633 240
114 984.7619 2017-09-05 00:00:00.0 6.6526 240
115 994.6619 2017-09-06 00:00:00.0 9.9000 240
116 1003.4369 2017-09-07 00:00:00.0 8.7750 240
117 1010.5670 2017-09-08 00:00:00.0 7.1301 240
118 1020.1670 2017-09-09 00:00:00.0 9.6000 240
119 1030.0670 2017-09-10 00:00:00.0 9.9000 240
120 1039.6670 2017-09-11 00:00:00.0 9.6000 240
121 1049.6658 2017-09-12 00:00:00.0 9.9988 240
122 1058.0081 2017-09-13 00:00:00.0 8.3423 240
123 1063.7831 2017-09-14 00:00:00.0 5.7750 240
124 1066.6790 2017-09-15 00:00:00.0 2.8959 240
125 1067.7892 2017-09-16 00:00:00.0 1.1102 240
126 1069.8173 2017-09-17 00:00:00.0 2.0281 240
127 1075.0168 2017-09-18 00:00:00.0 5.1995 240
128 1082.1469 2017-09-19 00:00:00.0 7.1301 240
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '240') 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 7 1082
9/18/2017 5 1075
9/17/2017 2 1070
9/16/2017 1 1068
9/15/2017 3 1067
9/14/2017 6 1064
9/13/2017 8 1058
9/12/2017 10 1050
9/11/2017 10 1040
9/10/2017 10 1030
9/9/2017 10 1020
9/8/2017 7 1011
9/7/2017 9 1003
9/6/2017 10 995
9/5/2017 7 985
9/4/2017 8 978
9/3/2017 10 970
9/2/2017 10 960
9/1/2017 10 951
8/31/2017 10 941
8/30/2017 9 931
8/29/2017 10 922
8/28/2017 10 912
8/27/2017 10 902
8/26/2017 10 892
8/25/2017 10 883
8/24/2017 8 873
8/23/2017 7 866
8/22/2017 9 858
8/21/2017 9 850
8/20/2017 9 841
8/19/2017 10 832
8/18/2017 10 822
8/17/2017 9 812
8/16/2017 10 802
8/15/2017 9 793
8/14/2017 10 783
8/13/2017 10 773
8/12/2017 9 764
8/11/2017 10 754
8/10/2017 10 745
8/9/2017 9 735
8/8/2017 10 726
8/7/2017 10 716
8/6/2017 9 707
8/5/2017 9 698
8/4/2017 9 688
8/3/2017 9 679
8/2/2017 8 670
8/1/2017 10 662
7/31/2017 9 652
7/30/2017 9 644
7/29/2017 10 635
7/28/2017 10 625
7/27/2017 10 615
7/26/2017 10 605
7/25/2017 10 595
7/24/2017 10 585
7/23/2017 10 576
7/22/2017 9 566
7/21/2017 10 557
7/20/2017 10 547
7/19/2017 9 537
7/18/2017 9 528
7/17/2017 10 518
7/16/2017 10 509
7/15/2017 10 499
7/14/2017 10 489
7/13/2017 9 479
7/12/2017 9 469
7/11/2017 10 461
7/10/2017 10 451
7/9/2017 10 441
7/8/2017 10 431
7/7/2017 10 421
7/6/2017 10 411
7/5/2017 10 401
7/4/2017 9 391
7/3/2017 10 382
7/2/2017 9 372
7/1/2017 9 364
6/30/2017 9 354
6/29/2017 9 346
6/28/2017 10 337
6/27/2017 10 327
6/26/2017 8 317
6/25/2017 6 308
6/24/2017 4 302
6/23/2017 6 298
6/22/2017 8 292
6/21/2017 9 284
6/20/2017 9 274
6/19/2017 8 266
6/18/2017 8 258
6/17/2017 7 250
6/16/2017 9 243
6/15/2017 8 234
6/14/2017 8 226
6/13/2017 8 217
6/12/2017 9 209
6/11/2017 9 200
6/10/2017 10 191
6/9/2017 9 181
6/8/2017 10 172
6/7/2017 9 163
6/6/2017 10 153
6/5/2017 10 144
6/4/2017 10 134
6/3/2017 10 124
6/2/2017 8 114
6/1/2017 10 105
5/31/2017 9 95
5/30/2017 6 86
5/29/2017 4 80
5/28/2017 6 76
5/27/2017 7 70
5/26/2017 6 63
5/25/2017 7 57
5/24/2017 9 49
5/23/2017 7 41
5/22/2017 5 34
5/21/2017 4 28
5/20/2017 6 24
5/19/2017 3 18
5/18/2017 0 15
5/17/2017 0 15
5/16/2017 7 15
5/15/2017 8 8