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.4566 2017-05-15 00:00:00.0 8.4566 201
2 15.2724 2017-05-16 00:00:00.0 6.8158 201
3 15.2724 2017-05-17 00:00:00.0 0.0000 201
4 15.2724 2017-05-18 00:00:00.0 0.0000 201
5 18.1683 2017-05-19 00:00:00.0 2.8959 201
6 24.3066 2017-05-20 00:00:00.0 6.1383 201
7 26.2066 2017-05-21 00:00:00.0 1.9000 201
8 30.5816 2017-05-22 00:00:00.0 4.3750 201
9 37.7877 2017-05-23 00:00:00.0 7.2061 201
10 45.8892 2017-05-24 00:00:00.0 8.1015 201
11 53.4601 2017-05-25 00:00:00.0 7.5709 201
12 61.2377 2017-05-26 00:00:00.0 7.7776 201
13 69.5214 2017-05-27 00:00:00.0 8.2837 201
14 74.2132 2017-05-28 00:00:00.0 4.6918 201
15 76.3683 2017-05-29 00:00:00.0 2.1551 201
16 82.1433 2017-05-30 00:00:00.0 5.7750 201
17 90.8163 2017-05-31 00:00:00.0 8.6730 201
18 100.8114 2017-06-01 00:00:00.0 9.9951 201
19 109.1213 2017-06-02 00:00:00.0 8.3099 201
20 119.0769 2017-06-03 00:00:00.0 9.9556 201
21 128.6769 2017-06-04 00:00:00.0 9.6000 201
22 138.6720 2017-06-05 00:00:00.0 9.9951 201
23 148.6720 2017-06-06 00:00:00.0 10.0000 201
24 157.7720 2017-06-07 00:00:00.0 9.1000 201
25 167.6414 2017-06-08 00:00:00.0 9.8694 201
26 177.4373 2017-06-09 00:00:00.0 9.7959 201
27 187.1674 2017-06-10 00:00:00.0 9.7301 201
28 196.9205 2017-06-11 00:00:00.0 9.7531 201
29 205.8409 2017-06-12 00:00:00.0 8.9204 201
30 214.5654 2017-06-13 00:00:00.0 8.7245 201
31 223.3899 2017-06-14 00:00:00.0 8.8245 201
32 231.4914 2017-06-15 00:00:00.0 8.1015 201
33 239.9480 2017-06-16 00:00:00.0 8.4566 201
34 247.1541 2017-06-17 00:00:00.0 7.2061 201
35 253.9699 2017-06-18 00:00:00.0 6.8158 201
36 261.5408 2017-06-19 00:00:00.0 7.5709 201
37 269.4510 2017-06-20 00:00:00.0 7.9102 201
38 278.3240 2017-06-21 00:00:00.0 8.8730 201
39 286.7806 2017-06-22 00:00:00.0 8.4566 201
40 293.0944 2017-06-23 00:00:00.0 6.3138 201
41 296.5796 2017-06-24 00:00:00.0 3.4852 201
42 302.0714 2017-06-25 00:00:00.0 5.4918 201
43 310.2954 2017-06-26 00:00:00.0 8.2240 201
44 320.1954 2017-06-27 00:00:00.0 9.9000 201
45 330.1770 2017-06-28 00:00:00.0 9.9816 201
46 339.4010 2017-06-29 00:00:00.0 9.2240 201
47 347.8010 2017-06-30 00:00:00.0 8.4000 201
48 356.3678 2017-07-01 00:00:00.0 8.5668 201
49 364.5918 2017-07-02 00:00:00.0 8.2240 201
50 374.5898 2017-07-03 00:00:00.0 9.9980 201
51 383.9923 2017-07-04 00:00:00.0 9.4025 201
52 393.8688 2017-07-05 00:00:00.0 9.8765 201
53 403.8676 2017-07-06 00:00:00.0 9.9988 201
54 413.5977 2017-07-07 00:00:00.0 9.7301 201
55 423.5866 2017-07-08 00:00:00.0 9.9889 201
56 433.5738 2017-07-09 00:00:00.0 9.9872 201
57 443.5689 2017-07-10 00:00:00.0 9.9951 201
58 453.4036 2017-07-11 00:00:00.0 9.8347 201
59 461.7459 2017-07-12 00:00:00.0 8.3423 201
60 470.4704 2017-07-13 00:00:00.0 8.7245 201
61 480.4520 2017-07-14 00:00:00.0 9.9816 201
62 490.3214 2017-07-15 00:00:00.0 9.8694 201
63 500.2479 2017-07-16 00:00:00.0 9.9265 201
64 510.0059 2017-07-17 00:00:00.0 9.7580 201
65 519.3074 2017-07-18 00:00:00.0 9.3015 201
66 528.6462 2017-07-19 00:00:00.0 9.3388 201
67 538.2743 2017-07-20 00:00:00.0 9.6281 201
68 548.1743 2017-07-21 00:00:00.0 9.9000 201
69 557.5493 2017-07-22 00:00:00.0 9.3750 201
70 567.2794 2017-07-23 00:00:00.0 9.7301 201
71 577.0708 2017-07-24 00:00:00.0 9.7914 201
72 586.9846 2017-07-25 00:00:00.0 9.9138 201
73 596.9596 2017-07-26 00:00:00.0 9.9750 201
74 606.9584 2017-07-27 00:00:00.0 9.9988 201
75 616.8349 2017-07-28 00:00:00.0 9.8765 201
76 626.7905 2017-07-29 00:00:00.0 9.9556 201
77 636.3448 2017-07-30 00:00:00.0 9.5543 201
78 645.2337 2017-07-31 00:00:00.0 8.8889 201
79 655.0684 2017-08-01 00:00:00.0 9.8347 201
80 662.5684 2017-08-02 00:00:00.0 7.5000 201
81 671.3434 2017-08-03 00:00:00.0 8.7750 201
82 680.7184 2017-08-04 00:00:00.0 9.3750 201
83 689.6388 2017-08-05 00:00:00.0 8.9204 201
84 698.3633 2017-08-06 00:00:00.0 8.7245 201
85 708.1164 2017-08-07 00:00:00.0 9.7531 201
86 717.6873 2017-08-08 00:00:00.0 9.5709 201
87 726.2541 2017-08-09 00:00:00.0 8.5668 201
88 735.3107 2017-08-10 00:00:00.0 9.0566 201
89 744.7209 2017-08-11 00:00:00.0 9.4102 201
90 754.1985 2017-08-12 00:00:00.0 9.4776 201
91 763.7082 2017-08-13 00:00:00.0 9.5097 201
92 773.4143 2017-08-14 00:00:00.0 9.7061 201
93 782.9240 2017-08-15 00:00:00.0 9.5097 201
94 792.6301 2017-08-16 00:00:00.0 9.7061 201
95 802.1709 2017-08-17 00:00:00.0 9.5408 201
96 812.0709 2017-08-18 00:00:00.0 9.9000 201
97 821.9474 2017-08-19 00:00:00.0 9.8765 201
98 831.3576 2017-08-20 00:00:00.0 9.4102 201
99 839.2678 2017-08-21 00:00:00.0 7.9102 201
100 847.2428 2017-08-22 00:00:00.0 7.9750 201
101 853.9775 2017-08-23 00:00:00.0 6.7347 201
102 861.4056 2017-08-24 00:00:00.0 7.4281 201
103 870.9765 2017-08-25 00:00:00.0 9.5709 201
104 880.3153 2017-08-26 00:00:00.0 9.3388 201
105 889.9704 2017-08-27 00:00:00.0 9.6551 201
106 899.9395 2017-08-28 00:00:00.0 9.9691 201
107 909.9086 2017-08-29 00:00:00.0 9.9691 201
108 918.2509 2017-08-30 00:00:00.0 8.3423 201
109 928.1035 2017-08-31 00:00:00.0 9.8526 201
110 938.1035 2017-09-01 00:00:00.0 10.0000 201
111 947.7316 2017-09-02 00:00:00.0 9.6281 201
112 957.3867 2017-09-03 00:00:00.0 9.6551 201
113 965.5500 2017-09-04 00:00:00.0 8.1633 201
114 971.2316 2017-09-05 00:00:00.0 5.6816 201
115 978.7316 2017-09-06 00:00:00.0 7.5000 201
116 987.6520 2017-09-07 00:00:00.0 8.9204 201
117 995.6908 2017-09-08 00:00:00.0 8.0388 201
118 1005.5434 2017-09-09 00:00:00.0 9.8526 201
119 1015.2274 2017-09-10 00:00:00.0 9.6840 201
120 1025.0968 2017-09-11 00:00:00.0 9.8694 201
121 1034.6511 2017-09-12 00:00:00.0 9.5543 201
122 1043.2179 2017-09-13 00:00:00.0 8.5668 201
123 1049.4444 2017-09-14 00:00:00.0 6.2265 201
124 1052.4602 2017-09-15 00:00:00.0 3.0158 201
125 1053.2990 2017-09-16 00:00:00.0 0.8388 201
126 1055.1990 2017-09-17 00:00:00.0 1.9000 201
127 1061.2480 2017-09-18 00:00:00.0 6.0490 201
128 1068.6761 2017-09-19 00:00:00.0 7.4281 201
CACHED false
EXECUTIONTIME 3
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '201') 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 6 1061
9/17/2017 2 1055
9/16/2017 1 1053
9/15/2017 3 1052
9/14/2017 6 1049
9/13/2017 9 1043
9/12/2017 10 1035
9/11/2017 10 1025
9/10/2017 10 1015
9/9/2017 10 1006
9/8/2017 8 996
9/7/2017 9 988
9/6/2017 8 979
9/5/2017 6 971
9/4/2017 8 966
9/3/2017 10 957
9/2/2017 10 948
9/1/2017 10 938
8/31/2017 10 928
8/30/2017 8 918
8/29/2017 10 910
8/28/2017 10 900
8/27/2017 10 890
8/26/2017 9 880
8/25/2017 10 871
8/24/2017 7 861
8/23/2017 7 854
8/22/2017 8 847
8/21/2017 8 839
8/20/2017 9 831
8/19/2017 10 822
8/18/2017 10 812
8/17/2017 10 802
8/16/2017 10 793
8/15/2017 10 783
8/14/2017 10 773
8/13/2017 10 764
8/12/2017 9 754
8/11/2017 9 745
8/10/2017 9 735
8/9/2017 9 726
8/8/2017 10 718
8/7/2017 10 708
8/6/2017 9 698
8/5/2017 9 690
8/4/2017 9 681
8/3/2017 9 671
8/2/2017 8 663
8/1/2017 10 655
7/31/2017 9 645
7/30/2017 10 636
7/29/2017 10 627
7/28/2017 10 617
7/27/2017 10 607
7/26/2017 10 597
7/25/2017 10 587
7/24/2017 10 577
7/23/2017 10 567
7/22/2017 9 558
7/21/2017 10 548
7/20/2017 10 538
7/19/2017 9 529
7/18/2017 9 519
7/17/2017 10 510
7/16/2017 10 500
7/15/2017 10 490
7/14/2017 10 480
7/13/2017 9 470
7/12/2017 8 462
7/11/2017 10 453
7/10/2017 10 444
7/9/2017 10 434
7/8/2017 10 424
7/7/2017 10 414
7/6/2017 10 404
7/5/2017 10 394
7/4/2017 9 384
7/3/2017 10 375
7/2/2017 8 365
7/1/2017 9 356
6/30/2017 8 348
6/29/2017 9 339
6/28/2017 10 330
6/27/2017 10 320
6/26/2017 8 310
6/25/2017 5 302
6/24/2017 3 297
6/23/2017 6 293
6/22/2017 8 287
6/21/2017 9 278
6/20/2017 8 269
6/19/2017 8 262
6/18/2017 7 254
6/17/2017 7 247
6/16/2017 8 240
6/15/2017 8 231
6/14/2017 9 223
6/13/2017 9 215
6/12/2017 9 206
6/11/2017 10 197
6/10/2017 10 187
6/9/2017 10 177
6/8/2017 10 168
6/7/2017 9 158
6/6/2017 10 149
6/5/2017 10 139
6/4/2017 10 129
6/3/2017 10 119
6/2/2017 8 109
6/1/2017 10 101
5/31/2017 9 91
5/30/2017 6 82
5/29/2017 2 76
5/28/2017 5 74
5/27/2017 8 70
5/26/2017 8 61
5/25/2017 8 53
5/24/2017 8 46
5/23/2017 7 38
5/22/2017 4 31
5/21/2017 2 26
5/20/2017 6 24
5/19/2017 3 18
5/18/2017 0 15
5/17/2017 0 15
5/16/2017 7 15
5/15/2017 8 8