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.6253 2024-06-06 00:00:00.0 7.5332 554
2 57.4745 2024-06-07 00:00:00.0 7.8492 554
3 65.1443 2024-06-08 00:00:00.0 7.6698 554
4 69.9083 2024-06-09 00:00:00.0 4.7640 554
5 75.5159 2024-06-10 00:00:00.0 5.6076 554
6 83.9825 2024-06-11 00:00:00.0 8.4666 554
7 92.1077 2024-06-12 00:00:00.0 8.1252 554
8 100.1732 2024-06-13 00:00:00.0 8.0655 554
9 108.6303 2024-06-14 00:00:00.0 8.4571 554
10 116.8136 2024-06-15 00:00:00.0 8.1833 554
11 126.1840 2024-06-16 00:00:00.0 9.3704 554
12 132.7082 2024-06-17 00:00:00.0 6.5242 554
13 139.0074 2024-06-18 00:00:00.0 6.2992 554
14 146.1949 2024-06-19 00:00:00.0 7.1875 554
15 154.5775 2024-06-20 00:00:00.0 8.3826 554
16 163.1792 2024-06-21 00:00:00.0 8.6017 554
17 172.4454 2024-06-22 00:00:00.0 9.2662 554
18 181.1286 2024-06-23 00:00:00.0 8.6832 554
19 189.3191 2024-06-24 00:00:00.0 8.1905 554
20 198.3265 2024-06-25 00:00:00.0 9.0074 554
21 206.2824 2024-06-26 00:00:00.0 7.9559 554
22 213.4129 2024-06-27 00:00:00.0 7.1305 554
23 219.9308 2024-06-28 00:00:00.0 6.5179 554
24 226.0734 2024-06-29 00:00:00.0 6.1426 554
25 233.3594 2024-06-30 00:00:00.0 7.2860 554
26 241.8748 2024-07-01 00:00:00.0 8.5154 554
27 251.2582 2024-07-02 00:00:00.0 9.3834 554
28 260.3249 2024-07-03 00:00:00.0 9.0667 554
29 269.5824 2024-07-04 00:00:00.0 9.2575 554
30 278.3902 2024-07-05 00:00:00.0 8.8078 554
31 287.4622 2024-07-06 00:00:00.0 9.0720 554
32 296.3474 2024-07-07 00:00:00.0 8.8852 554
33 305.4120 2024-07-08 00:00:00.0 9.0646 554
34 314.0750 2024-07-09 00:00:00.0 8.6630 554
35 322.4780 2024-07-10 00:00:00.0 8.4030 554
36 329.7902 2024-07-11 00:00:00.0 7.3122 554
37 336.5863 2024-07-12 00:00:00.0 6.7961 554
38 344.9227 2024-07-13 00:00:00.0 8.3364 554
39 353.7398 2024-07-14 00:00:00.0 8.8171 554
40 362.7482 2024-07-15 00:00:00.0 9.0084 554
41 371.1533 2024-07-16 00:00:00.0 8.4051 554
42 378.8147 2024-07-17 00:00:00.0 7.6614 554
43 387.3799 2024-07-18 00:00:00.0 8.5652 554
44 395.2744 2024-07-19 00:00:00.0 7.8945 554
45 403.3278 2024-07-20 00:00:00.0 8.0534 554
46 411.9799 2024-07-21 00:00:00.0 8.6521 554
47 421.4140 2024-07-22 00:00:00.0 9.4341 554
48 431.1225 2024-07-23 00:00:00.0 9.7085 554
49 440.2300 2024-07-24 00:00:00.0 9.1075 554
50 448.1245 2024-07-25 00:00:00.0 7.8945 554
51 457.0119 2024-07-26 00:00:00.0 8.8874 554
52 464.7311 2024-07-27 00:00:00.0 7.7192 554
53 473.9813 2024-07-28 00:00:00.0 9.2502 554
54 482.5559 2024-07-29 00:00:00.0 8.5746 554
55 490.2376 2024-07-30 00:00:00.0 7.6817 554
56 498.9930 2024-07-31 00:00:00.0 8.7554 554
57 505.8211 2024-08-01 00:00:00.0 6.8281 554
58 514.2633 2024-08-02 00:00:00.0 8.4422 554
59 523.3851 2024-08-03 00:00:00.0 9.1218 554
60 530.6056 2024-08-04 00:00:00.0 7.2205 554
61 539.0994 2024-08-05 00:00:00.0 8.4938 554
62 546.7853 2024-08-06 00:00:00.0 7.6859 554
63 554.2773 2024-08-07 00:00:00.0 7.4920 554
64 561.0112 2024-08-08 00:00:00.0 6.7339 554
65 568.8445 2024-08-09 00:00:00.0 7.8333 554
66 575.9635 2024-08-10 00:00:00.0 7.1190 554
67 584.4022 2024-08-11 00:00:00.0 8.4387 554
68 592.7608 2024-08-12 00:00:00.0 8.3586 554
69 601.4090 2024-08-13 00:00:00.0 8.6482 554
70 610.9072 2024-08-14 00:00:00.0 9.4982 554
71 620.6159 2024-08-15 00:00:00.0 9.7087 554
72 630.2218 2024-08-16 00:00:00.0 9.6059 554
73 639.0553 2024-08-17 00:00:00.0 8.8335 554
74 647.6234 2024-08-18 00:00:00.0 8.5681 554
75 656.1454 2024-08-19 00:00:00.0 8.5220 554
76 664.4691 2024-08-20 00:00:00.0 8.3237 554
77 673.1895 2024-08-21 00:00:00.0 8.7204 554
78 682.5046 2024-08-22 00:00:00.0 9.3151 554
79 691.9492 2024-08-23 00:00:00.0 9.4446 554
80 699.8307 2024-08-24 00:00:00.0 7.8815 554
81 708.1823 2024-08-25 00:00:00.0 8.3516 554
82 716.1254 2024-08-26 00:00:00.0 7.9431 554
83 723.0111 2024-08-27 00:00:00.0 6.8857 554
84 729.6806 2024-08-28 00:00:00.0 6.6695 554
85 738.5257 2024-08-29 00:00:00.0 8.8451 554
86 747.3209 2024-08-30 00:00:00.0 8.7952 554
87 755.8922 2024-08-31 00:00:00.0 8.5713 554
88 763.2629 2024-09-01 00:00:00.0 7.3707 554
89 771.1567 2024-09-02 00:00:00.0 7.8938 554
90 779.3207 2024-09-03 00:00:00.0 8.1640 554
91 788.2107 2024-09-04 00:00:00.0 8.8900 554
92 795.4747 2024-09-05 00:00:00.0 7.2640 554
93 801.4040 2024-09-06 00:00:00.0 5.9293 554
94 808.4442 2024-09-07 00:00:00.0 7.0402 554
95 816.3469 2024-09-08 00:00:00.0 7.9027 554
96 823.8273 2024-09-09 00:00:00.0 7.4804 554
97 832.6326 2024-09-10 00:00:00.0 8.8053 554
98 839.9980 2024-09-11 00:00:00.0 7.3654 554
99 847.9787 2024-09-12 00:00:00.0 7.9807 554
100 857.6458 2024-09-13 00:00:00.0 9.6671 554
101 866.3684 2024-09-14 00:00:00.0 8.7226 554
102 874.5517 2024-09-15 00:00:00.0 8.1833 554
103 883.0793 2024-09-16 00:00:00.0 8.5276 554
104 892.3858 2024-09-17 00:00:00.0 9.3065 554
105 901.5675 2024-09-18 00:00:00.0 9.1817 554
106 911.0517 2024-09-19 00:00:00.0 9.4842 554
107 919.3786 2024-09-20 00:00:00.0 8.3269 554
108 925.6997 2024-09-21 00:00:00.0 6.3211 554
109 931.0126 2024-09-22 00:00:00.0 5.3129 554
110 939.1796 2024-09-23 00:00:00.0 8.1670 554
111 947.3429 2024-09-24 00:00:00.0 8.1633 554
112 955.4324 2024-09-25 00:00:00.0 8.0895 554
113 962.6943 2024-09-26 00:00:00.0 7.2619 554
114 969.9121 2024-09-27 00:00:00.0 7.2178 554
115 978.1333 2024-09-28 00:00:00.0 8.2212 554
116 984.4884 2024-09-29 00:00:00.0 6.3551 554
117 992.1722 2024-09-30 00:00:00.0 7.6838 554
118 995.9144 2024-10-01 00:00:00.0 3.7422 554
119 1000.6768 2024-10-02 00:00:00.0 4.7624 554
120 1001.7756 2024-10-03 00:00:00.0 1.0988 554
121 1005.1961 2024-10-04 00:00:00.0 3.4205 554
122 1009.9300 2024-10-05 00:00:00.0 4.7339 554
123 1012.5489 2024-10-06 00:00:00.0 2.6189 554
124 1016.8985 2024-10-07 00:00:00.0 4.3496 554
125 1022.3168 2024-10-08 00:00:00.0 5.4183 554
126 1028.3682 2024-10-09 00:00:00.0 6.0514 554
127 1035.7360 2024-10-10 00:00:00.0 7.3678 554
128 1038.5452 2024-10-11 00:00:00.0 2.8092 554
129 1041.8023 2024-10-12 00:00:00.0 3.2571 554
130 1042.8803 2024-10-13 00:00:00.0 1.0780 554
131 1043.0525 2024-10-14 00:00:00.0 0.1722 554
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '554') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-14'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/14/2024 0 1043
10/13/2024 1 1043
10/12/2024 3 1042
10/11/2024 3 1039
10/10/2024 7 1036
10/9/2024 6 1028
10/8/2024 5 1022
10/7/2024 4 1017
10/6/2024 3 1013
10/5/2024 5 1010
10/4/2024 3 1005
10/3/2024 1 1002
10/2/2024 5 1001
10/1/2024 4 996
9/30/2024 8 992
9/29/2024 6 984
9/28/2024 8 978
9/27/2024 7 970
9/26/2024 7 963
9/25/2024 8 955
9/24/2024 8 947
9/23/2024 8 939
9/22/2024 5 931
9/21/2024 6 926
9/20/2024 8 919
9/19/2024 9 911
9/18/2024 9 902
9/17/2024 9 892
9/16/2024 9 883
9/15/2024 8 875
9/14/2024 9 866
9/13/2024 10 858
9/12/2024 8 848
9/11/2024 7 840
9/10/2024 9 833
9/9/2024 7 824
9/8/2024 8 816
9/7/2024 7 808
9/6/2024 6 801
9/5/2024 7 795
9/4/2024 9 788
9/3/2024 8 779
9/2/2024 8 771
9/1/2024 7 763
8/31/2024 9 756
8/30/2024 9 747
8/29/2024 9 739
8/28/2024 7 730
8/27/2024 7 723
8/26/2024 8 716
8/25/2024 8 708
8/24/2024 8 700
8/23/2024 9 692
8/22/2024 9 683
8/21/2024 9 673
8/20/2024 8 664
8/19/2024 9 656
8/18/2024 9 648
8/17/2024 9 639
8/16/2024 10 630
8/15/2024 10 621
8/14/2024 9 611
8/13/2024 9 601
8/12/2024 8 593
8/11/2024 8 584
8/10/2024 7 576
8/9/2024 8 569
8/8/2024 7 561
8/7/2024 7 554
8/6/2024 8 547
8/5/2024 8 539
8/4/2024 7 531
8/3/2024 9 523
8/2/2024 8 514
8/1/2024 7 506
7/31/2024 9 499
7/30/2024 8 490
7/29/2024 9 483
7/28/2024 9 474
7/27/2024 8 465
7/26/2024 9 457
7/25/2024 8 448
7/24/2024 9 440
7/23/2024 10 431
7/22/2024 9 421
7/21/2024 9 412
7/20/2024 8 403
7/19/2024 8 395
7/18/2024 9 387
7/17/2024 8 379
7/16/2024 8 371
7/15/2024 9 363
7/14/2024 9 354
7/13/2024 8 345
7/12/2024 7 337
7/11/2024 7 330
7/10/2024 8 322
7/9/2024 9 314
7/8/2024 9 305
7/7/2024 9 296
7/6/2024 9 287
7/5/2024 9 278
7/4/2024 9 270
7/3/2024 9 260
7/2/2024 9 251
7/1/2024 9 242
6/30/2024 7 233
6/29/2024 6 226
6/28/2024 7 220
6/27/2024 7 213
6/26/2024 8 206
6/25/2024 9 198
6/24/2024 8 189
6/23/2024 9 181
6/22/2024 9 172
6/21/2024 9 163
6/20/2024 8 155
6/19/2024 7 146
6/18/2024 6 139
6/17/2024 7 133
6/16/2024 9 126
6/15/2024 8 117
6/14/2024 8 109
6/13/2024 8 100
6/12/2024 8 92
6/11/2024 8 84
6/10/2024 6 76
6/9/2024 5 70
6/8/2024 8 65
6/7/2024 8 57