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 8.2240 2017-05-25 00:00:00.0 8.2240 362
2 16.4480 2017-05-26 00:00:00.0 8.2240 362
3 24.8480 2017-05-27 00:00:00.0 8.4000 362
4 30.0475 2017-05-28 00:00:00.0 5.1995 362
5 32.2026 2017-05-29 00:00:00.0 2.1551 362
6 38.8552 2017-05-30 00:00:00.0 6.6526 362
7 47.9975 2017-05-31 00:00:00.0 9.1423 362
8 57.9370 2017-06-01 00:00:00.0 9.9395 362
9 66.5926 2017-06-02 00:00:00.0 8.6556 362
10 76.4691 2017-06-03 00:00:00.0 9.8765 362
11 86.1502 2017-06-04 00:00:00.0 9.6811 362
12 96.1304 2017-06-05 00:00:00.0 9.9802 362
13 105.6401 2017-06-06 00:00:00.0 9.5097 362
14 115.2110 2017-06-07 00:00:00.0 9.5709 362
15 125.1110 2017-06-08 00:00:00.0 9.9000 362
16 134.1676 2017-06-09 00:00:00.0 9.0566 362
17 143.7957 2017-06-10 00:00:00.0 9.6281 362
18 152.9380 2017-06-11 00:00:00.0 9.1423 362
19 161.7625 2017-06-12 00:00:00.0 8.8245 362
20 170.5375 2017-06-13 00:00:00.0 8.7750 362
21 178.2472 2017-06-14 00:00:00.0 7.7097 362
22 185.9569 2017-06-15 00:00:00.0 7.7097 362
23 194.1202 2017-06-16 00:00:00.0 8.1633 362
24 201.5483 2017-06-17 00:00:00.0 7.4281 362
25 208.7544 2017-06-18 00:00:00.0 7.2061 362
26 216.6646 2017-06-19 00:00:00.0 7.9102 362
27 224.7034 2017-06-20 00:00:00.0 8.0388 362
28 233.9274 2017-06-21 00:00:00.0 9.2240 362
29 241.6371 2017-06-22 00:00:00.0 7.7097 362
30 247.0325 2017-06-23 00:00:00.0 5.3954 362
31 251.0815 2017-06-24 00:00:00.0 4.0490 362
32 257.0402 2017-06-25 00:00:00.0 5.9587 362
33 264.9504 2017-06-26 00:00:00.0 7.9102 362
34 274.7662 2017-06-27 00:00:00.0 9.8158 362
35 284.6356 2017-06-28 00:00:00.0 9.8694 362
36 293.6024 2017-06-29 00:00:00.0 8.9668 362
37 301.9447 2017-06-30 00:00:00.0 8.3423 362
38 311.0013 2017-07-01 00:00:00.0 9.0566 362
39 319.6217 2017-07-02 00:00:00.0 8.6204 362
40 329.6019 2017-07-03 00:00:00.0 9.9802 362
41 339.5019 2017-07-04 00:00:00.0 9.9000 362
42 349.5007 2017-07-05 00:00:00.0 9.9988 362
43 359.4594 2017-07-06 00:00:00.0 9.9587 362
44 369.2553 2017-07-07 00:00:00.0 9.7959 362
45 379.2541 2017-07-08 00:00:00.0 9.9988 362
46 389.2529 2017-07-09 00:00:00.0 9.9988 362
47 399.1924 2017-07-10 00:00:00.0 9.9395 362
48 408.8475 2017-07-11 00:00:00.0 9.6551 362
49 418.1490 2017-07-12 00:00:00.0 9.3015 362
50 427.4878 2017-07-13 00:00:00.0 9.3388 362
51 437.4551 2017-07-14 00:00:00.0 9.9673 362
52 447.3816 2017-07-15 00:00:00.0 9.9265 362
53 457.3199 2017-07-16 00:00:00.0 9.9383 362
54 467.2786 2017-07-17 00:00:00.0 9.9587 362
55 475.9516 2017-07-18 00:00:00.0 8.6730 362
56 485.3618 2017-07-19 00:00:00.0 9.4102 362
57 495.0919 2017-07-20 00:00:00.0 9.7301 362
58 505.0735 2017-07-21 00:00:00.0 9.9816 362
59 514.2975 2017-07-22 00:00:00.0 9.2240 362
60 524.0934 2017-07-23 00:00:00.0 9.7959 362
61 533.9156 2017-07-24 00:00:00.0 9.8222 362
62 543.2171 2017-07-25 00:00:00.0 9.3015 362
63 553.2043 2017-07-26 00:00:00.0 9.9872 362
64 563.1994 2017-07-27 00:00:00.0 9.9951 362
65 572.6019 2017-07-28 00:00:00.0 9.4025 362
66 582.3599 2017-07-29 00:00:00.0 9.7580 362
67 591.4599 2017-07-30 00:00:00.0 9.1000 362
68 600.6883 2017-07-31 00:00:00.0 9.2284 362
69 610.4414 2017-08-01 00:00:00.0 9.7531 362
70 617.6475 2017-08-02 00:00:00.0 7.2061 362
71 626.3720 2017-08-03 00:00:00.0 8.7245 362
72 635.7822 2017-08-04 00:00:00.0 9.4102 362
73 645.1210 2017-08-05 00:00:00.0 9.3388 362
74 654.2633 2017-08-06 00:00:00.0 9.1423 362
75 663.9694 2017-08-07 00:00:00.0 9.7061 362
76 673.6245 2017-08-08 00:00:00.0 9.6551 362
77 681.8485 2017-08-09 00:00:00.0 8.2240 362
78 690.8607 2017-08-10 00:00:00.0 9.0122 362
79 700.2357 2017-08-11 00:00:00.0 9.3750 362
80 709.6801 2017-08-12 00:00:00.0 9.4444 362
81 719.2801 2017-08-13 00:00:00.0 9.6000 362
82 729.0760 2017-08-14 00:00:00.0 9.7959 362
83 738.3775 2017-08-15 00:00:00.0 9.3015 362
84 748.1933 2017-08-16 00:00:00.0 9.8158 362
85 757.6035 2017-08-17 00:00:00.0 9.4102 362
86 767.3994 2017-08-18 00:00:00.0 9.7959 362
87 777.3912 2017-08-19 00:00:00.0 9.9918 362
88 786.2642 2017-08-20 00:00:00.0 8.8730 362
89 794.9372 2017-08-21 00:00:00.0 8.6730 362
90 803.2795 2017-08-22 00:00:00.0 8.3423 362
91 810.3326 2017-08-23 00:00:00.0 7.0531 362
92 818.1102 2017-08-24 00:00:00.0 7.7776 362
93 827.7653 2017-08-25 00:00:00.0 9.6551 362
94 837.1403 2017-08-26 00:00:00.0 9.3750 362
95 846.8464 2017-08-27 00:00:00.0 9.7061 362
96 856.8444 2017-08-28 00:00:00.0 9.9980 362
97 866.8117 2017-08-29 00:00:00.0 9.9673 362
98 875.5867 2017-08-30 00:00:00.0 8.7750 362
99 885.5250 2017-08-31 00:00:00.0 9.9383 362
100 895.5204 2017-09-01 00:00:00.0 9.9954 362
101 905.1204 2017-09-02 00:00:00.0 9.6000 362
102 914.6301 2017-09-03 00:00:00.0 9.5097 362
103 922.3398 2017-09-04 00:00:00.0 7.7097 362
104 928.1148 2017-09-05 00:00:00.0 5.7750 362
105 936.2781 2017-09-06 00:00:00.0 8.1633 362
106 944.5021 2017-09-07 00:00:00.0 8.2240 362
107 952.7261 2017-09-08 00:00:00.0 8.2240 362
108 962.1363 2017-09-09 00:00:00.0 9.4102 362
109 972.1235 2017-09-10 00:00:00.0 9.9872 362
110 981.5679 2017-09-11 00:00:00.0 9.4444 362
111 991.4679 2017-09-12 00:00:00.0 9.9000 362
112 1000.0347 2017-09-13 00:00:00.0 8.5668 362
113 1005.4301 2017-09-14 00:00:00.0 5.3954 362
114 1008.2051 2017-09-15 00:00:00.0 2.7750 362
115 1009.0439 2017-09-16 00:00:00.0 0.8388 362
116 1010.4215 2017-09-17 00:00:00.0 1.3776 362
117 1016.0087 2017-09-18 00:00:00.0 5.5872 362
118 1023.5796 2017-09-19 00:00:00.0 7.5709 362
CACHED false
EXECUTIONTIME 3
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '362') 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 1024
9/18/2017 6 1016
9/17/2017 1 1010
9/16/2017 1 1009
9/15/2017 3 1008
9/14/2017 5 1005
9/13/2017 9 1000
9/12/2017 10 991
9/11/2017 9 982
9/10/2017 10 972
9/9/2017 9 962
9/8/2017 8 953
9/7/2017 8 945
9/6/2017 8 936
9/5/2017 6 928
9/4/2017 8 922
9/3/2017 10 915
9/2/2017 10 905
9/1/2017 10 896
8/31/2017 10 886
8/30/2017 9 876
8/29/2017 10 867
8/28/2017 10 857
8/27/2017 10 847
8/26/2017 9 837
8/25/2017 10 828
8/24/2017 8 818
8/23/2017 7 810
8/22/2017 8 803
8/21/2017 9 795
8/20/2017 9 786
8/19/2017 10 777
8/18/2017 10 767
8/17/2017 9 758
8/16/2017 10 748
8/15/2017 9 738
8/14/2017 10 729
8/13/2017 10 719
8/12/2017 9 710
8/11/2017 9 700
8/10/2017 9 691
8/9/2017 8 682
8/8/2017 10 674
8/7/2017 10 664
8/6/2017 9 654
8/5/2017 9 645
8/4/2017 9 636
8/3/2017 9 626
8/2/2017 7 618
8/1/2017 10 610
7/31/2017 9 601
7/30/2017 9 591
7/29/2017 10 582
7/28/2017 9 573
7/27/2017 10 563
7/26/2017 10 553
7/25/2017 9 543
7/24/2017 10 534
7/23/2017 10 524
7/22/2017 9 514
7/21/2017 10 505
7/20/2017 10 495
7/19/2017 9 485
7/18/2017 9 476
7/17/2017 10 467
7/16/2017 10 457
7/15/2017 10 447
7/14/2017 10 437
7/13/2017 9 427
7/12/2017 9 418
7/11/2017 10 409
7/10/2017 10 399
7/9/2017 10 389
7/8/2017 10 379
7/7/2017 10 369
7/6/2017 10 359
7/5/2017 10 350
7/4/2017 10 340
7/3/2017 10 330
7/2/2017 9 320
7/1/2017 9 311
6/30/2017 8 302
6/29/2017 9 294
6/28/2017 10 285
6/27/2017 10 275
6/26/2017 8 265
6/25/2017 6 257
6/24/2017 4 251
6/23/2017 5 247
6/22/2017 8 242
6/21/2017 9 234
6/20/2017 8 225
6/19/2017 8 217
6/18/2017 7 209
6/17/2017 7 202
6/16/2017 8 194
6/15/2017 8 186
6/14/2017 8 178
6/13/2017 9 171
6/12/2017 9 162
6/11/2017 9 153
6/10/2017 10 144
6/9/2017 9 134
6/8/2017 10 125
6/7/2017 10 115
6/6/2017 10 106
6/5/2017 10 96
6/4/2017 10 86
6/3/2017 10 76
6/2/2017 9 67
6/1/2017 10 58
5/31/2017 9 48
5/30/2017 7 39
5/29/2017 2 32
5/28/2017 5 30
5/27/2017 8 25
5/26/2017 8 16
5/25/2017 8 8