WIN

mbpotatoes.ca

simplot MAFRI

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 7.8272 2026-06-01 00:00:00.0 7.8272 243
2 16.5863 2026-06-02 00:00:00.0 8.7591 243
3 24.7488 2026-06-03 00:00:00.0 8.1625 243
4 34.2989 2026-06-04 00:00:00.0 9.5501 243
5 43.1955 2026-06-05 00:00:00.0 8.8966 243
6 51.0337 2026-06-06 00:00:00.0 7.8382 243
7 58.0782 2026-06-07 00:00:00.0 7.0445 243
8 62.9645 2026-06-08 00:00:00.0 4.8863 243
9 71.5961 2026-06-09 00:00:00.0 8.6316 243
10 78.6710 2026-06-10 00:00:00.0 7.0749 243
11 88.0916 2026-06-11 00:00:00.0 9.4206 243
12 96.7727 2026-06-12 00:00:00.0 8.6811 243
13 103.9009 2026-06-13 00:00:00.0 7.1282 243
14 108.6437 2026-06-14 00:00:00.0 4.7428 243
15 114.6438 2026-06-15 00:00:00.0 6.0001 243
16 121.1450 2026-06-16 00:00:00.0 6.5012 243
17 127.3271 2026-06-17 00:00:00.0 6.1821 243
18 134.9947 2026-06-18 00:00:00.0 7.6676 243
19 140.4786 2026-06-19 00:00:00.0 5.4839 243
20 148.4495 2026-06-20 00:00:00.0 7.9709 243
21 154.9768 2026-06-21 00:00:00.0 6.5273 243
22 160.5407 2026-06-22 00:00:00.0 5.5639 243
23 168.7888 2026-06-23 00:00:00.0 8.2481 243
24 176.8667 2026-06-24 00:00:00.0 8.0779 243
25 185.6933 2026-06-25 00:00:00.0 8.8266 243
26 193.5256 2026-06-26 00:00:00.0 7.8323 243
27 201.7758 2026-06-27 00:00:00.0 8.2502 243
28 211.1227 2026-06-28 00:00:00.0 9.3469 243
29 220.3169 2026-06-29 00:00:00.0 9.1942 243
30 229.4814 2026-06-30 00:00:00.0 9.1645 243
31 238.6661 2026-07-01 00:00:00.0 9.1847 243
32 248.0174 2026-07-02 00:00:00.0 9.3513 243
33 256.8844 2026-07-03 00:00:00.0 8.8670 243
34 266.0296 2026-07-04 00:00:00.0 9.1452 243
35 274.6177 2026-07-05 00:00:00.0 8.5881 243
36 281.6025 2026-07-06 00:00:00.0 6.9848 243
37 290.3335 2026-07-07 00:00:00.0 8.7310 243
38 299.3237 2026-07-08 00:00:00.0 8.9902 243
39 307.6385 2026-07-09 00:00:00.0 8.3148 243
40 316.1033 2026-07-10 00:00:00.0 8.4648 243
41 323.7366 2026-07-11 00:00:00.0 7.6333 243
42 329.7445 2026-07-12 00:00:00.0 6.0079 243
43 333.7348 2026-07-13 00:00:00.0 3.9903 243
44 338.1373 2026-07-14 00:00:00.0 4.4025 243
45 346.7952 2026-07-15 00:00:00.0 8.6579 243
46 356.6557 2026-07-16 00:00:00.0 9.8605 243
47 366.2534 2026-07-17 00:00:00.0 9.5977 243
48 375.5159 2026-07-18 00:00:00.0 9.2625 243
49 383.1312 2026-07-19 00:00:00.0 7.6153 243
50 390.0799 2026-07-20 00:00:00.0 6.9487 243
51 399.2855 2026-07-21 00:00:00.0 9.2056 243
52 407.2389 2026-07-22 00:00:00.0 7.9534 243
53 414.8145 2026-07-23 00:00:00.0 7.5756 243
54 423.2233 2026-07-24 00:00:00.0 8.4088 243
55 431.4112 2026-07-25 00:00:00.0 8.1879 243
56 439.4673 2026-07-26 00:00:00.0 8.0561 243
57 447.9937 2026-07-27 00:00:00.0 8.5264 243
58 456.1926 2026-07-28 00:00:00.0 8.1989 243
59 463.8128 2026-07-29 00:00:00.0 7.6202 243
60 469.3027 2026-07-30 00:00:00.0 5.4899 243
61 476.7145 2026-07-31 00:00:00.0 7.4118 243
62 485.0153 2026-08-01 00:00:00.0 8.3008 243
63 493.5583 2026-08-02 00:00:00.0 8.5430 243
64 500.7315 2026-08-03 00:00:00.0 7.1732 243
65 509.4071 2026-08-04 00:00:00.0 8.6756 243
66 516.4894 2026-08-05 00:00:00.0 7.0823 243
67 523.2386 2026-08-06 00:00:00.0 6.7492 243
68 530.8785 2026-08-07 00:00:00.0 7.6399 243
69 538.5991 2026-08-08 00:00:00.0 7.7206 243
70 544.7744 2026-08-09 00:00:00.0 6.1753 243
71 550.9943 2026-08-10 00:00:00.0 6.2199 243
72 558.5587 2026-08-11 00:00:00.0 7.5644 243
73 566.0701 2026-08-12 00:00:00.0 7.5114 243
74 574.5143 2026-08-13 00:00:00.0 8.4442 243
75 582.5584 2026-08-14 00:00:00.0 8.0441 243
76 591.3369 2026-08-15 00:00:00.0 8.7785 243
77 600.9220 2026-08-16 00:00:00.0 9.5851 243
78 609.1422 2026-08-17 00:00:00.0 8.2202 243
79 617.2025 2026-08-18 00:00:00.0 8.0603 243
80 623.1920 2026-08-19 00:00:00.0 5.9895 243
81 629.7328 2026-08-20 00:00:00.0 6.5408 243
82 638.7365 2026-08-21 00:00:00.0 9.0037 243
83 646.7434 2026-08-22 00:00:00.0 8.0069 243
84 653.7888 2026-08-23 00:00:00.0 7.0454 243
85 661.5227 2026-08-24 00:00:00.0 7.7339 243
86 670.5282 2026-08-25 00:00:00.0 9.0055 243
87 679.5459 2026-08-26 00:00:00.0 9.0177 243
88 687.7677 2026-08-27 00:00:00.0 8.2218 243
89 694.0186 2026-08-28 00:00:00.0 6.2509 243
90 701.6661 2026-08-29 00:00:00.0 7.6475 243
91 709.9894 2026-08-30 00:00:00.0 8.3233 243
92 718.7122 2026-08-31 00:00:00.0 8.7228 243
93 727.2987 2026-09-01 00:00:00.0 8.5865 243
94 735.6748 2026-09-02 00:00:00.0 8.3761 243
95 743.5563 2026-09-03 00:00:00.0 7.8815 243
96 752.7075 2026-09-04 00:00:00.0 9.1512 243
97 761.4203 2026-09-05 00:00:00.0 8.7128 243
98 770.1299 2026-09-06 00:00:00.0 8.7096 243
99 778.8765 2026-09-07 00:00:00.0 8.7466 243
100 788.5309 2026-09-08 00:00:00.0 9.6544 243
101 797.5571 2026-09-09 00:00:00.0 9.0262 243
102 805.8172 2026-09-10 00:00:00.0 8.2601 243
103 812.7596 2026-09-11 00:00:00.0 6.9424 243
104 821.1780 2026-09-12 00:00:00.0 8.4184 243
105 824.8360 2026-09-13 00:00:00.0 3.6580 243
106 828.4980 2026-09-14 00:00:00.0 3.6620 243
107 831.3209 2026-09-15 00:00:00.0 2.8229 243
108 835.9878 2026-09-16 00:00:00.0 4.6669 243
109 838.6831 2026-09-17 00:00:00.0 2.6953 243
110 842.5877 2026-09-18 00:00:00.0 3.9046 243
111 848.3091 2026-09-19 00:00:00.0 5.7214 243
112 856.0889 2026-09-20 00:00:00.0 7.7798 243
113 860.5458 2026-09-21 00:00:00.0 4.4569 243
114 865.6985 2026-09-22 00:00:00.0 5.1527 243
115 870.8833 2026-09-23 00:00:00.0 5.1848 243
116 877.2817 2026-09-24 00:00:00.0 6.3984 243
117 885.6763 2026-09-25 00:00:00.0 8.3946 243
118 894.3360 2026-09-26 00:00:00.0 8.6597 243
119 903.0054 2026-09-27 00:00:00.0 8.6694 243
120 908.4284 2026-09-28 00:00:00.0 5.4230 243
121 912.0453 2026-09-29 00:00:00.0 3.6169 243
122 920.9234 2026-09-30 00:00:00.0 8.8781 243
123 924.9797 2026-10-01 00:00:00.0 4.0563 243
124 926.8666 2026-10-02 00:00:00.0 1.8869 243
125 929.8752 2026-10-03 00:00:00.0 3.0086 243
126 934.6098 2026-10-04 00:00:00.0 4.7346 243
127 937.6096 2026-10-05 00:00:00.0 2.9998 243
128 940.9273 2026-10-06 00:00:00.0 3.3177 243
129 945.7298 2026-10-07 00:00:00.0 4.8025 243
130 949.6245 2026-10-08 00:00:00.0 3.8947 243
131 952.5493 2026-10-09 00:00:00.0 2.9248 243
132 955.8573 2026-10-10 00:00:00.0 3.3080 243
133 964.2270 2026-10-11 00:00:00.0 8.3697 243
134 966.6881 2026-10-12 00:00:00.0 2.4611 243
135 966.6881 2026-10-13 00:00:00.0 0.0000 243
136 966.9892 2026-10-14 00:00:00.0 0.3011 243
137 967.8402 2026-10-15 00:00:00.0 0.8510 243
138 968.5269 2026-10-16 00:00:00.0 0.6867 243
139 968.9769 2026-10-17 00:00:00.0 0.4500 243
140 971.5340 2026-10-18 00:00:00.0 2.5571 243
141 974.1547 2026-10-19 00:00:00.0 2.6207 243
142 976.4511 2026-10-20 00:00:00.0 2.2964 243
143 981.0685 2026-10-21 00:00:00.0 4.6174 243
144 983.5444 2026-10-22 00:00:00.0 2.4759 243
145 988.1612 2026-10-23 00:00:00.0 4.6168 243
146 996.6042 2026-10-24 00:00:00.0 8.4430 243
147 1000.5449 2026-10-25 00:00:00.0 3.9407 243
148 1000.5449 2026-10-26 00:00:00.0 0.0000 243
149 1000.5449 2026-10-27 00:00:00.0 0.0000 243
150 1000.5449 2026-10-28 00:00:00.0 0.0000 243
151 1001.6437 2026-10-29 00:00:00.0 1.0988 243
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '243') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-10-29'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/29/2026 1 1002
10/28/2026 0 1001
10/27/2026 0 1001
10/26/2026 0 1001
10/25/2026 4 1001
10/24/2026 8 997
10/23/2026 5 988
10/22/2026 2 984
10/21/2026 5 981
10/20/2026 2 976
10/19/2026 3 974
10/18/2026 3 972
10/17/2026 0 969
10/16/2026 1 969
10/15/2026 1 968
10/14/2026 0 967
10/13/2026 0 967
10/12/2026 2 967
10/11/2026 8 964
10/10/2026 3 956
10/9/2026 3 953
10/8/2026 4 950
10/7/2026 5 946
10/6/2026 3 941
10/5/2026 3 938
10/4/2026 5 935
10/3/2026 3 930
10/2/2026 2 927
10/1/2026 4 925
9/30/2026 9 921
9/29/2026 4 912
9/28/2026 5 908
9/27/2026 9 903
9/26/2026 9 894
9/25/2026 8 886
9/24/2026 6 877
9/23/2026 5 871
9/22/2026 5 866
9/21/2026 4 861
9/20/2026 8 856
9/19/2026 6 848
9/18/2026 4 843
9/17/2026 3 839
9/16/2026 5 836
9/15/2026 3 831
9/14/2026 4 828
9/13/2026 4 825
9/12/2026 8 821
9/11/2026 7 813
9/10/2026 8 806
9/9/2026 9 798
9/8/2026 10 789
9/7/2026 9 779
9/6/2026 9 770
9/5/2026 9 761
9/4/2026 9 753
9/3/2026 8 744
9/2/2026 8 736
9/1/2026 9 727
8/31/2026 9 719
8/30/2026 8 710
8/29/2026 8 702
8/28/2026 6 694
8/27/2026 8 688
8/26/2026 9 680
8/25/2026 9 671
8/24/2026 8 662
8/23/2026 7 654
8/22/2026 8 647
8/21/2026 9 639
8/20/2026 7 630
8/19/2026 6 623
8/18/2026 8 617
8/17/2026 8 609
8/16/2026 10 601
8/15/2026 9 591
8/14/2026 8 583
8/13/2026 8 575
8/12/2026 8 566
8/11/2026 8 559
8/10/2026 6 551
8/9/2026 6 545
8/8/2026 8 539
8/7/2026 8 531
8/6/2026 7 523
8/5/2026 7 516
8/4/2026 9 509
8/3/2026 7 501
8/2/2026 9 494
8/1/2026 8 485
7/31/2026 7 477
7/30/2026 5 469
7/29/2026 8 464
7/28/2026 8 456
7/27/2026 9 448
7/26/2026 8 439
7/25/2026 8 431
7/24/2026 8 423
7/23/2026 8 415
7/22/2026 8 407
7/21/2026 9 399
7/20/2026 7 390
7/19/2026 8 383
7/18/2026 9 376
7/17/2026 10 366
7/16/2026 10 357
7/15/2026 9 347
7/14/2026 4 338
7/13/2026 4 334
7/12/2026 6 330
7/11/2026 8 324
7/10/2026 8 316
7/9/2026 8 308
7/8/2026 9 299
7/7/2026 9 290
7/6/2026 7 282
7/5/2026 9 275
7/4/2026 9 266
7/3/2026 9 257
7/2/2026 9 248
7/1/2026 9 239
6/30/2026 9 229
6/29/2026 9 220
6/28/2026 9 211
6/27/2026 8 202
6/26/2026 8 194
6/25/2026 9 186
6/24/2026 8 177
6/23/2026 8 169
6/22/2026 6 161
6/21/2026 7 155
6/20/2026 8 148
6/19/2026 5 140
6/18/2026 8 135
6/17/2026 6 127
6/16/2026 7 121
6/15/2026 6 115
6/14/2026 5 109
6/13/2026 7 104
6/12/2026 9 97
6/11/2026 9 88
6/10/2026 7 79
6/9/2026 9 72
6/8/2026 5 63
6/7/2026 7 58
6/6/2026 8 51
6/5/2026 9 43
6/4/2026 10 34
6/3/2026 8 25
6/2/2026 9 17
6/1/2026 8 8