WIN

mbpotatoes.ca

MAFRI

Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Carberry North Wawanesa Glenboro Glenora Treherne Gladstone Portage East High Bluff Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Macdonald Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 9.3388 2017-05-15 00:00:00.0 9.3388 212
2 16.7669 2017-05-16 00:00:00.0 7.4281 212
3 18.1445 2017-05-17 00:00:00.0 1.3776 212
4 18.5685 2017-05-18 00:00:00.0 0.4240 212
5 22.3950 2017-05-19 00:00:00.0 3.8265 212
6 28.0766 2017-05-20 00:00:00.0 5.6816 212
7 29.8475 2017-05-21 00:00:00.0 1.7709 212
8 33.5613 2017-05-22 00:00:00.0 3.7138 212
9 40.7674 2017-05-23 00:00:00.0 7.2061 212
10 48.6776 2017-05-24 00:00:00.0 7.9102 212
11 56.3873 2017-05-25 00:00:00.0 7.7097 212
12 64.1649 2017-05-26 00:00:00.0 7.7776 212
13 71.9425 2017-05-27 00:00:00.0 7.7776 212
14 77.2405 2017-05-28 00:00:00.0 5.2980 212
15 79.8936 2017-05-29 00:00:00.0 2.6531 212
16 85.9426 2017-05-30 00:00:00.0 6.0490 212
17 94.9992 2017-05-31 00:00:00.0 9.0566 212
18 104.9910 2017-06-01 00:00:00.0 9.9918 212
19 113.4787 2017-06-02 00:00:00.0 8.4877 212
20 123.3293 2017-06-03 00:00:00.0 9.8506 212
21 133.1819 2017-06-04 00:00:00.0 9.8526 212
22 143.1375 2017-06-05 00:00:00.0 9.9556 212
23 153.1177 2017-06-06 00:00:00.0 9.9802 212
24 162.7988 2017-06-07 00:00:00.0 9.6811 212
25 172.7968 2017-06-08 00:00:00.0 9.9980 212
26 182.5029 2017-06-09 00:00:00.0 9.7061 212
27 192.3187 2017-06-10 00:00:00.0 9.8158 212
28 202.1345 2017-06-11 00:00:00.0 9.8158 212
29 211.3585 2017-06-12 00:00:00.0 9.2240 212
30 220.5422 2017-06-13 00:00:00.0 9.1837 212
31 229.8437 2017-06-14 00:00:00.0 9.3015 212
32 238.5167 2017-06-15 00:00:00.0 8.6730 212
33 247.3412 2017-06-16 00:00:00.0 8.8245 212
34 255.2514 2017-06-17 00:00:00.0 7.9102 212
35 262.6065 2017-06-18 00:00:00.0 7.3551 212
36 270.7698 2017-06-19 00:00:00.0 8.1633 212
37 279.2264 2017-06-20 00:00:00.0 8.4566 212
38 287.8994 2017-06-21 00:00:00.0 8.6730 212
39 296.2994 2017-06-22 00:00:00.0 8.4000 212
40 303.5805 2017-06-23 00:00:00.0 7.2811 212
41 307.8478 2017-06-24 00:00:00.0 4.2673 212
42 313.7151 2017-06-25 00:00:00.0 5.8673 212
43 322.0574 2017-06-26 00:00:00.0 8.3423 212
44 331.8533 2017-06-27 00:00:00.0 9.7959 212
45 341.6283 2017-06-28 00:00:00.0 9.7750 212
46 350.9671 2017-06-29 00:00:00.0 9.3388 212
47 359.6916 2017-06-30 00:00:00.0 8.7245 212
48 368.4666 2017-07-01 00:00:00.0 8.7750 212
49 377.2416 2017-07-02 00:00:00.0 8.7750 212
50 387.2089 2017-07-03 00:00:00.0 9.9673 212
51 396.8929 2017-07-04 00:00:00.0 9.6840 212
52 406.4472 2017-07-05 00:00:00.0 9.5543 212
53 416.2386 2017-07-06 00:00:00.0 9.7914 212
54 426.0136 2017-07-07 00:00:00.0 9.7750 212
55 436.0025 2017-07-08 00:00:00.0 9.9889 212
56 446.0013 2017-07-09 00:00:00.0 9.9988 212
57 455.9967 2017-07-10 00:00:00.0 9.9954 212
58 465.9105 2017-07-11 00:00:00.0 9.9138 212
59 474.4227 2017-07-12 00:00:00.0 8.5122 212
60 483.3895 2017-07-13 00:00:00.0 8.9668 212
61 493.3278 2017-07-14 00:00:00.0 9.9383 212
62 503.3150 2017-07-15 00:00:00.0 9.9872 212
63 513.0681 2017-07-16 00:00:00.0 9.7531 212
64 522.6224 2017-07-17 00:00:00.0 9.5543 212
65 532.1321 2017-07-18 00:00:00.0 9.5097 212
66 541.0989 2017-07-19 00:00:00.0 8.9668 212
67 550.8948 2017-07-20 00:00:00.0 9.7959 212
68 560.8213 2017-07-21 00:00:00.0 9.9265 212
69 570.3621 2017-07-22 00:00:00.0 9.5408 212
70 580.2621 2017-07-23 00:00:00.0 9.9000 212
71 590.2423 2017-07-24 00:00:00.0 9.9802 212
72 600.2295 2017-07-25 00:00:00.0 9.9872 212
73 610.2295 2017-07-26 00:00:00.0 10.0000 212
74 620.1851 2017-07-27 00:00:00.0 9.9556 212
75 630.0073 2017-07-28 00:00:00.0 9.8222 212
76 639.9629 2017-07-29 00:00:00.0 9.9556 212
77 649.1913 2017-07-30 00:00:00.0 9.2284 212
78 657.7641 2017-07-31 00:00:00.0 8.5728 212
79 667.6906 2017-08-01 00:00:00.0 9.9265 212
80 675.7294 2017-08-02 00:00:00.0 8.0388 212
81 684.7416 2017-08-03 00:00:00.0 9.0122 212
82 694.0049 2017-08-04 00:00:00.0 9.2633 212
83 703.3064 2017-08-05 00:00:00.0 9.3015 212
84 712.5304 2017-08-06 00:00:00.0 9.2240 212
85 722.3651 2017-08-07 00:00:00.0 9.8347 212
86 732.2177 2017-08-08 00:00:00.0 9.8526 212
87 741.5192 2017-08-09 00:00:00.0 9.3015 212
88 751.1192 2017-08-10 00:00:00.0 9.6000 212
89 760.4942 2017-08-11 00:00:00.0 9.3750 212
90 770.0942 2017-08-12 00:00:00.0 9.6000 212
91 779.9468 2017-08-13 00:00:00.0 9.8526 212
92 789.7994 2017-08-14 00:00:00.0 9.8526 212
93 799.4275 2017-08-15 00:00:00.0 9.6281 212
94 809.2622 2017-08-16 00:00:00.0 9.8347 212
95 818.9173 2017-08-17 00:00:00.0 9.6551 212
96 828.8438 2017-08-18 00:00:00.0 9.9265 212
97 838.8129 2017-08-19 00:00:00.0 9.9691 212
98 848.5879 2017-08-20 00:00:00.0 9.7750 212
99 856.6894 2017-08-21 00:00:00.0 8.1015 212
100 865.2562 2017-08-22 00:00:00.0 8.5668 212
101 871.6562 2017-08-23 00:00:00.0 6.4000 212
102 879.1562 2017-08-24 00:00:00.0 7.5000 212
103 888.4195 2017-08-25 00:00:00.0 9.2633 212
104 897.9292 2017-08-26 00:00:00.0 9.5097 212
105 907.7450 2017-08-27 00:00:00.0 9.8158 212
106 917.6215 2017-08-28 00:00:00.0 9.8765 212
107 927.6166 2017-08-29 00:00:00.0 9.9951 212
108 937.0268 2017-08-30 00:00:00.0 9.4102 212
109 946.4370 2017-08-31 00:00:00.0 9.4102 212
110 956.2329 2017-09-01 00:00:00.0 9.7959 212
111 965.9390 2017-09-02 00:00:00.0 9.7061 212
112 975.4487 2017-09-03 00:00:00.0 9.5097 212
113 984.1217 2017-09-04 00:00:00.0 8.6730 212
114 991.2518 2017-09-05 00:00:00.0 7.1301 212
115 997.9044 2017-09-06 00:00:00.0 6.6526 212
116 1007.2794 2017-09-07 00:00:00.0 9.3750 212
117 1014.2544 2017-09-08 00:00:00.0 6.9750 212
118 1023.3544 2017-09-09 00:00:00.0 9.1000 212
119 1033.1458 2017-09-10 00:00:00.0 9.7914 212
120 1043.0723 2017-09-11 00:00:00.0 9.9265 212
121 1052.0340 2017-09-12 00:00:00.0 8.9617 212
122 1061.4090 2017-09-13 00:00:00.0 9.3750 212
123 1068.6901 2017-09-14 00:00:00.0 7.2811 212
124 1072.5166 2017-09-15 00:00:00.0 3.8265 212
125 1074.0263 2017-09-16 00:00:00.0 1.5097 212
126 1077.0421 2017-09-17 00:00:00.0 3.0158 212
127 1082.0416 2017-09-18 00:00:00.0 4.9995 212
128 1090.4416 2017-09-19 00:00:00.0 8.4000 212
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '212') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/19/2017 8 1090
9/18/2017 5 1082
9/17/2017 3 1077
9/16/2017 2 1074
9/15/2017 4 1073
9/14/2017 7 1069
9/13/2017 9 1061
9/12/2017 9 1052
9/11/2017 10 1043
9/10/2017 10 1033
9/9/2017 9 1023
9/8/2017 7 1014
9/7/2017 9 1007
9/6/2017 7 998
9/5/2017 7 991
9/4/2017 9 984
9/3/2017 10 975
9/2/2017 10 966
9/1/2017 10 956
8/31/2017 9 946
8/30/2017 9 937
8/29/2017 10 928
8/28/2017 10 918
8/27/2017 10 908
8/26/2017 10 898
8/25/2017 9 888
8/24/2017 8 879
8/23/2017 6 872
8/22/2017 9 865
8/21/2017 8 857
8/20/2017 10 849
8/19/2017 10 839
8/18/2017 10 829
8/17/2017 10 819
8/16/2017 10 809
8/15/2017 10 799
8/14/2017 10 790
8/13/2017 10 780
8/12/2017 10 770
8/11/2017 9 760
8/10/2017 10 751
8/9/2017 9 742
8/8/2017 10 732
8/7/2017 10 722
8/6/2017 9 713
8/5/2017 9 703
8/4/2017 9 694
8/3/2017 9 685
8/2/2017 8 676
8/1/2017 10 668
7/31/2017 9 658
7/30/2017 9 649
7/29/2017 10 640
7/28/2017 10 630
7/27/2017 10 620
7/26/2017 10 610
7/25/2017 10 600
7/24/2017 10 590
7/23/2017 10 580
7/22/2017 10 570
7/21/2017 10 561
7/20/2017 10 551
7/19/2017 9 541
7/18/2017 10 532
7/17/2017 10 523
7/16/2017 10 513
7/15/2017 10 503
7/14/2017 10 493
7/13/2017 9 483
7/12/2017 9 474
7/11/2017 10 466
7/10/2017 10 456
7/9/2017 10 446
7/8/2017 10 436
7/7/2017 10 426
7/6/2017 10 416
7/5/2017 10 406
7/4/2017 10 397
7/3/2017 10 387
7/2/2017 9 377
7/1/2017 9 368
6/30/2017 9 360
6/29/2017 9 351
6/28/2017 10 342
6/27/2017 10 332
6/26/2017 8 322
6/25/2017 6 314
6/24/2017 4 308
6/23/2017 7 304
6/22/2017 8 296
6/21/2017 9 288
6/20/2017 8 279
6/19/2017 8 271
6/18/2017 7 263
6/17/2017 8 255
6/16/2017 9 247
6/15/2017 9 239
6/14/2017 9 230
6/13/2017 9 221
6/12/2017 9 211
6/11/2017 10 202
6/10/2017 10 192
6/9/2017 10 183
6/8/2017 10 173
6/7/2017 10 163
6/6/2017 10 153
6/5/2017 10 143
6/4/2017 10 133
6/3/2017 10 123
6/2/2017 8 113
6/1/2017 10 105
5/31/2017 9 95
5/30/2017 6 86
5/29/2017 3 80
5/28/2017 5 77
5/27/2017 8 72
5/26/2017 8 64
5/25/2017 8 56
5/24/2017 8 49
5/23/2017 7 41
5/22/2017 4 34
5/21/2017 2 30
5/20/2017 6 28
5/19/2017 4 22
5/18/2017 0 19
5/17/2017 1 18
5/16/2017 7 17
5/15/2017 9 9