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 46.0907 2024-06-06 00:00:00.0 5.6709 237
2 53.0494 2024-06-07 00:00:00.0 6.9587 237
3 59.0190 2024-06-08 00:00:00.0 5.9696 237
4 64.3065 2024-06-09 00:00:00.0 5.2875 237
5 70.1184 2024-06-10 00:00:00.0 5.8119 237
6 78.6969 2024-06-11 00:00:00.0 8.5785 237
7 86.5317 2024-06-12 00:00:00.0 7.8348 237
8 94.9109 2024-06-13 00:00:00.0 8.3792 237
9 102.3894 2024-06-14 00:00:00.0 7.4785 237
10 110.3104 2024-06-15 00:00:00.0 7.9210 237
11 119.8930 2024-06-16 00:00:00.0 9.5826 237
12 125.9418 2024-06-17 00:00:00.0 6.0488 237
13 132.4424 2024-06-18 00:00:00.0 6.5006 237
14 139.8717 2024-06-19 00:00:00.0 7.4293 237
15 147.4361 2024-06-20 00:00:00.0 7.5644 237
16 154.9946 2024-06-21 00:00:00.0 7.5585 237
17 164.0755 2024-06-22 00:00:00.0 9.0809 237
18 172.9536 2024-06-23 00:00:00.0 8.8781 237
19 180.7404 2024-06-24 00:00:00.0 7.7868 237
20 189.9417 2024-06-25 00:00:00.0 9.2013 237
21 197.6876 2024-06-26 00:00:00.0 7.7459 237
22 204.0284 2024-06-27 00:00:00.0 6.3408 237
23 210.8544 2024-06-28 00:00:00.0 6.8260 237
24 217.4867 2024-06-29 00:00:00.0 6.6323 237
25 225.0022 2024-06-30 00:00:00.0 7.5155 237
26 233.5132 2024-07-01 00:00:00.0 8.5110 237
27 242.7225 2024-07-02 00:00:00.0 9.2093 237
28 251.8319 2024-07-03 00:00:00.0 9.1094 237
29 261.0817 2024-07-04 00:00:00.0 9.2498 237
30 269.8234 2024-07-05 00:00:00.0 8.7417 237
31 278.7152 2024-07-06 00:00:00.0 8.8918 237
32 287.0827 2024-07-07 00:00:00.0 8.3675 237
33 295.7919 2024-07-08 00:00:00.0 8.7092 237
34 304.0456 2024-07-09 00:00:00.0 8.2537 237
35 312.2098 2024-07-10 00:00:00.0 8.1642 237
36 319.8180 2024-07-11 00:00:00.0 7.6082 237
37 327.2094 2024-07-12 00:00:00.0 7.3914 237
38 335.2409 2024-07-13 00:00:00.0 8.0315 237
39 343.9088 2024-07-14 00:00:00.0 8.6679 237
40 353.2687 2024-07-15 00:00:00.0 9.3599 237
41 361.1233 2024-07-16 00:00:00.0 7.8546 237
42 368.6479 2024-07-17 00:00:00.0 7.5246 237
43 375.8820 2024-07-18 00:00:00.0 7.2341 237
44 383.5597 2024-07-19 00:00:00.0 7.6777 237
45 391.6098 2024-07-20 00:00:00.0 8.0501 237
46 399.9427 2024-07-21 00:00:00.0 8.3329 237
47 409.3284 2024-07-22 00:00:00.0 9.3857 237
48 418.7302 2024-07-23 00:00:00.0 9.4018 237
49 427.1876 2024-07-24 00:00:00.0 8.4574 237
50 435.5008 2024-07-25 00:00:00.0 8.3132 237
51 444.0008 2024-07-26 00:00:00.0 8.5000 237
52 451.3272 2024-07-27 00:00:00.0 7.3264 237
53 460.1631 2024-07-28 00:00:00.0 8.8359 237
54 468.1371 2024-07-29 00:00:00.0 7.9740 237
55 475.4403 2024-07-30 00:00:00.0 7.3032 237
56 483.8579 2024-07-31 00:00:00.0 8.4176 237
57 490.3665 2024-08-01 00:00:00.0 6.5086 237
58 498.4945 2024-08-02 00:00:00.0 8.1280 237
59 506.9204 2024-08-03 00:00:00.0 8.4259 237
60 513.8320 2024-08-04 00:00:00.0 6.9116 237
61 521.6668 2024-08-05 00:00:00.0 7.8348 237
62 528.5334 2024-08-06 00:00:00.0 6.8666 237
63 536.5405 2024-08-07 00:00:00.0 8.0071 237
64 543.8008 2024-08-08 00:00:00.0 7.2603 237
65 551.3988 2024-08-09 00:00:00.0 7.5980 237
66 558.7936 2024-08-10 00:00:00.0 7.3948 237
67 567.2383 2024-08-11 00:00:00.0 8.4447 237
68 574.9773 2024-08-12 00:00:00.0 7.7390 237
69 582.2966 2024-08-13 00:00:00.0 7.3193 237
70 591.4367 2024-08-14 00:00:00.0 9.1401 237
71 601.1524 2024-08-15 00:00:00.0 9.7157 237
72 610.7932 2024-08-16 00:00:00.0 9.6408 237
73 619.5194 2024-08-17 00:00:00.0 8.7262 237
74 627.5822 2024-08-18 00:00:00.0 8.0628 237
75 635.4577 2024-08-19 00:00:00.0 7.8755 237
76 643.0970 2024-08-20 00:00:00.0 7.6393 237
77 651.7075 2024-08-21 00:00:00.0 8.6105 237
78 660.6529 2024-08-22 00:00:00.0 8.9454 237
79 669.5905 2024-08-23 00:00:00.0 8.9376 237
80 676.8778 2024-08-24 00:00:00.0 7.2873 237
81 684.0484 2024-08-25 00:00:00.0 7.1706 237
82 692.2140 2024-08-26 00:00:00.0 8.1656 237
83 699.0724 2024-08-27 00:00:00.0 6.8584 237
84 705.5404 2024-08-28 00:00:00.0 6.4680 237
85 714.2650 2024-08-29 00:00:00.0 8.7246 237
86 722.9611 2024-08-30 00:00:00.0 8.6961 237
87 731.7940 2024-08-31 00:00:00.0 8.8329 237
88 739.3917 2024-09-01 00:00:00.0 7.5977 237
89 745.8307 2024-09-02 00:00:00.0 6.4390 237
90 753.1999 2024-09-03 00:00:00.0 7.3692 237
91 762.2695 2024-09-04 00:00:00.0 9.0696 237
92 769.6837 2024-09-05 00:00:00.0 7.4142 237
93 775.7325 2024-09-06 00:00:00.0 6.0488 237
94 781.6783 2024-09-07 00:00:00.0 5.9458 237
95 788.8693 2024-09-08 00:00:00.0 7.1910 237
96 795.3958 2024-09-09 00:00:00.0 6.5265 237
97 803.9150 2024-09-10 00:00:00.0 8.5192 237
98 811.5638 2024-09-11 00:00:00.0 7.6488 237
99 818.7135 2024-09-12 00:00:00.0 7.1497 237
100 828.2078 2024-09-13 00:00:00.0 9.4943 237
101 836.5996 2024-09-14 00:00:00.0 8.3918 237
102 844.9049 2024-09-15 00:00:00.0 8.3053 237
103 853.3715 2024-09-16 00:00:00.0 8.4666 237
104 862.3588 2024-09-17 00:00:00.0 8.9873 237
105 869.3979 2024-09-18 00:00:00.0 7.0391 237
106 879.0883 2024-09-19 00:00:00.0 9.6904 237
107 887.7016 2024-09-20 00:00:00.0 8.6133 237
108 894.7275 2024-09-21 00:00:00.0 7.0259 237
109 900.0948 2024-09-22 00:00:00.0 5.3673 237
110 907.2786 2024-09-23 00:00:00.0 7.1838 237
111 915.4337 2024-09-24 00:00:00.0 8.1551 237
112 923.2501 2024-09-25 00:00:00.0 7.8164 237
113 930.2566 2024-09-26 00:00:00.0 7.0065 237
114 937.9048 2024-09-27 00:00:00.0 7.6482 237
115 944.6620 2024-09-28 00:00:00.0 6.7572 237
116 950.4323 2024-09-29 00:00:00.0 5.7703 237
117 958.1925 2024-09-30 00:00:00.0 7.7602 237
118 962.3552 2024-10-01 00:00:00.0 4.1627 237
119 967.2583 2024-10-02 00:00:00.0 4.9031 237
120 968.6349 2024-10-03 00:00:00.0 1.3766 237
121 971.9682 2024-10-04 00:00:00.0 3.3333 237
122 977.1302 2024-10-05 00:00:00.0 5.1620 237
123 980.4645 2024-10-06 00:00:00.0 3.3343 237
124 985.1968 2024-10-07 00:00:00.0 4.7323 237
125 989.7506 2024-10-08 00:00:00.0 4.5538 237
126 995.8233 2024-10-09 00:00:00.0 6.0727 237
127 1002.2018 2024-10-10 00:00:00.0 6.3785 237
128 1004.9864 2024-10-11 00:00:00.0 2.7846 237
129 1007.2631 2024-10-12 00:00:00.0 2.2767 237
130 1008.5566 2024-10-13 00:00:00.0 1.2935 237
131 1008.7617 2024-10-14 00:00:00.0 0.2051 237
132 1009.4482 2024-10-15 00:00:00.0 0.6865 237
133 1012.6706 2024-10-16 00:00:00.0 3.2224 237
134 1017.8922 2024-10-17 00:00:00.0 5.2216 237
135 1020.6678 2024-10-18 00:00:00.0 2.7756 237
136 1022.7566 2024-10-19 00:00:00.0 2.0888 237
137 1028.3529 2024-10-20 00:00:00.0 5.5963 237
138 1032.7939 2024-10-21 00:00:00.0 4.4410 237
139 1035.9773 2024-10-22 00:00:00.0 3.1834 237
140 1038.5033 2024-10-23 00:00:00.0 2.5260 237
141 1039.6548 2024-10-24 00:00:00.0 1.1515 237
142 1040.1882 2024-10-25 00:00:00.0 0.5334 237
143 1040.6943 2024-10-26 00:00:00.0 0.5061 237
144 1041.6867 2024-10-27 00:00:00.0 0.9924 237
145 1044.6601 2024-10-28 00:00:00.0 2.9734 237
146 1045.2705 2024-10-29 00:00:00.0 0.6104 237
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '237') 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 1 1045
10/28/2024 3 1045
10/27/2024 1 1042
10/26/2024 1 1041
10/25/2024 1 1040
10/24/2024 1 1040
10/23/2024 3 1039
10/22/2024 3 1036
10/21/2024 4 1033
10/20/2024 6 1028
10/19/2024 2 1023
10/18/2024 3 1021
10/17/2024 5 1018
10/16/2024 3 1013
10/15/2024 1 1009
10/14/2024 0 1009
10/13/2024 1 1009
10/12/2024 2 1007
10/11/2024 3 1005
10/10/2024 6 1002
10/9/2024 6 996
10/8/2024 5 990
10/7/2024 5 985
10/6/2024 3 980
10/5/2024 5 977
10/4/2024 3 972
10/3/2024 1 969
10/2/2024 5 967
10/1/2024 4 962
9/30/2024 8 958
9/29/2024 6 950
9/28/2024 7 945
9/27/2024 8 938
9/26/2024 7 930
9/25/2024 8 923
9/24/2024 8 915
9/23/2024 7 907
9/22/2024 5 900
9/21/2024 7 895
9/20/2024 9 888
9/19/2024 10 879
9/18/2024 7 869
9/17/2024 9 862
9/16/2024 8 853
9/15/2024 8 845
9/14/2024 8 837
9/13/2024 9 828
9/12/2024 7 819
9/11/2024 8 812
9/10/2024 9 804
9/9/2024 7 795
9/8/2024 7 789
9/7/2024 6 782
9/6/2024 6 776
9/5/2024 7 770
9/4/2024 9 762
9/3/2024 7 753
9/2/2024 6 746
9/1/2024 8 739
8/31/2024 9 732
8/30/2024 9 723
8/29/2024 9 714
8/28/2024 6 706
8/27/2024 7 699
8/26/2024 8 692
8/25/2024 7 684
8/24/2024 7 677
8/23/2024 9 670
8/22/2024 9 661
8/21/2024 9 652
8/20/2024 8 643
8/19/2024 8 635
8/18/2024 8 628
8/17/2024 9 620
8/16/2024 10 611
8/15/2024 10 601
8/14/2024 9 591
8/13/2024 7 582
8/12/2024 8 575
8/11/2024 8 567
8/10/2024 7 559
8/9/2024 8 551
8/8/2024 7 544
8/7/2024 8 537
8/6/2024 7 529
8/5/2024 8 522
8/4/2024 7 514
8/3/2024 8 507
8/2/2024 8 498
8/1/2024 7 490
7/31/2024 8 484
7/30/2024 7 475
7/29/2024 8 468
7/28/2024 9 460
7/27/2024 7 451
7/26/2024 9 444
7/25/2024 8 436
7/24/2024 8 427
7/23/2024 9 419
7/22/2024 9 409
7/21/2024 8 400
7/20/2024 8 392
7/19/2024 8 384
7/18/2024 7 376
7/17/2024 8 369
7/16/2024 8 361
7/15/2024 9 353
7/14/2024 9 344
7/13/2024 8 335
7/12/2024 7 327
7/11/2024 8 320
7/10/2024 8 312
7/9/2024 8 304
7/8/2024 9 296
7/7/2024 8 287
7/6/2024 9 279
7/5/2024 9 270
7/4/2024 9 261
7/3/2024 9 252
7/2/2024 9 243
7/1/2024 9 234
6/30/2024 8 225
6/29/2024 7 217
6/28/2024 7 211
6/27/2024 6 204
6/26/2024 8 198
6/25/2024 9 190
6/24/2024 8 181
6/23/2024 9 173
6/22/2024 9 164
6/21/2024 8 155
6/20/2024 8 147
6/19/2024 7 140
6/18/2024 7 132
6/17/2024 6 126
6/16/2024 10 120
6/15/2024 8 110
6/14/2024 7 102
6/13/2024 8 95
6/12/2024 8 87
6/11/2024 9 79
6/10/2024 6 70
6/9/2024 5 64
6/8/2024 6 59
6/7/2024 7 53