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.3847 2025-06-01 00:00:00.0 7.3847 210
2 14.3321 2025-06-02 00:00:00.0 6.9474 210
3 22.7078 2025-06-03 00:00:00.0 8.3757 210
4 29.8691 2025-06-04 00:00:00.0 7.1613 210
5 36.4462 2025-06-05 00:00:00.0 6.5771 210
6 40.6002 2025-06-06 00:00:00.0 4.1540 210
7 46.8900 2025-06-07 00:00:00.0 6.2898 210
8 55.4259 2025-06-08 00:00:00.0 8.5359 210
9 61.5929 2025-06-09 00:00:00.0 6.1670 210
10 65.7062 2025-06-10 00:00:00.0 4.1133 210
11 71.4481 2025-06-11 00:00:00.0 5.7419 210
12 77.3670 2025-06-12 00:00:00.0 5.9189 210
13 83.7042 2025-06-13 00:00:00.0 6.3372 210
14 91.7427 2025-06-14 00:00:00.0 8.0385 210
15 100.1566 2025-06-15 00:00:00.0 8.4139 210
16 107.6668 2025-06-16 00:00:00.0 7.5102 210
17 116.6999 2025-06-17 00:00:00.0 9.0331 210
18 125.0218 2025-06-18 00:00:00.0 8.3219 210
19 133.1696 2025-06-19 00:00:00.0 8.1478 210
20 142.1045 2025-06-20 00:00:00.0 8.9349 210
21 149.5865 2025-06-21 00:00:00.0 7.4820 210
22 159.1431 2025-06-22 00:00:00.0 9.5566 210
23 167.2788 2025-06-23 00:00:00.0 8.1357 210
24 173.0106 2025-06-24 00:00:00.0 5.7318 210
25 178.8467 2025-06-25 00:00:00.0 5.8361 210
26 186.6108 2025-06-26 00:00:00.0 7.7641 210
27 195.2656 2025-06-27 00:00:00.0 8.6548 210
28 203.3340 2025-06-28 00:00:00.0 8.0684 210
29 210.4205 2025-06-29 00:00:00.0 7.0865 210
30 219.1301 2025-06-30 00:00:00.0 8.7096 210
31 227.6578 2025-07-01 00:00:00.0 8.5277 210
32 236.1791 2025-07-02 00:00:00.0 8.5213 210
33 244.3160 2025-07-03 00:00:00.0 8.1369 210
34 251.1082 2025-07-04 00:00:00.0 6.7922 210
35 257.3691 2025-07-05 00:00:00.0 6.2609 210
36 266.8499 2025-07-06 00:00:00.0 9.4808 210
37 274.6520 2025-07-07 00:00:00.0 7.8021 210
38 280.8702 2025-07-08 00:00:00.0 6.2182 210
39 288.4030 2025-07-09 00:00:00.0 7.5328 210
40 295.9500 2025-07-10 00:00:00.0 7.5470 210
41 301.8811 2025-07-11 00:00:00.0 5.9311 210
42 311.3991 2025-07-12 00:00:00.0 9.5180 210
43 319.8310 2025-07-13 00:00:00.0 8.4319 210
44 328.5293 2025-07-14 00:00:00.0 8.6983 210
45 336.9858 2025-07-15 00:00:00.0 8.4565 210
46 345.5265 2025-07-16 00:00:00.0 8.5407 210
47 351.5737 2025-07-17 00:00:00.0 6.0472 210
48 357.7264 2025-07-18 00:00:00.0 6.1527 210
49 364.8919 2025-07-19 00:00:00.0 7.1655 210
50 372.8177 2025-07-20 00:00:00.0 7.9258 210
51 380.3730 2025-07-21 00:00:00.0 7.5553 210
52 389.1505 2025-07-22 00:00:00.0 8.7775 210
53 398.6291 2025-07-23 00:00:00.0 9.4786 210
54 407.6160 2025-07-24 00:00:00.0 8.9869 210
55 416.5074 2025-07-25 00:00:00.0 8.8914 210
56 423.6697 2025-07-26 00:00:00.0 7.1623 210
57 430.6165 2025-07-27 00:00:00.0 6.9468 210
58 439.9832 2025-07-28 00:00:00.0 9.3667 210
59 448.5349 2025-07-29 00:00:00.0 8.5517 210
60 457.2161 2025-07-30 00:00:00.0 8.6812 210
61 464.0815 2025-07-31 00:00:00.0 6.8654 210
62 472.2855 2025-08-01 00:00:00.0 8.2040 210
63 479.6146 2025-08-02 00:00:00.0 7.3291 210
64 488.0169 2025-08-03 00:00:00.0 8.4023 210
65 495.9976 2025-08-04 00:00:00.0 7.9807 210
66 504.6551 2025-08-05 00:00:00.0 8.6575 210
67 512.8904 2025-08-06 00:00:00.0 8.2353 210
68 521.9057 2025-08-07 00:00:00.0 9.0153 210
69 530.4545 2025-08-08 00:00:00.0 8.5488 210
70 540.0021 2025-08-09 00:00:00.0 9.5476 210
71 549.1562 2025-08-10 00:00:00.0 9.1541 210
72 558.4222 2025-08-11 00:00:00.0 9.2660 210
73 567.7067 2025-08-12 00:00:00.0 9.2845 210
74 576.9098 2025-08-13 00:00:00.0 9.2031 210
75 584.3633 2025-08-14 00:00:00.0 7.4535 210
76 592.2746 2025-08-15 00:00:00.0 7.9113 210
77 600.6856 2025-08-16 00:00:00.0 8.4110 210
78 608.4821 2025-08-17 00:00:00.0 7.7965 210
79 616.6901 2025-08-18 00:00:00.0 8.2080 210
80 626.0908 2025-08-19 00:00:00.0 9.4007 210
81 635.0032 2025-08-20 00:00:00.0 8.9124 210
82 643.2590 2025-08-21 00:00:00.0 8.2558 210
83 652.2026 2025-08-22 00:00:00.0 8.9436 210
84 660.1170 2025-08-23 00:00:00.0 7.9144 210
85 668.0331 2025-08-24 00:00:00.0 7.9161 210
86 673.5013 2025-08-25 00:00:00.0 5.4682 210
87 678.5606 2025-08-26 00:00:00.0 5.0593 210
88 686.2082 2025-08-27 00:00:00.0 7.6476 210
89 695.0211 2025-08-28 00:00:00.0 8.8129 210
90 703.3219 2025-08-29 00:00:00.0 8.3008 210
91 710.8508 2025-08-30 00:00:00.0 7.5289 210
92 717.8404 2025-08-31 00:00:00.0 6.9896 210
93 725.3906 2025-09-01 00:00:00.0 7.5502 210
94 733.7004 2025-09-02 00:00:00.0 8.3098 210
95 738.8310 2025-09-03 00:00:00.0 5.1306 210
96 741.0802 2025-09-04 00:00:00.0 2.2492 210
97 741.5159 2025-09-05 00:00:00.0 0.4357 210
98 745.9969 2025-09-06 00:00:00.0 4.4810 210
99 748.8349 2025-09-07 00:00:00.0 2.8380 210
100 752.3887 2025-09-08 00:00:00.0 3.5538 210
101 759.4791 2025-09-09 00:00:00.0 7.0904 210
102 765.7807 2025-09-10 00:00:00.0 6.3016 210
103 771.9793 2025-09-11 00:00:00.0 6.1986 210
104 780.7711 2025-09-12 00:00:00.0 8.7918 210
105 789.9804 2025-09-13 00:00:00.0 9.2093 210
106 798.7244 2025-09-14 00:00:00.0 8.7440 210
107 807.6023 2025-09-15 00:00:00.0 8.8779 210
108 815.1876 2025-09-16 00:00:00.0 7.5853 210
109 824.5400 2025-09-17 00:00:00.0 9.3524 210
110 833.1535 2025-09-18 00:00:00.0 8.6135 210
111 841.0831 2025-09-19 00:00:00.0 7.9296 210
112 849.5319 2025-09-20 00:00:00.0 8.4488 210
113 858.2585 2025-09-21 00:00:00.0 8.7266 210
114 866.6976 2025-09-22 00:00:00.0 8.4391 210
115 874.8880 2025-09-23 00:00:00.0 8.1904 210
116 882.4055 2025-09-24 00:00:00.0 7.5175 210
117 889.7106 2025-09-25 00:00:00.0 7.3051 210
118 894.4688 2025-09-26 00:00:00.0 4.7582 210
119 899.4708 2025-09-27 00:00:00.0 5.0020 210
120 906.6625 2025-09-28 00:00:00.0 7.1917 210
121 913.2221 2025-09-29 00:00:00.0 6.5596 210
122 921.4953 2025-09-30 00:00:00.0 8.2732 210
123 928.9572 2025-10-01 00:00:00.0 7.4619 210
124 938.3752 2025-10-02 00:00:00.0 9.4180 210
125 946.4193 2025-10-03 00:00:00.0 8.0441 210
126 955.0193 2025-10-04 00:00:00.0 8.6000 210
127 963.3042 2025-10-05 00:00:00.0 8.2849 210
128 966.0852 2025-10-06 00:00:00.0 2.7810 210
129 967.2986 2025-10-07 00:00:00.0 1.2134 210
130 967.7909 2025-10-08 00:00:00.0 0.4923 210
131 971.6943 2025-10-09 00:00:00.0 3.9034 210
132 976.9917 2025-10-10 00:00:00.0 5.2974 210
133 979.9756 2025-10-11 00:00:00.0 2.9839 210
134 985.0592 2025-10-12 00:00:00.0 5.0836 210
135 990.0243 2025-10-13 00:00:00.0 4.9651 210
136 990.1462 2025-10-14 00:00:00.0 0.1219 210
137 990.1462 2025-10-15 00:00:00.0 0.0000 210
138 992.8143 2025-10-16 00:00:00.0 2.6681 210
139 995.6656 2025-10-17 00:00:00.0 2.8513 210
140 1000.6246 2025-10-18 00:00:00.0 4.9590 210
141 1001.6046 2025-10-19 00:00:00.0 0.9800 210
142 1001.9816 2025-10-20 00:00:00.0 0.3770 210
143 1002.0171 2025-10-21 00:00:00.0 0.0355 210
144 1002.0171 2025-10-22 00:00:00.0 0.0000 210
145 1002.0171 2025-10-23 00:00:00.0 0.0000 210
146 1002.3640 2025-10-24 00:00:00.0 0.3469 210
147 1003.8470 2025-10-25 00:00:00.0 1.4830 210
148 1006.8254 2025-10-26 00:00:00.0 2.9784 210
149 1013.3764 2025-10-27 00:00:00.0 6.5510 210
150 1018.8862 2025-10-28 00:00:00.0 5.5098 210
151 1019.3074 2025-10-29 00:00:00.0 0.4212 210
152 1019.5288 2025-10-30 00:00:00.0 0.2214 210
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '210') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-10-30'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/30/2025 0 1020
10/29/2025 0 1019
10/28/2025 6 1019
10/27/2025 7 1013
10/26/2025 3 1007
10/25/2025 1 1004
10/24/2025 0 1002
10/23/2025 0 1002
10/22/2025 0 1002
10/21/2025 0 1002
10/20/2025 0 1002
10/19/2025 1 1002
10/18/2025 5 1001
10/17/2025 3 996
10/16/2025 3 993
10/15/2025 0 990
10/14/2025 0 990
10/13/2025 5 990
10/12/2025 5 985
10/11/2025 3 980
10/10/2025 5 977
10/9/2025 4 972
10/8/2025 0 968
10/7/2025 1 967
10/6/2025 3 966
10/5/2025 8 963
10/4/2025 9 955
10/3/2025 8 946
10/2/2025 9 938
10/1/2025 7 929
9/30/2025 8 921
9/29/2025 7 913
9/28/2025 7 907
9/27/2025 5 899
9/26/2025 5 894
9/25/2025 7 890
9/24/2025 8 882
9/23/2025 8 875
9/22/2025 8 867
9/21/2025 9 858
9/20/2025 8 850
9/19/2025 8 841
9/18/2025 9 833
9/17/2025 9 825
9/16/2025 8 815
9/15/2025 9 808
9/14/2025 9 799
9/13/2025 9 790
9/12/2025 9 781
9/11/2025 6 772
9/10/2025 6 766
9/9/2025 7 759
9/8/2025 4 752
9/7/2025 3 749
9/6/2025 4 746
9/5/2025 0 742
9/4/2025 2 741
9/3/2025 5 739
9/2/2025 8 734
9/1/2025 8 725
8/31/2025 7 718
8/30/2025 8 711
8/29/2025 8 703
8/28/2025 9 695
8/27/2025 8 686
8/26/2025 5 679
8/25/2025 5 674
8/24/2025 8 668
8/23/2025 8 660
8/22/2025 9 652
8/21/2025 8 643
8/20/2025 9 635
8/19/2025 9 626
8/18/2025 8 617
8/17/2025 8 608
8/16/2025 8 601
8/15/2025 8 592
8/14/2025 7 584
8/13/2025 9 577
8/12/2025 9 568
8/11/2025 9 558
8/10/2025 9 549
8/9/2025 10 540
8/8/2025 9 530
8/7/2025 9 522
8/6/2025 8 513
8/5/2025 9 505
8/4/2025 8 496
8/3/2025 8 488
8/2/2025 7 480
8/1/2025 8 472
7/31/2025 7 464
7/30/2025 9 457
7/29/2025 9 449
7/28/2025 9 440
7/27/2025 7 431
7/26/2025 7 424
7/25/2025 9 417
7/24/2025 9 408
7/23/2025 9 399
7/22/2025 9 389
7/21/2025 8 380
7/20/2025 8 373
7/19/2025 7 365
7/18/2025 6 358
7/17/2025 6 352
7/16/2025 9 346
7/15/2025 8 337
7/14/2025 9 329
7/13/2025 8 320
7/12/2025 10 311
7/11/2025 6 302
7/10/2025 8 296
7/9/2025 8 288
7/8/2025 6 281
7/7/2025 8 275
7/6/2025 9 267
7/5/2025 6 257
7/4/2025 7 251
7/3/2025 8 244
7/2/2025 9 236
7/1/2025 9 228
6/30/2025 9 219
6/29/2025 7 210
6/28/2025 8 203
6/27/2025 9 195
6/26/2025 8 187
6/25/2025 6 179
6/24/2025 6 173
6/23/2025 8 167
6/22/2025 10 159
6/21/2025 7 150
6/20/2025 9 142
6/19/2025 8 133
6/18/2025 8 125
6/17/2025 9 117
6/16/2025 8 108
6/15/2025 8 100
6/14/2025 8 92
6/13/2025 6 84
6/12/2025 6 77
6/11/2025 6 71
6/10/2025 4 66
6/9/2025 6 62
6/8/2025 9 55
6/7/2025 6 47
6/6/2025 4 41
6/5/2025 7 36
6/4/2025 7 30
6/3/2025 8 23
6/2/2025 7 14
6/1/2025 7 7