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.4444 2017-05-15 00:00:00.0 9.4444 230
2 16.7995 2017-05-16 00:00:00.0 7.3551 230
3 18.9546 2017-05-17 00:00:00.0 2.1551 230
4 20.1990 2017-05-18 00:00:00.0 1.2444 230
5 24.3577 2017-05-19 00:00:00.0 4.1587 230
6 29.1531 2017-05-20 00:00:00.0 4.7954 230
7 30.3975 2017-05-21 00:00:00.0 1.2444 230
8 33.9975 2017-05-22 00:00:00.0 3.6000 230
9 40.9725 2017-05-23 00:00:00.0 6.9750 230
10 48.9475 2017-05-24 00:00:00.0 7.9750 230
11 56.8577 2017-05-25 00:00:00.0 7.9102 230
12 64.7679 2017-05-26 00:00:00.0 7.9102 230
13 73.2801 2017-05-27 00:00:00.0 8.5122 230
14 79.2388 2017-05-28 00:00:00.0 5.9587 230
15 82.6082 2017-05-29 00:00:00.0 3.3694 230
16 88.8347 2017-05-30 00:00:00.0 6.2265 230
17 98.0980 2017-05-31 00:00:00.0 9.2633 230
18 108.0980 2017-06-01 00:00:00.0 10.0000 230
19 116.5857 2017-06-02 00:00:00.0 8.4877 230
20 126.2289 2017-06-03 00:00:00.0 9.6432 230
21 136.2178 2017-06-04 00:00:00.0 9.9889 230
22 146.1178 2017-06-05 00:00:00.0 9.9000 230
23 156.0178 2017-06-06 00:00:00.0 9.9000 230
24 165.7709 2017-06-07 00:00:00.0 9.7531 230
25 175.7709 2017-06-08 00:00:00.0 10.0000 230
26 185.5010 2017-06-09 00:00:00.0 9.7301 230
27 195.4010 2017-06-10 00:00:00.0 9.9000 230
28 205.3597 2017-06-11 00:00:00.0 9.9587 230
29 214.8041 2017-06-12 00:00:00.0 9.4444 230
30 223.6771 2017-06-13 00:00:00.0 8.8730 230
31 233.0159 2017-06-14 00:00:00.0 9.3388 230
32 241.9363 2017-06-15 00:00:00.0 8.9204 230
33 251.2751 2017-06-16 00:00:00.0 9.3388 230
34 259.3766 2017-06-17 00:00:00.0 8.1015 230
35 267.0863 2017-06-18 00:00:00.0 7.7097 230
36 275.3700 2017-06-19 00:00:00.0 8.2837 230
37 283.9368 2017-06-20 00:00:00.0 8.5668 230
38 293.2756 2017-06-21 00:00:00.0 9.3388 230
39 302.1960 2017-06-22 00:00:00.0 8.9204 230
40 309.8368 2017-06-23 00:00:00.0 7.6408 230
41 314.3184 2017-06-24 00:00:00.0 4.4816 230
42 320.0934 2017-06-25 00:00:00.0 5.7750 230
43 328.7664 2017-06-26 00:00:00.0 8.6730 230
44 338.6802 2017-06-27 00:00:00.0 9.9138 230
45 348.4960 2017-06-28 00:00:00.0 9.8158 230
46 357.7975 2017-06-29 00:00:00.0 9.3015 230
47 366.6220 2017-06-30 00:00:00.0 8.8245 230
48 375.4465 2017-07-01 00:00:00.0 8.8245 230
49 384.2215 2017-07-02 00:00:00.0 8.7750 230
50 394.1598 2017-07-03 00:00:00.0 9.9383 230
51 403.1919 2017-07-04 00:00:00.0 9.0321 230
52 412.6475 2017-07-05 00:00:00.0 9.4556 230
53 422.3315 2017-07-06 00:00:00.0 9.6840 230
54 432.1065 2017-07-07 00:00:00.0 9.7750 230
55 442.0460 2017-07-08 00:00:00.0 9.9395 230
56 451.9855 2017-07-09 00:00:00.0 9.9395 230
57 461.9843 2017-07-10 00:00:00.0 9.9988 230
58 471.9732 2017-07-11 00:00:00.0 9.9889 230
59 480.4854 2017-07-12 00:00:00.0 8.5122 230
60 489.4976 2017-07-13 00:00:00.0 9.0122 230
61 499.4848 2017-07-14 00:00:00.0 9.9872 230
62 509.4802 2017-07-15 00:00:00.0 9.9954 230
63 519.3496 2017-07-16 00:00:00.0 9.8694 230
64 529.1410 2017-07-17 00:00:00.0 9.7914 230
65 538.7961 2017-07-18 00:00:00.0 9.6551 230
66 547.8083 2017-07-19 00:00:00.0 9.0122 230
67 557.6430 2017-07-20 00:00:00.0 9.8347 230
68 567.6302 2017-07-21 00:00:00.0 9.9872 230
69 577.3113 2017-07-22 00:00:00.0 9.6811 230
70 587.2496 2017-07-23 00:00:00.0 9.9383 230
71 597.1706 2017-07-24 00:00:00.0 9.9210 230
72 607.1701 2017-07-25 00:00:00.0 9.9995 230
73 617.1655 2017-07-26 00:00:00.0 9.9954 230
74 627.1050 2017-07-27 00:00:00.0 9.9395 230
75 636.7890 2017-07-28 00:00:00.0 9.6840 230
76 646.3433 2017-07-29 00:00:00.0 9.5543 230
77 655.3050 2017-07-30 00:00:00.0 8.9617 230
78 663.2297 2017-07-31 00:00:00.0 7.9247 230
79 673.1970 2017-08-01 00:00:00.0 9.9673 230
80 681.2358 2017-08-02 00:00:00.0 8.0388 230
81 690.2924 2017-08-03 00:00:00.0 9.0566 230
82 699.4347 2017-08-04 00:00:00.0 9.1423 230
83 708.8097 2017-08-05 00:00:00.0 9.3750 230
84 718.0730 2017-08-06 00:00:00.0 9.2633 230
85 727.8031 2017-08-07 00:00:00.0 9.7301 230
86 737.5990 2017-08-08 00:00:00.0 9.7959 230
87 746.6990 2017-08-09 00:00:00.0 9.1000 230
88 756.4051 2017-08-10 00:00:00.0 9.7061 230
89 765.7801 2017-08-11 00:00:00.0 9.3750 230
90 775.3801 2017-08-12 00:00:00.0 9.6000 230
91 785.1102 2017-08-13 00:00:00.0 9.7301 230
92 794.9260 2017-08-14 00:00:00.0 9.8158 230
93 804.5541 2017-08-15 00:00:00.0 9.6281 230
94 814.2352 2017-08-16 00:00:00.0 9.6811 230
95 823.8903 2017-08-17 00:00:00.0 9.6551 230
96 833.8041 2017-08-18 00:00:00.0 9.9138 230
97 843.6263 2017-08-19 00:00:00.0 9.8222 230
98 853.3324 2017-08-20 00:00:00.0 9.7061 230
99 861.6747 2017-08-21 00:00:00.0 8.3423 230
100 870.3477 2017-08-22 00:00:00.0 8.6730 230
101 876.7477 2017-08-23 00:00:00.0 6.4000 230
102 883.8778 2017-08-24 00:00:00.0 7.1301 230
103 893.0615 2017-08-25 00:00:00.0 9.1837 230
104 902.5059 2017-08-26 00:00:00.0 9.4444 230
105 912.3018 2017-08-27 00:00:00.0 9.7959 230
106 922.2413 2017-08-28 00:00:00.0 9.9395 230
107 931.7475 2017-08-29 00:00:00.0 9.5062 230
108 941.0863 2017-08-30 00:00:00.0 9.3388 230
109 950.4251 2017-08-31 00:00:00.0 9.3388 230
110 960.2001 2017-09-01 00:00:00.0 9.7750 230
111 969.9302 2017-09-02 00:00:00.0 9.7301 230
112 979.7460 2017-09-03 00:00:00.0 9.8158 230
113 988.3128 2017-09-04 00:00:00.0 8.5668 230
114 995.7409 2017-09-05 00:00:00.0 7.4281 230
115 1002.3935 2017-09-06 00:00:00.0 6.6526 230
116 1011.8037 2017-09-07 00:00:00.0 9.4102 230
117 1018.2037 2017-09-08 00:00:00.0 6.4000 230
118 1027.0767 2017-09-09 00:00:00.0 8.8730 230
119 1037.0323 2017-09-10 00:00:00.0 9.9556 230
120 1046.9813 2017-09-11 00:00:00.0 9.9490 230
121 1055.9430 2017-09-12 00:00:00.0 8.9617 230
122 1065.4527 2017-09-13 00:00:00.0 9.5097 230
123 1073.0935 2017-09-14 00:00:00.0 7.6408 230
124 1076.8073 2017-09-15 00:00:00.0 3.7138 230
125 1078.3170 2017-09-16 00:00:00.0 1.5097 230
126 1081.8022 2017-09-17 00:00:00.0 3.4852 230
127 1087.7609 2017-09-18 00:00:00.0 5.9587 230
128 1096.2731 2017-09-19 00:00:00.0 8.5122 230
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '230') 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 9 1096
9/18/2017 6 1088
9/17/2017 3 1082
9/16/2017 2 1078
9/15/2017 4 1077
9/14/2017 8 1073
9/13/2017 10 1065
9/12/2017 9 1056
9/11/2017 10 1047
9/10/2017 10 1037
9/9/2017 9 1027
9/8/2017 6 1018
9/7/2017 9 1012
9/6/2017 7 1002
9/5/2017 7 996
9/4/2017 9 988
9/3/2017 10 980
9/2/2017 10 970
9/1/2017 10 960
8/31/2017 9 950
8/30/2017 9 941
8/29/2017 10 932
8/28/2017 10 922
8/27/2017 10 912
8/26/2017 9 903
8/25/2017 9 893
8/24/2017 7 884
8/23/2017 6 877
8/22/2017 9 870
8/21/2017 8 862
8/20/2017 10 853
8/19/2017 10 844
8/18/2017 10 834
8/17/2017 10 824
8/16/2017 10 814
8/15/2017 10 805
8/14/2017 10 795
8/13/2017 10 785
8/12/2017 10 775
8/11/2017 9 766
8/10/2017 10 756
8/9/2017 9 747
8/8/2017 10 738
8/7/2017 10 728
8/6/2017 9 718
8/5/2017 9 709
8/4/2017 9 699
8/3/2017 9 690
8/2/2017 8 681
8/1/2017 10 673
7/31/2017 8 663
7/30/2017 9 655
7/29/2017 10 646
7/28/2017 10 637
7/27/2017 10 627
7/26/2017 10 617
7/25/2017 10 607
7/24/2017 10 597
7/23/2017 10 587
7/22/2017 10 577
7/21/2017 10 568
7/20/2017 10 558
7/19/2017 9 548
7/18/2017 10 539
7/17/2017 10 529
7/16/2017 10 519
7/15/2017 10 509
7/14/2017 10 499
7/13/2017 9 489
7/12/2017 9 480
7/11/2017 10 472
7/10/2017 10 462
7/9/2017 10 452
7/8/2017 10 442
7/7/2017 10 432
7/6/2017 10 422
7/5/2017 9 413
7/4/2017 9 403
7/3/2017 10 394
7/2/2017 9 384
7/1/2017 9 375
6/30/2017 9 367
6/29/2017 9 358
6/28/2017 10 348
6/27/2017 10 339
6/26/2017 9 329
6/25/2017 6 320
6/24/2017 4 314
6/23/2017 8 310
6/22/2017 9 302
6/21/2017 9 293
6/20/2017 9 284
6/19/2017 8 275
6/18/2017 8 267
6/17/2017 8 259
6/16/2017 9 251
6/15/2017 9 242
6/14/2017 9 233
6/13/2017 9 224
6/12/2017 9 215
6/11/2017 10 205
6/10/2017 10 195
6/9/2017 10 186
6/8/2017 10 176
6/7/2017 10 166
6/6/2017 10 156
6/5/2017 10 146
6/4/2017 10 136
6/3/2017 10 126
6/2/2017 8 117
6/1/2017 10 108
5/31/2017 9 98
5/30/2017 6 89
5/29/2017 3 83
5/28/2017 6 79
5/27/2017 9 73
5/26/2017 8 65
5/25/2017 8 57
5/24/2017 8 49
5/23/2017 7 41
5/22/2017 4 34
5/21/2017 1 30
5/20/2017 5 29
5/19/2017 4 24
5/18/2017 1 20
5/17/2017 2 19
5/16/2017 7 17
5/15/2017 9 9