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 49.4371 2024-06-06 00:00:00.0 5.7123 223
2 56.6083 2024-06-07 00:00:00.0 7.1712 223
3 63.7742 2024-06-08 00:00:00.0 7.1659 223
4 69.6655 2024-06-09 00:00:00.0 5.8913 223
5 74.7083 2024-06-10 00:00:00.0 5.0428 223
6 83.3529 2024-06-11 00:00:00.0 8.6446 223
7 91.1508 2024-06-12 00:00:00.0 7.7979 223
8 99.6785 2024-06-13 00:00:00.0 8.5277 223
9 106.7398 2024-06-14 00:00:00.0 7.0613 223
10 115.1532 2024-06-15 00:00:00.0 8.4134 223
11 124.7434 2024-06-16 00:00:00.0 9.5902 223
12 132.2225 2024-06-17 00:00:00.0 7.4791 223
13 139.1962 2024-06-18 00:00:00.0 6.9737 223
14 146.6806 2024-06-19 00:00:00.0 7.4844 223
15 155.0747 2024-06-20 00:00:00.0 8.3941 223
16 163.8063 2024-06-21 00:00:00.0 8.7316 223
17 172.7513 2024-06-22 00:00:00.0 8.9450 223
18 181.8253 2024-06-23 00:00:00.0 9.0740 223
19 189.5095 2024-06-24 00:00:00.0 7.6842 223
20 198.8896 2024-06-25 00:00:00.0 9.3801 223
21 206.9793 2024-06-26 00:00:00.0 8.0897 223
22 213.7116 2024-06-27 00:00:00.0 6.7323 223
23 220.6321 2024-06-28 00:00:00.0 6.9205 223
24 227.6358 2024-06-29 00:00:00.0 7.0037 223
25 233.9033 2024-06-30 00:00:00.0 6.2675 223
26 242.4958 2024-07-01 00:00:00.0 8.5925 223
27 251.9756 2024-07-02 00:00:00.0 9.4798 223
28 261.3564 2024-07-03 00:00:00.0 9.3808 223
29 270.0197 2024-07-04 00:00:00.0 8.6633 223
30 279.0314 2024-07-05 00:00:00.0 9.0117 223
31 287.9307 2024-07-06 00:00:00.0 8.8993 223
32 296.6724 2024-07-07 00:00:00.0 8.7417 223
33 305.2854 2024-07-08 00:00:00.0 8.6130 223
34 313.5071 2024-07-09 00:00:00.0 8.2217 223
35 321.7932 2024-07-10 00:00:00.0 8.2861 223
36 329.1817 2024-07-11 00:00:00.0 7.3885 223
37 336.0020 2024-07-12 00:00:00.0 6.8203 223
38 344.0402 2024-07-13 00:00:00.0 8.0382 223
39 352.9716 2024-07-14 00:00:00.0 8.9314 223
40 362.3311 2024-07-15 00:00:00.0 9.3595 223
41 370.5590 2024-07-16 00:00:00.0 8.2279 223
42 377.9038 2024-07-17 00:00:00.0 7.3448 223
43 385.9479 2024-07-18 00:00:00.0 8.0441 223
44 394.4673 2024-07-19 00:00:00.0 8.5194 223
45 402.4123 2024-07-20 00:00:00.0 7.9450 223
46 410.8753 2024-07-21 00:00:00.0 8.4630 223
47 420.1246 2024-07-22 00:00:00.0 9.2493 223
48 429.6820 2024-07-23 00:00:00.0 9.5574 223
49 438.4289 2024-07-24 00:00:00.0 8.7469 223
50 447.0327 2024-07-25 00:00:00.0 8.6038 223
51 453.3823 2024-07-26 00:00:00.0 6.3496 223
52 461.5191 2024-07-27 00:00:00.0 8.1368 223
53 470.9708 2024-07-28 00:00:00.0 9.4517 223
54 479.3943 2024-07-29 00:00:00.0 8.4235 223
55 486.8397 2024-07-30 00:00:00.0 7.4454 223
56 494.4833 2024-07-31 00:00:00.0 7.6436 223
57 501.6512 2024-08-01 00:00:00.0 7.1679 223
58 509.9796 2024-08-02 00:00:00.0 8.3284 223
59 518.9145 2024-08-03 00:00:00.0 8.9349 223
60 526.3840 2024-08-04 00:00:00.0 7.4695 223
61 534.7639 2024-08-05 00:00:00.0 8.3799 223
62 541.3072 2024-08-06 00:00:00.0 6.5433 223
63 549.8016 2024-08-07 00:00:00.0 8.4944 223
64 556.5444 2024-08-08 00:00:00.0 6.7428 223
65 563.8669 2024-08-09 00:00:00.0 7.3225 223
66 571.4328 2024-08-10 00:00:00.0 7.5659 223
67 579.9196 2024-08-11 00:00:00.0 8.4868 223
68 587.4401 2024-08-12 00:00:00.0 7.5205 223
69 595.5984 2024-08-13 00:00:00.0 8.1583 223
70 604.7414 2024-08-14 00:00:00.0 9.1430 223
71 614.5707 2024-08-15 00:00:00.0 9.8293 223
72 624.0526 2024-08-16 00:00:00.0 9.4819 223
73 633.0481 2024-08-17 00:00:00.0 8.9955 223
74 641.0977 2024-08-18 00:00:00.0 8.0496 223
75 649.5224 2024-08-19 00:00:00.0 8.4247 223
76 657.8807 2024-08-20 00:00:00.0 8.3583 223
77 666.9093 2024-08-21 00:00:00.0 9.0286 223
78 676.4373 2024-08-22 00:00:00.0 9.5280 223
79 684.4562 2024-08-23 00:00:00.0 8.0189 223
80 692.0578 2024-08-24 00:00:00.0 7.6016 223
81 698.4354 2024-08-25 00:00:00.0 6.3776 223
82 707.6099 2024-08-26 00:00:00.0 9.1745 223
83 714.7381 2024-08-27 00:00:00.0 7.1282 223
84 721.8687 2024-08-28 00:00:00.0 7.1306 223
85 731.0690 2024-08-29 00:00:00.0 9.2003 223
86 739.8269 2024-08-30 00:00:00.0 8.7579 223
87 748.4061 2024-08-31 00:00:00.0 8.5792 223
88 755.7202 2024-09-01 00:00:00.0 7.3141 223
89 764.1219 2024-09-02 00:00:00.0 8.4017 223
90 772.4428 2024-09-03 00:00:00.0 8.3209 223
91 781.9410 2024-09-04 00:00:00.0 9.4982 223
92 788.3103 2024-09-05 00:00:00.0 6.3693 223
93 794.3190 2024-09-06 00:00:00.0 6.0087 223
94 801.3242 2024-09-07 00:00:00.0 7.0052 223
95 809.9387 2024-09-08 00:00:00.0 8.6145 223
96 817.8922 2024-09-09 00:00:00.0 7.9535 223
97 827.4429 2024-09-10 00:00:00.0 9.5507 223
98 835.6552 2024-09-11 00:00:00.0 8.2123 223
99 843.2466 2024-09-12 00:00:00.0 7.5914 223
100 851.7435 2024-09-13 00:00:00.0 8.4969 223
101 860.8242 2024-09-14 00:00:00.0 9.0807 223
102 868.8590 2024-09-15 00:00:00.0 8.0348 223
103 877.5603 2024-09-16 00:00:00.0 8.7013 223
104 887.0220 2024-09-17 00:00:00.0 9.4617 223
105 896.0828 2024-09-18 00:00:00.0 9.0608 223
106 905.8693 2024-09-19 00:00:00.0 9.7865 223
107 914.9967 2024-09-20 00:00:00.0 9.1274 223
108 922.6206 2024-09-21 00:00:00.0 7.6239 223
109 928.3385 2024-09-22 00:00:00.0 5.7179 223
110 936.3341 2024-09-23 00:00:00.0 7.9956 223
111 944.0465 2024-09-24 00:00:00.0 7.7124 223
112 952.7183 2024-09-25 00:00:00.0 8.6718 223
113 960.9083 2024-09-26 00:00:00.0 8.1900 223
114 968.7463 2024-09-27 00:00:00.0 7.8380 223
115 976.1115 2024-09-28 00:00:00.0 7.3652 223
116 983.7013 2024-09-29 00:00:00.0 7.5898 223
117 991.2866 2024-09-30 00:00:00.0 7.5853 223
118 994.7279 2024-10-01 00:00:00.0 3.4413 223
119 999.5918 2024-10-02 00:00:00.0 4.8639 223
120 1000.5994 2024-10-03 00:00:00.0 1.0076 223
121 1003.4445 2024-10-04 00:00:00.0 2.8451 223
122 1008.7520 2024-10-05 00:00:00.0 5.3075 223
123 1011.6525 2024-10-06 00:00:00.0 2.9005 223
124 1015.3249 2024-10-07 00:00:00.0 3.6724 223
125 1019.0529 2024-10-08 00:00:00.0 3.7280 223
126 1026.0093 2024-10-09 00:00:00.0 6.9564 223
127 1033.7942 2024-10-10 00:00:00.0 7.7849 223
128 1036.3469 2024-10-11 00:00:00.0 2.5527 223
129 1038.4627 2024-10-12 00:00:00.0 2.1158 223
130 1039.4062 2024-10-13 00:00:00.0 0.9435 223
131 1039.4766 2024-10-14 00:00:00.0 0.0704 223
132 1040.0368 2024-10-15 00:00:00.0 0.5602 223
133 1043.8054 2024-10-16 00:00:00.0 3.7686 223
134 1049.9729 2024-10-17 00:00:00.0 6.1675 223
135 1051.7626 2024-10-18 00:00:00.0 1.7897 223
136 1053.5090 2024-10-19 00:00:00.0 1.7464 223
137 1058.9849 2024-10-20 00:00:00.0 5.4759 223
138 1064.4552 2024-10-21 00:00:00.0 5.4703 223
139 1068.0851 2024-10-22 00:00:00.0 3.6299 223
140 1069.4453 2024-10-23 00:00:00.0 1.3602 223
141 1069.9922 2024-10-24 00:00:00.0 0.5469 223
142 1070.3840 2024-10-25 00:00:00.0 0.3918 223
143 1070.8901 2024-10-26 00:00:00.0 0.5061 223
144 1072.7139 2024-10-27 00:00:00.0 1.8238 223
145 1075.5781 2024-10-28 00:00:00.0 2.8642 223
146 1076.0423 2024-10-29 00:00:00.0 0.4642 223
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '223') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-29'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/29/2024 0 1076
10/28/2024 3 1076
10/27/2024 2 1073
10/26/2024 1 1071
10/25/2024 0 1070
10/24/2024 1 1070
10/23/2024 1 1069
10/22/2024 4 1068
10/21/2024 5 1064
10/20/2024 5 1059
10/19/2024 2 1054
10/18/2024 2 1052
10/17/2024 6 1050
10/16/2024 4 1044
10/15/2024 1 1040
10/14/2024 0 1039
10/13/2024 1 1039
10/12/2024 2 1038
10/11/2024 3 1036
10/10/2024 8 1034
10/9/2024 7 1026
10/8/2024 4 1019
10/7/2024 4 1015
10/6/2024 3 1012
10/5/2024 5 1009
10/4/2024 3 1003
10/3/2024 1 1001
10/2/2024 5 1000
10/1/2024 3 995
9/30/2024 8 991
9/29/2024 8 984
9/28/2024 7 976
9/27/2024 8 969
9/26/2024 8 961
9/25/2024 9 953
9/24/2024 8 944
9/23/2024 8 936
9/22/2024 6 928
9/21/2024 8 923
9/20/2024 9 915
9/19/2024 10 906
9/18/2024 9 896
9/17/2024 9 887
9/16/2024 9 878
9/15/2024 8 869
9/14/2024 9 861
9/13/2024 8 852
9/12/2024 8 843
9/11/2024 8 836
9/10/2024 10 827
9/9/2024 8 818
9/8/2024 9 810
9/7/2024 7 801
9/6/2024 6 794
9/5/2024 6 788
9/4/2024 9 782
9/3/2024 8 772
9/2/2024 8 764
9/1/2024 7 756
8/31/2024 9 748
8/30/2024 9 740
8/29/2024 9 731
8/28/2024 7 722
8/27/2024 7 715
8/26/2024 9 708
8/25/2024 6 698
8/24/2024 8 692
8/23/2024 8 684
8/22/2024 10 676
8/21/2024 9 667
8/20/2024 8 658
8/19/2024 8 650
8/18/2024 8 641
8/17/2024 9 633
8/16/2024 9 624
8/15/2024 10 615
8/14/2024 9 605
8/13/2024 8 596
8/12/2024 8 587
8/11/2024 8 580
8/10/2024 8 571
8/9/2024 7 564
8/8/2024 7 557
8/7/2024 8 550
8/6/2024 7 541
8/5/2024 8 535
8/4/2024 7 526
8/3/2024 9 519
8/2/2024 8 510
8/1/2024 7 502
7/31/2024 8 494
7/30/2024 7 487
7/29/2024 8 479
7/28/2024 9 471
7/27/2024 8 462
7/26/2024 6 453
7/25/2024 9 447
7/24/2024 9 438
7/23/2024 10 430
7/22/2024 9 420
7/21/2024 8 411
7/20/2024 8 402
7/19/2024 9 394
7/18/2024 8 386
7/17/2024 7 378
7/16/2024 8 371
7/15/2024 9 362
7/14/2024 9 353
7/13/2024 8 344
7/12/2024 7 336
7/11/2024 7 329
7/10/2024 8 322
7/9/2024 8 314
7/8/2024 9 305
7/7/2024 9 297
7/6/2024 9 288
7/5/2024 9 279
7/4/2024 9 270
7/3/2024 9 261
7/2/2024 9 252
7/1/2024 9 242
6/30/2024 6 234
6/29/2024 7 228
6/28/2024 7 221
6/27/2024 7 214
6/26/2024 8 207
6/25/2024 9 199
6/24/2024 8 190
6/23/2024 9 182
6/22/2024 9 173
6/21/2024 9 164
6/20/2024 8 155
6/19/2024 7 147
6/18/2024 7 139
6/17/2024 7 132
6/16/2024 10 125
6/15/2024 8 115
6/14/2024 7 107
6/13/2024 9 100
6/12/2024 8 91
6/11/2024 9 83
6/10/2024 5 75
6/9/2024 6 70
6/8/2024 7 64
6/7/2024 7 57