Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Wawanesa Glenboro Glenora Treherne Holland Gladstone Portage East High Bluff Oakland Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk 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 8.0047 2026-06-01 00:00:00.0 8.0047 201
2 16.6701 2026-06-02 00:00:00.0 8.6654 201
3 24.2029 2026-06-03 00:00:00.0 7.5328 201
4 33.3247 2026-06-04 00:00:00.0 9.1218 201
5 41.7699 2026-06-05 00:00:00.0 8.4452 201
6 49.3817 2026-06-06 00:00:00.0 7.6118 201
7 56.1712 2026-06-07 00:00:00.0 6.7895 201
8 60.7902 2026-06-08 00:00:00.0 4.6190 201
9 69.1738 2026-06-09 00:00:00.0 8.3836 201
10 75.5429 2026-06-10 00:00:00.0 6.3691 201
11 84.8485 2026-06-11 00:00:00.0 9.3056 201
12 93.0565 2026-06-12 00:00:00.0 8.2080 201
13 99.5988 2026-06-13 00:00:00.0 6.5423 201
14 104.0974 2026-06-14 00:00:00.0 4.4986 201
15 109.9300 2026-06-15 00:00:00.0 5.8326 201
16 116.0833 2026-06-16 00:00:00.0 6.1533 201
17 122.4443 2026-06-17 00:00:00.0 6.3610 201
18 128.5993 2026-06-18 00:00:00.0 6.1550 201
19 134.9001 2026-06-19 00:00:00.0 6.3008 201
20 141.8108 2026-06-20 00:00:00.0 6.9107 201
21 147.2783 2026-06-21 00:00:00.0 5.4675 201
22 152.5344 2026-06-22 00:00:00.0 5.2561 201
23 160.0582 2026-06-23 00:00:00.0 7.5238 201
24 167.3967 2026-06-24 00:00:00.0 7.3385 201
25 175.7928 2026-06-25 00:00:00.0 8.3961 201
26 182.7330 2026-06-26 00:00:00.0 6.9402 201
27 191.1639 2026-06-27 00:00:00.0 8.4309 201
28 200.0713 2026-06-28 00:00:00.0 8.9074 201
29 209.1570 2026-06-29 00:00:00.0 9.0857 201
30 218.6242 2026-06-30 00:00:00.0 9.4672 201
31 227.8728 2026-07-01 00:00:00.0 9.2486 201
32 236.8830 2026-07-02 00:00:00.0 9.0102 201
33 245.2839 2026-07-03 00:00:00.0 8.4009 201
34 252.6896 2026-07-04 00:00:00.0 7.4057 201
35 260.8580 2026-07-05 00:00:00.0 8.1684 201
36 268.6115 2026-07-06 00:00:00.0 7.7535 201
37 277.7190 2026-07-07 00:00:00.0 9.1075 201
38 286.0796 2026-07-08 00:00:00.0 8.3606 201
39 294.4876 2026-07-09 00:00:00.0 8.4080 201
40 303.2882 2026-07-10 00:00:00.0 8.8006 201
41 311.9185 2026-07-11 00:00:00.0 8.6303 201
42 319.3307 2026-07-12 00:00:00.0 7.4122 201
43 324.9587 2026-07-13 00:00:00.0 5.6280 201
44 330.1248 2026-07-14 00:00:00.0 5.1661 201
45 339.2570 2026-07-15 00:00:00.0 9.1322 201
46 348.9700 2026-07-16 00:00:00.0 9.7130 201
47 358.3233 2026-07-17 00:00:00.0 9.3533 201
48 367.5493 2026-07-18 00:00:00.0 9.2260 201
49 375.6995 2026-07-19 00:00:00.0 8.1502 201
50 383.5560 2026-07-20 00:00:00.0 7.8565 201
51 392.5846 2026-07-21 00:00:00.0 9.0286 201
52 401.1245 2026-07-22 00:00:00.0 8.5399 201
53 409.5015 2026-07-23 00:00:00.0 8.3770 201
54 418.3452 2026-07-24 00:00:00.0 8.8437 201
55 426.2816 2026-07-25 00:00:00.0 7.9364 201
56 434.6973 2026-07-26 00:00:00.0 8.4157 201
57 443.1870 2026-07-27 00:00:00.0 8.4897 201
58 450.7267 2026-07-28 00:00:00.0 7.5397 201
59 458.5900 2026-07-29 00:00:00.0 7.8633 201
60 465.4536 2026-07-30 00:00:00.0 6.8636 201
61 474.0528 2026-07-31 00:00:00.0 8.5992 201
62 482.2249 2026-08-01 00:00:00.0 8.1721 201
63 491.3360 2026-08-02 00:00:00.0 9.1111 201
64 498.3342 2026-08-03 00:00:00.0 6.9982 201
65 506.5502 2026-08-04 00:00:00.0 8.2160 201
66 513.2518 2026-08-05 00:00:00.0 6.7016 201
67 521.0774 2026-08-06 00:00:00.0 7.8256 201
68 528.6563 2026-08-07 00:00:00.0 7.5789 201
69 536.1394 2026-08-08 00:00:00.0 7.4831 201
70 544.1933 2026-08-09 00:00:00.0 8.0539 201
71 550.1680 2026-08-10 00:00:00.0 5.9747 201
72 558.5986 2026-08-11 00:00:00.0 8.4306 201
73 565.9080 2026-08-12 00:00:00.0 7.3094 201
74 574.3690 2026-08-13 00:00:00.0 8.4610 201
75 582.3332 2026-08-14 00:00:00.0 7.9642 201
76 590.9159 2026-08-15 00:00:00.0 8.5827 201
77 599.9039 2026-08-16 00:00:00.0 8.9880 201
78 608.2989 2026-08-17 00:00:00.0 8.3950 201
79 616.0162 2026-08-18 00:00:00.0 7.7173 201
80 623.2421 2026-08-19 00:00:00.0 7.2259 201
81 629.9975 2026-08-20 00:00:00.0 6.7554 201
82 637.0133 2026-08-21 00:00:00.0 7.0158 201
83 645.6291 2026-08-22 00:00:00.0 8.6158 201
84 652.5295 2026-08-23 00:00:00.0 6.9004 201
85 660.1919 2026-08-24 00:00:00.0 7.6624 201
86 668.2065 2026-08-25 00:00:00.0 8.0146 201
87 677.4525 2026-08-26 00:00:00.0 9.2460 201
88 685.0954 2026-08-27 00:00:00.0 7.6429 201
89 691.9245 2026-08-28 00:00:00.0 6.8291 201
90 699.9328 2026-08-29 00:00:00.0 8.0083 201
91 708.4565 2026-08-30 00:00:00.0 8.5237 201
92 717.2924 2026-08-31 00:00:00.0 8.8359 201
93 726.3382 2026-09-01 00:00:00.0 9.0458 201
94 735.0499 2026-09-02 00:00:00.0 8.7117 201
95 743.5075 2026-09-03 00:00:00.0 8.4576 201
96 751.1118 2026-09-04 00:00:00.0 7.6043 201
97 759.2952 2026-09-05 00:00:00.0 8.1834 201
98 768.4997 2026-09-06 00:00:00.0 9.2045 201
99 777.1855 2026-09-07 00:00:00.0 8.6858 201
100 786.8301 2026-09-08 00:00:00.0 9.6446 201
101 795.9017 2026-09-09 00:00:00.0 9.0716 201
102 804.0722 2026-09-10 00:00:00.0 8.1705 201
103 811.6763 2026-09-11 00:00:00.0 7.6041 201
104 819.5145 2026-09-12 00:00:00.0 7.8382 201
105 824.1869 2026-09-13 00:00:00.0 4.6724 201
106 827.7407 2026-09-14 00:00:00.0 3.5538 201
107 830.6713 2026-09-15 00:00:00.0 2.9306 201
108 833.7672 2026-09-16 00:00:00.0 3.0959 201
109 836.4933 2026-09-17 00:00:00.0 2.7261 201
110 840.6605 2026-09-18 00:00:00.0 4.1672 201
111 847.1919 2026-09-19 00:00:00.0 6.5314 201
112 853.9778 2026-09-20 00:00:00.0 6.7859 201
113 856.8061 2026-09-21 00:00:00.0 2.8283 201
114 861.6904 2026-09-22 00:00:00.0 4.8843 201
115 866.6506 2026-09-23 00:00:00.0 4.9602 201
116 871.7671 2026-09-24 00:00:00.0 5.1165 201
117 880.5276 2026-09-25 00:00:00.0 8.7605 201
118 888.3444 2026-09-26 00:00:00.0 7.8168 201
119 897.2545 2026-09-27 00:00:00.0 8.9101 201
120 901.6395 2026-09-28 00:00:00.0 4.3850 201
121 905.6166 2026-09-29 00:00:00.0 3.9771 201
122 914.0227 2026-09-30 00:00:00.0 8.4061 201
123 919.3564 2026-10-01 00:00:00.0 5.3337 201
124 921.7308 2026-10-02 00:00:00.0 2.3744 201
125 924.9853 2026-10-03 00:00:00.0 3.2545 201
126 930.0505 2026-10-04 00:00:00.0 5.0652 201
127 932.8584 2026-10-05 00:00:00.0 2.8079 201
128 936.2514 2026-10-06 00:00:00.0 3.3930 201
129 942.2629 2026-10-07 00:00:00.0 6.0115 201
130 947.1331 2026-10-08 00:00:00.0 4.8702 201
131 949.8351 2026-10-09 00:00:00.0 2.7020 201
132 954.3312 2026-10-10 00:00:00.0 4.4961 201
133 961.5009 2026-10-11 00:00:00.0 7.1697 201
134 962.5957 2026-10-12 00:00:00.0 1.0948 201
135 962.5957 2026-10-13 00:00:00.0 0.0000 201
136 962.7176 2026-10-14 00:00:00.0 0.1219 201
137 963.4320 2026-10-15 00:00:00.0 0.7144 201
138 963.5876 2026-10-16 00:00:00.0 0.1556 201
139 964.0518 2026-10-17 00:00:00.0 0.4642 201
140 968.2601 2026-10-18 00:00:00.0 4.2083 201
141 971.6457 2026-10-19 00:00:00.0 3.3856 201
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '201') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-10-19'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/19/2026 3 972
10/18/2026 4 968
10/17/2026 0 964
10/16/2026 0 964
10/15/2026 1 963
10/14/2026 0 963
10/13/2026 0 963
10/12/2026 1 963
10/11/2026 7 962
10/10/2026 4 954
10/9/2026 3 950
10/8/2026 5 947
10/7/2026 6 942
10/6/2026 3 936
10/5/2026 3 933
10/4/2026 5 930
10/3/2026 3 925
10/2/2026 2 922
10/1/2026 5 919
9/30/2026 8 914
9/29/2026 4 906
9/28/2026 4 902
9/27/2026 9 897
9/26/2026 8 888
9/25/2026 9 881
9/24/2026 5 872
9/23/2026 5 867
9/22/2026 5 862
9/21/2026 3 857
9/20/2026 7 854
9/19/2026 7 847
9/18/2026 4 841
9/17/2026 3 836
9/16/2026 3 834
9/15/2026 3 831
9/14/2026 4 828
9/13/2026 5 824
9/12/2026 8 820
9/11/2026 8 812
9/10/2026 8 804
9/9/2026 9 796
9/8/2026 10 787
9/7/2026 9 777
9/6/2026 9 768
9/5/2026 8 759
9/4/2026 8 751
9/3/2026 8 744
9/2/2026 9 735
9/1/2026 9 726
8/31/2026 9 717
8/30/2026 9 708
8/29/2026 8 700
8/28/2026 7 692
8/27/2026 8 685
8/26/2026 9 677
8/25/2026 8 668
8/24/2026 8 660
8/23/2026 7 653
8/22/2026 9 646
8/21/2026 7 637
8/20/2026 7 630
8/19/2026 7 623
8/18/2026 8 616
8/17/2026 8 608
8/16/2026 9 600
8/15/2026 9 591
8/14/2026 8 582
8/13/2026 8 574
8/12/2026 7 566
8/11/2026 8 559
8/10/2026 6 550
8/9/2026 8 544
8/8/2026 7 536
8/7/2026 8 529
8/6/2026 8 521
8/5/2026 7 513
8/4/2026 8 507
8/3/2026 7 498
8/2/2026 9 491
8/1/2026 8 482
7/31/2026 9 474
7/30/2026 7 465
7/29/2026 8 459
7/28/2026 8 451
7/27/2026 8 443
7/26/2026 8 435
7/25/2026 8 426
7/24/2026 9 418
7/23/2026 8 410
7/22/2026 9 401
7/21/2026 9 393
7/20/2026 8 384
7/19/2026 8 376
7/18/2026 9 368
7/17/2026 9 358
7/16/2026 10 349
7/15/2026 9 339
7/14/2026 5 330
7/13/2026 6 325
7/12/2026 7 319
7/11/2026 9 312
7/10/2026 9 303
7/9/2026 8 294
7/8/2026 8 286
7/7/2026 9 278
7/6/2026 8 269
7/5/2026 8 261
7/4/2026 7 253
7/3/2026 8 245
7/2/2026 9 237
7/1/2026 9 228
6/30/2026 9 219
6/29/2026 9 209
6/28/2026 9 200
6/27/2026 8 191
6/26/2026 7 183
6/25/2026 8 176
6/24/2026 7 167
6/23/2026 8 160
6/22/2026 5 153
6/21/2026 5 147
6/20/2026 7 142
6/19/2026 6 135
6/18/2026 6 129
6/17/2026 6 122
6/16/2026 6 116
6/15/2026 6 110
6/14/2026 4 104
6/13/2026 7 100
6/12/2026 8 93
6/11/2026 9 85
6/10/2026 6 76
6/9/2026 8 69
6/8/2026 5 61
6/7/2026 7 56
6/6/2026 8 49
6/5/2026 8 42
6/4/2026 9 33
6/3/2026 8 24
6/2/2026 9 17
6/1/2026 8 8