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 7.9750 2017-05-15 00:00:00.0 7.9750 204
2 14.5444 2017-05-16 00:00:00.0 6.5694 204
3 14.5444 2017-05-17 00:00:00.0 0.0000 204
4 14.5444 2017-05-18 00:00:00.0 0.0000 204
5 16.5725 2017-05-19 00:00:00.0 2.0281 204
6 21.8705 2017-05-20 00:00:00.0 5.2980 204
7 24.8863 2017-05-21 00:00:00.0 3.0158 204
8 30.6613 2017-05-22 00:00:00.0 5.7750 204
9 37.8674 2017-05-23 00:00:00.0 7.2061 204
10 46.0914 2017-05-24 00:00:00.0 8.2240 204
11 53.2215 2017-05-25 00:00:00.0 7.1301 204
12 60.1174 2017-05-26 00:00:00.0 6.8959 204
13 67.7582 2017-05-27 00:00:00.0 7.6408 204
14 72.3454 2017-05-28 00:00:00.0 4.5872 204
15 74.8755 2017-05-29 00:00:00.0 2.5301 204
16 81.3607 2017-05-30 00:00:00.0 6.4852 204
17 90.0852 2017-05-31 00:00:00.0 8.7245 204
18 97.9074 2017-06-01 00:00:00.0 7.8222 204
19 107.4136 2017-06-02 00:00:00.0 9.5062 204
20 117.4116 2017-06-03 00:00:00.0 9.9980 204
21 126.8892 2017-06-04 00:00:00.0 9.4776 204
22 136.8157 2017-06-05 00:00:00.0 9.9265 204
23 146.7295 2017-06-06 00:00:00.0 9.9138 204
24 156.0683 2017-06-07 00:00:00.0 9.3388 204
25 165.7744 2017-06-08 00:00:00.0 9.7061 204
26 174.9167 2017-06-09 00:00:00.0 9.1423 204
27 184.3611 2017-06-10 00:00:00.0 9.4444 204
28 193.2341 2017-06-11 00:00:00.0 8.8730 204
29 201.6341 2017-06-12 00:00:00.0 8.4000 204
30 209.9178 2017-06-13 00:00:00.0 8.2837 204
31 218.7908 2017-06-14 00:00:00.0 8.8730 204
32 227.1331 2017-06-15 00:00:00.0 8.3423 204
33 234.6331 2017-06-16 00:00:00.0 7.5000 204
34 241.6862 2017-06-17 00:00:00.0 7.0531 204
35 248.8163 2017-06-18 00:00:00.0 7.1301 204
36 256.1714 2017-06-19 00:00:00.0 7.3551 204
37 264.5137 2017-06-20 00:00:00.0 8.3423 204
38 273.3382 2017-06-21 00:00:00.0 8.8245 204
39 281.2484 2017-06-22 00:00:00.0 7.9102 204
40 287.8178 2017-06-23 00:00:00.0 6.5694 204
41 292.7158 2017-06-24 00:00:00.0 4.8980 204
42 298.7648 2017-06-25 00:00:00.0 6.0490 204
43 307.1071 2017-06-26 00:00:00.0 8.3423 204
44 316.9597 2017-06-27 00:00:00.0 9.8526 204
45 326.9184 2017-06-28 00:00:00.0 9.9587 204
46 336.2199 2017-06-29 00:00:00.0 9.3015 204
47 344.6765 2017-06-30 00:00:00.0 8.4566 204
48 353.5010 2017-07-01 00:00:00.0 8.8245 204
49 361.7847 2017-07-02 00:00:00.0 8.2837 204
50 371.7520 2017-07-03 00:00:00.0 9.9673 204
51 381.6520 2017-07-04 00:00:00.0 9.9000 204
52 391.6076 2017-07-05 00:00:00.0 9.9556 204
53 401.5632 2017-07-06 00:00:00.0 9.9556 204
54 411.3163 2017-07-07 00:00:00.0 9.7531 204
55 421.3052 2017-07-08 00:00:00.0 9.9889 204
56 431.2725 2017-07-09 00:00:00.0 9.9673 204
57 441.2597 2017-07-10 00:00:00.0 9.9872 204
58 450.8878 2017-07-11 00:00:00.0 9.6281 204
59 460.1511 2017-07-12 00:00:00.0 9.2633 204
60 469.5261 2017-07-13 00:00:00.0 9.3750 204
61 479.5150 2017-07-14 00:00:00.0 9.9889 204
62 489.4900 2017-07-15 00:00:00.0 9.9750 204
63 499.4390 2017-07-16 00:00:00.0 9.9490 204
64 508.8946 2017-07-17 00:00:00.0 9.4556 204
65 518.2334 2017-07-18 00:00:00.0 9.3388 204
66 527.8334 2017-07-19 00:00:00.0 9.6000 204
67 537.4334 2017-07-20 00:00:00.0 9.6000 204
68 547.2293 2017-07-21 00:00:00.0 9.7959 204
69 556.7701 2017-07-22 00:00:00.0 9.5408 204
70 566.6701 2017-07-23 00:00:00.0 9.9000 204
71 576.4281 2017-07-24 00:00:00.0 9.7580 204
72 586.3954 2017-07-25 00:00:00.0 9.9673 204
73 596.3905 2017-07-26 00:00:00.0 9.9951 204
74 606.3461 2017-07-27 00:00:00.0 9.9556 204
75 615.8017 2017-07-28 00:00:00.0 9.4556 204
76 625.4857 2017-07-29 00:00:00.0 9.6840 204
77 635.1289 2017-07-30 00:00:00.0 9.6432 204
78 644.0178 2017-07-31 00:00:00.0 8.8889 204
79 653.8704 2017-08-01 00:00:00.0 9.8526 204
80 662.2704 2017-08-02 00:00:00.0 8.4000 204
81 671.3704 2017-08-03 00:00:00.0 9.1000 204
82 680.9704 2017-08-04 00:00:00.0 9.6000 204
83 690.3454 2017-08-05 00:00:00.0 9.3750 204
84 699.5291 2017-08-06 00:00:00.0 9.1837 204
85 709.4291 2017-08-07 00:00:00.0 9.9000 204
86 718.8393 2017-08-08 00:00:00.0 9.4102 204
87 727.8515 2017-08-09 00:00:00.0 9.0122 204
88 737.1148 2017-08-10 00:00:00.0 9.2633 204
89 746.6245 2017-08-11 00:00:00.0 9.5097 204
90 756.2796 2017-08-12 00:00:00.0 9.6551 204
91 765.9077 2017-08-13 00:00:00.0 9.6281 204
92 775.6138 2017-08-14 00:00:00.0 9.7061 204
93 784.9153 2017-08-15 00:00:00.0 9.3015 204
94 794.7311 2017-08-16 00:00:00.0 9.8158 204
95 804.3592 2017-08-17 00:00:00.0 9.6281 204
96 814.3342 2017-08-18 00:00:00.0 9.9750 204
97 824.2552 2017-08-19 00:00:00.0 9.9210 204
98 833.8552 2017-08-20 00:00:00.0 9.6000 204
99 842.1389 2017-08-21 00:00:00.0 8.2837 204
100 850.8119 2017-08-22 00:00:00.0 8.6730 204
101 857.9420 2017-08-23 00:00:00.0 7.1301 204
102 864.4272 2017-08-24 00:00:00.0 6.4852 204
103 874.0272 2017-08-25 00:00:00.0 9.6000 204
104 883.1695 2017-08-26 00:00:00.0 9.1423 204
105 892.8506 2017-08-27 00:00:00.0 9.6811 204
106 902.8501 2017-08-28 00:00:00.0 9.9995 204
107 912.8419 2017-08-29 00:00:00.0 9.9918 204
108 921.0052 2017-08-30 00:00:00.0 8.1633 204
109 930.4496 2017-08-31 00:00:00.0 9.4444 204
110 940.4491 2017-09-01 00:00:00.0 9.9995 204
111 950.1042 2017-09-02 00:00:00.0 9.6551 204
112 959.2879 2017-09-03 00:00:00.0 9.1837 204
113 967.5716 2017-09-04 00:00:00.0 8.2837 204
114 974.2242 2017-09-05 00:00:00.0 6.6526 204
115 981.6523 2017-09-06 00:00:00.0 7.4281 204
116 990.6191 2017-09-07 00:00:00.0 8.9668 204
117 997.7492 2017-09-08 00:00:00.0 7.1301 204
118 1006.9329 2017-09-09 00:00:00.0 9.1837 204
119 1016.6909 2017-09-10 00:00:00.0 9.7580 204
120 1026.3190 2017-09-11 00:00:00.0 9.6281 204
121 1036.3185 2017-09-12 00:00:00.0 9.9995 204
122 1044.6022 2017-09-13 00:00:00.0 8.2837 204
123 1049.6017 2017-09-14 00:00:00.0 4.9995 204
124 1053.3155 2017-09-15 00:00:00.0 3.7138 204
125 1055.0864 2017-09-16 00:00:00.0 1.7709 204
126 1057.6165 2017-09-17 00:00:00.0 2.5301 204
127 1062.6160 2017-09-18 00:00:00.0 4.9995 204
128 1069.2686 2017-09-19 00:00:00.0 6.6526 204
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '204') 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 7 1069
9/18/2017 5 1063
9/17/2017 3 1058
9/16/2017 2 1055
9/15/2017 4 1053
9/14/2017 5 1050
9/13/2017 8 1045
9/12/2017 10 1036
9/11/2017 10 1026
9/10/2017 10 1017
9/9/2017 9 1007
9/8/2017 7 998
9/7/2017 9 991
9/6/2017 7 982
9/5/2017 7 974
9/4/2017 8 968
9/3/2017 9 959
9/2/2017 10 950
9/1/2017 10 940
8/31/2017 9 930
8/30/2017 8 921
8/29/2017 10 913
8/28/2017 10 903
8/27/2017 10 893
8/26/2017 9 883
8/25/2017 10 874
8/24/2017 6 864
8/23/2017 7 858
8/22/2017 9 851
8/21/2017 8 842
8/20/2017 10 834
8/19/2017 10 824
8/18/2017 10 814
8/17/2017 10 804
8/16/2017 10 795
8/15/2017 9 785
8/14/2017 10 776
8/13/2017 10 766
8/12/2017 10 756
8/11/2017 10 747
8/10/2017 9 737
8/9/2017 9 728
8/8/2017 9 719
8/7/2017 10 709
8/6/2017 9 700
8/5/2017 9 690
8/4/2017 10 681
8/3/2017 9 671
8/2/2017 8 662
8/1/2017 10 654
7/31/2017 9 644
7/30/2017 10 635
7/29/2017 10 625
7/28/2017 9 616
7/27/2017 10 606
7/26/2017 10 596
7/25/2017 10 586
7/24/2017 10 576
7/23/2017 10 567
7/22/2017 10 557
7/21/2017 10 547
7/20/2017 10 537
7/19/2017 10 528
7/18/2017 9 518
7/17/2017 9 509
7/16/2017 10 499
7/15/2017 10 489
7/14/2017 10 480
7/13/2017 9 470
7/12/2017 9 460
7/11/2017 10 451
7/10/2017 10 441
7/9/2017 10 431
7/8/2017 10 421
7/7/2017 10 411
7/6/2017 10 402
7/5/2017 10 392
7/4/2017 10 382
7/3/2017 10 372
7/2/2017 8 362
7/1/2017 9 354
6/30/2017 8 345
6/29/2017 9 336
6/28/2017 10 327
6/27/2017 10 317
6/26/2017 8 307
6/25/2017 6 299
6/24/2017 5 293
6/23/2017 7 288
6/22/2017 8 281
6/21/2017 9 273
6/20/2017 8 265
6/19/2017 7 256
6/18/2017 7 249
6/17/2017 7 242
6/16/2017 8 235
6/15/2017 8 227
6/14/2017 9 219
6/13/2017 8 210
6/12/2017 8 202
6/11/2017 9 193
6/10/2017 9 184
6/9/2017 9 175
6/8/2017 10 166
6/7/2017 9 156
6/6/2017 10 147
6/5/2017 10 137
6/4/2017 9 127
6/3/2017 10 117
6/2/2017 10 107
6/1/2017 8 98
5/31/2017 9 90
5/30/2017 6 81
5/29/2017 3 75
5/28/2017 5 72
5/27/2017 8 68
5/26/2017 7 60
5/25/2017 7 53
5/24/2017 8 46
5/23/2017 7 38
5/22/2017 6 31
5/21/2017 3 25
5/20/2017 5 22
5/19/2017 2 17
5/18/2017 0 15
5/17/2017 0 15
5/16/2017 7 15
5/15/2017 8 8