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.1423 2017-05-15 00:00:00.0 9.1423 223
2 15.1913 2017-05-16 00:00:00.0 6.0490 223
3 17.2194 2017-05-17 00:00:00.0 2.0281 223
4 17.5031 2017-05-18 00:00:00.0 0.2837 223
5 21.7704 2017-05-19 00:00:00.0 4.2673 223
6 26.7699 2017-05-20 00:00:00.0 4.9995 223
7 27.6087 2017-05-21 00:00:00.0 0.8388 223
8 30.0148 2017-05-22 00:00:00.0 2.4061 223
9 37.1449 2017-05-23 00:00:00.0 7.1301 223
10 45.2464 2017-05-24 00:00:00.0 8.1015 223
11 53.1566 2017-05-25 00:00:00.0 7.9102 223
12 61.9811 2017-05-26 00:00:00.0 8.8245 223
13 70.6015 2017-05-27 00:00:00.0 8.6204 223
14 75.4995 2017-05-28 00:00:00.0 4.8980 223
15 77.0092 2017-05-29 00:00:00.0 1.5097 223
16 82.2087 2017-05-30 00:00:00.0 5.1995 223
17 90.4327 2017-05-31 00:00:00.0 8.2240 223
18 98.9204 2017-06-01 00:00:00.0 8.4877 223
19 107.6562 2017-06-02 00:00:00.0 8.7358 223
20 117.2994 2017-06-03 00:00:00.0 9.6432 223
21 127.1520 2017-06-04 00:00:00.0 9.8526 223
22 137.1508 2017-06-05 00:00:00.0 9.9988 223
23 146.7508 2017-06-06 00:00:00.0 9.6000 223
24 156.6360 2017-06-07 00:00:00.0 9.8852 223
25 166.6176 2017-06-08 00:00:00.0 9.9816 223
26 176.5176 2017-06-09 00:00:00.0 9.9000 223
27 186.4176 2017-06-10 00:00:00.0 9.9000 223
28 196.3763 2017-06-11 00:00:00.0 9.9587 223
29 205.6396 2017-06-12 00:00:00.0 9.2633 223
30 214.6962 2017-06-13 00:00:00.0 9.0566 223
31 224.3773 2017-06-14 00:00:00.0 9.6811 223
32 232.9441 2017-06-15 00:00:00.0 8.5668 223
33 241.3441 2017-06-16 00:00:00.0 8.4000 223
34 248.5502 2017-06-17 00:00:00.0 7.2061 223
35 255.8313 2017-06-18 00:00:00.0 7.2811 223
36 263.6757 2017-06-19 00:00:00.0 7.8444 223
37 272.5961 2017-06-20 00:00:00.0 8.9204 223
38 281.1083 2017-06-21 00:00:00.0 8.5122 223
39 289.7813 2017-06-22 00:00:00.0 8.6730 223
40 296.5971 2017-06-23 00:00:00.0 6.8158 223
41 301.1843 2017-06-24 00:00:00.0 4.5872 223
42 306.7715 2017-06-25 00:00:00.0 5.5872 223
43 315.2281 2017-06-26 00:00:00.0 8.4566 223
44 324.9342 2017-06-27 00:00:00.0 9.7061 223
45 334.3444 2017-06-28 00:00:00.0 9.4102 223
46 343.9153 2017-06-29 00:00:00.0 9.5709 223
47 352.7883 2017-06-30 00:00:00.0 8.8730 223
48 361.4613 2017-07-01 00:00:00.0 8.6730 223
49 370.2858 2017-07-02 00:00:00.0 8.8245 223
50 380.1710 2017-07-03 00:00:00.0 9.8852 223
51 389.6266 2017-07-04 00:00:00.0 9.4556 223
52 399.1809 2017-07-05 00:00:00.0 9.5543 223
53 409.1611 2017-07-06 00:00:00.0 9.9802 223
54 418.9769 2017-07-07 00:00:00.0 9.8158 223
55 428.9749 2017-07-08 00:00:00.0 9.9980 223
56 438.9729 2017-07-09 00:00:00.0 9.9980 223
57 448.9683 2017-07-10 00:00:00.0 9.9954 223
58 458.8030 2017-07-11 00:00:00.0 9.8347 223
59 467.5275 2017-07-12 00:00:00.0 8.7245 223
60 476.6698 2017-07-13 00:00:00.0 9.1423 223
61 486.5392 2017-07-14 00:00:00.0 9.8694 223
62 496.4979 2017-07-15 00:00:00.0 9.9587 223
63 506.4117 2017-07-16 00:00:00.0 9.9138 223
64 515.9660 2017-07-17 00:00:00.0 9.5543 223
65 525.6961 2017-07-18 00:00:00.0 9.7301 223
66 535.0349 2017-07-19 00:00:00.0 9.3388 223
67 544.8507 2017-07-20 00:00:00.0 9.8158 223
68 554.7772 2017-07-21 00:00:00.0 9.9265 223
69 564.3772 2017-07-22 00:00:00.0 9.6000 223
70 574.3155 2017-07-23 00:00:00.0 9.9383 223
71 584.1920 2017-07-24 00:00:00.0 9.8765 223
72 594.1871 2017-07-25 00:00:00.0 9.9951 223
73 604.1871 2017-07-26 00:00:00.0 10.0000 223
74 614.0377 2017-07-27 00:00:00.0 9.8506 223
75 623.6377 2017-07-28 00:00:00.0 9.6000 223
76 631.8550 2017-07-29 00:00:00.0 8.2173 223
77 640.2550 2017-07-30 00:00:00.0 8.4000 223
78 648.4723 2017-07-31 00:00:00.0 8.2173 223
79 658.4213 2017-08-01 00:00:00.0 9.9490 223
80 667.0943 2017-08-02 00:00:00.0 8.6730 223
81 676.3958 2017-08-03 00:00:00.0 9.3015 223
82 685.5381 2017-08-04 00:00:00.0 9.1423 223
83 694.7621 2017-08-05 00:00:00.0 9.2240 223
84 704.2718 2017-08-06 00:00:00.0 9.5097 223
85 714.1718 2017-08-07 00:00:00.0 9.9000 223
86 723.9876 2017-08-08 00:00:00.0 9.8158 223
87 733.2891 2017-08-09 00:00:00.0 9.3015 223
88 742.9952 2017-08-10 00:00:00.0 9.7061 223
89 752.5360 2017-08-11 00:00:00.0 9.5408 223
90 762.3110 2017-08-12 00:00:00.0 9.7750 223
91 772.1962 2017-08-13 00:00:00.0 9.8852 223
92 782.1635 2017-08-14 00:00:00.0 9.9673 223
93 792.0900 2017-08-15 00:00:00.0 9.9265 223
94 801.8431 2017-08-16 00:00:00.0 9.7531 223
95 811.6181 2017-08-17 00:00:00.0 9.7750 223
96 821.4875 2017-08-18 00:00:00.0 9.8694 223
97 831.4566 2017-08-19 00:00:00.0 9.9691 223
98 841.4484 2017-08-20 00:00:00.0 9.9918 223
99 849.5499 2017-08-21 00:00:00.0 8.1015 223
100 857.5249 2017-08-22 00:00:00.0 7.9750 223
101 862.2167 2017-08-23 00:00:00.0 4.6918 223
102 868.7019 2017-08-24 00:00:00.0 6.4852 223
103 878.2116 2017-08-25 00:00:00.0 9.5097 223
104 887.4356 2017-08-26 00:00:00.0 9.2240 223
105 897.3943 2017-08-27 00:00:00.0 9.9587 223
106 907.2449 2017-08-28 00:00:00.0 9.8506 223
107 916.8881 2017-08-29 00:00:00.0 9.6432 223
108 925.9881 2017-08-30 00:00:00.0 9.1000 223
109 935.6432 2017-08-31 00:00:00.0 9.6551 223
110 945.1208 2017-09-01 00:00:00.0 9.4776 223
111 954.6917 2017-09-02 00:00:00.0 9.5709 223
112 964.1693 2017-09-03 00:00:00.0 9.4776 223
113 971.8790 2017-09-04 00:00:00.0 7.7097 223
114 978.2790 2017-09-05 00:00:00.0 6.4000 223
115 983.5770 2017-09-06 00:00:00.0 5.2980 223
116 992.4015 2017-09-07 00:00:00.0 8.8245 223
117 999.8296 2017-09-08 00:00:00.0 7.4281 223
118 1009.2046 2017-09-09 00:00:00.0 9.3750 223
119 1019.0268 2017-09-10 00:00:00.0 9.8222 223
120 1028.9941 2017-09-11 00:00:00.0 9.9673 223
121 1038.2225 2017-09-12 00:00:00.0 9.2284 223
122 1047.6669 2017-09-13 00:00:00.0 9.4444 223
123 1054.8730 2017-09-14 00:00:00.0 7.2061 223
124 1059.0317 2017-09-15 00:00:00.0 4.1587 223
125 1061.0598 2017-09-16 00:00:00.0 2.0281 223
126 1064.6598 2017-09-17 00:00:00.0 3.6000 223
127 1071.7129 2017-09-18 00:00:00.0 7.0531 223
128 1080.4879 2017-09-19 00:00:00.0 8.7750 223
CACHED false
EXECUTIONTIME 3
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '223') 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 1080
9/18/2017 7 1072
9/17/2017 4 1065
9/16/2017 2 1061
9/15/2017 4 1059
9/14/2017 7 1055
9/13/2017 9 1048
9/12/2017 9 1038
9/11/2017 10 1029
9/10/2017 10 1019
9/9/2017 9 1009
9/8/2017 7 1000
9/7/2017 9 992
9/6/2017 5 984
9/5/2017 6 978
9/4/2017 8 972
9/3/2017 9 964
9/2/2017 10 955
9/1/2017 9 945
8/31/2017 10 936
8/30/2017 9 926
8/29/2017 10 917
8/28/2017 10 907
8/27/2017 10 897
8/26/2017 9 887
8/25/2017 10 878
8/24/2017 6 869
8/23/2017 5 862
8/22/2017 8 858
8/21/2017 8 850
8/20/2017 10 841
8/19/2017 10 831
8/18/2017 10 821
8/17/2017 10 812
8/16/2017 10 802
8/15/2017 10 792
8/14/2017 10 782
8/13/2017 10 772
8/12/2017 10 762
8/11/2017 10 753
8/10/2017 10 743
8/9/2017 9 733
8/8/2017 10 724
8/7/2017 10 714
8/6/2017 10 704
8/5/2017 9 695
8/4/2017 9 686
8/3/2017 9 676
8/2/2017 9 667
8/1/2017 10 658
7/31/2017 8 648
7/30/2017 8 640
7/29/2017 8 632
7/28/2017 10 624
7/27/2017 10 614
7/26/2017 10 604
7/25/2017 10 594
7/24/2017 10 584
7/23/2017 10 574
7/22/2017 10 564
7/21/2017 10 555
7/20/2017 10 545
7/19/2017 9 535
7/18/2017 10 526
7/17/2017 10 516
7/16/2017 10 506
7/15/2017 10 496
7/14/2017 10 487
7/13/2017 9 477
7/12/2017 9 468
7/11/2017 10 459
7/10/2017 10 449
7/9/2017 10 439
7/8/2017 10 429
7/7/2017 10 419
7/6/2017 10 409
7/5/2017 10 399
7/4/2017 9 390
7/3/2017 10 380
7/2/2017 9 370
7/1/2017 9 361
6/30/2017 9 353
6/29/2017 10 344
6/28/2017 9 334
6/27/2017 10 325
6/26/2017 8 315
6/25/2017 6 307
6/24/2017 5 301
6/23/2017 7 297
6/22/2017 9 290
6/21/2017 9 281
6/20/2017 9 273
6/19/2017 8 264
6/18/2017 7 256
6/17/2017 7 249
6/16/2017 8 241
6/15/2017 9 233
6/14/2017 10 224
6/13/2017 9 215
6/12/2017 9 206
6/11/2017 10 196
6/10/2017 10 186
6/9/2017 10 177
6/8/2017 10 167
6/7/2017 10 157
6/6/2017 10 147
6/5/2017 10 137
6/4/2017 10 127
6/3/2017 10 117
6/2/2017 9 108
6/1/2017 8 99
5/31/2017 8 90
5/30/2017 5 82
5/29/2017 2 77
5/28/2017 5 75
5/27/2017 9 71
5/26/2017 9 62
5/25/2017 8 53
5/24/2017 8 45
5/23/2017 7 37
5/22/2017 2 30
5/21/2017 1 28
5/20/2017 5 27
5/19/2017 4 22
5/18/2017 0 18
5/17/2017 2 17
5/16/2017 6 15
5/15/2017 9 9