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.8444 2017-05-15 00:00:00.0 7.8444 239
2 15.0505 2017-05-16 00:00:00.0 7.2061 239
3 15.1928 2017-05-17 00:00:00.0 0.1423 239
4 15.1928 2017-05-18 00:00:00.0 0.0000 239
5 17.8459 2017-05-19 00:00:00.0 2.6531 239
6 23.5275 2017-05-20 00:00:00.0 5.6816 239
7 26.6622 2017-05-21 00:00:00.0 3.1347 239
8 31.8617 2017-05-22 00:00:00.0 5.1995 239
9 39.3617 2017-05-23 00:00:00.0 7.5000 239
10 47.1393 2017-05-24 00:00:00.0 7.7776 239
11 54.1924 2017-05-25 00:00:00.0 7.0531 239
12 60.5924 2017-05-26 00:00:00.0 6.4000 239
13 67.9475 2017-05-27 00:00:00.0 7.3551 239
14 73.9965 2017-05-28 00:00:00.0 6.0490 239
15 77.8230 2017-05-29 00:00:00.0 3.8265 239
16 84.0495 2017-05-30 00:00:00.0 6.2265 239
17 92.8740 2017-05-31 00:00:00.0 8.8245 239
18 102.8413 2017-06-01 00:00:00.0 9.9673 239
19 111.9413 2017-06-02 00:00:00.0 9.1000 239
20 121.9331 2017-06-03 00:00:00.0 9.9918 239
21 131.7081 2017-06-04 00:00:00.0 9.7750 239
22 141.7035 2017-06-05 00:00:00.0 9.9954 239
23 151.5561 2017-06-06 00:00:00.0 9.8526 239
24 160.8194 2017-06-07 00:00:00.0 9.2633 239
25 170.6720 2017-06-08 00:00:00.0 9.8526 239
26 180.0108 2017-06-09 00:00:00.0 9.3388 239
27 189.5817 2017-06-10 00:00:00.0 9.5709 239
28 198.9919 2017-06-11 00:00:00.0 9.4102 239
29 207.8649 2017-06-12 00:00:00.0 8.8730 239
30 216.5379 2017-06-13 00:00:00.0 8.6730 239
31 224.9945 2017-06-14 00:00:00.0 8.4566 239
32 233.0960 2017-06-15 00:00:00.0 8.1015 239
33 241.6082 2017-06-16 00:00:00.0 8.5122 239
34 248.9633 2017-06-17 00:00:00.0 7.3551 239
35 256.2444 2017-06-18 00:00:00.0 7.2811 239
36 264.1546 2017-06-19 00:00:00.0 7.9102 239
37 272.2561 2017-06-20 00:00:00.0 8.1015 239
38 281.3984 2017-06-21 00:00:00.0 9.1423 239
39 289.2428 2017-06-22 00:00:00.0 7.8444 239
40 295.6428 2017-06-23 00:00:00.0 6.4000 239
41 299.4693 2017-06-24 00:00:00.0 3.8265 239
42 305.1509 2017-06-25 00:00:00.0 5.6816 239
43 312.9285 2017-06-26 00:00:00.0 7.7776 239
44 322.7811 2017-06-27 00:00:00.0 9.8526 239
45 332.7398 2017-06-28 00:00:00.0 9.9587 239
46 342.0413 2017-06-29 00:00:00.0 9.3015 239
47 350.4413 2017-06-30 00:00:00.0 8.4000 239
48 359.4535 2017-07-01 00:00:00.0 9.0122 239
49 367.7958 2017-07-02 00:00:00.0 8.3423 239
50 377.7830 2017-07-03 00:00:00.0 9.9872 239
51 386.8830 2017-07-04 00:00:00.0 9.1000 239
52 396.8632 2017-07-05 00:00:00.0 9.9802 239
53 406.8550 2017-07-06 00:00:00.0 9.9918 239
54 416.5611 2017-07-07 00:00:00.0 9.7061 239
55 426.5599 2017-07-08 00:00:00.0 9.9988 239
56 436.5401 2017-07-09 00:00:00.0 9.9802 239
57 446.4796 2017-07-10 00:00:00.0 9.9395 239
58 456.4469 2017-07-11 00:00:00.0 9.9673 239
59 465.1199 2017-07-12 00:00:00.0 8.6730 239
60 473.9929 2017-07-13 00:00:00.0 8.8730 239
61 483.9801 2017-07-14 00:00:00.0 9.9872 239
62 493.8495 2017-07-15 00:00:00.0 9.8694 239
63 503.7495 2017-07-16 00:00:00.0 9.9000 239
64 513.6890 2017-07-17 00:00:00.0 9.9395 239
65 522.7890 2017-07-18 00:00:00.0 9.1000 239
66 532.0130 2017-07-19 00:00:00.0 9.2240 239
67 541.6130 2017-07-20 00:00:00.0 9.6000 239
68 551.4824 2017-07-21 00:00:00.0 9.8694 239
69 560.8574 2017-07-22 00:00:00.0 9.3750 239
70 570.6105 2017-07-23 00:00:00.0 9.7531 239
71 580.4327 2017-07-24 00:00:00.0 9.8222 239
72 590.2485 2017-07-25 00:00:00.0 9.8158 239
73 600.1975 2017-07-26 00:00:00.0 9.9490 239
74 610.1893 2017-07-27 00:00:00.0 9.9918 239
75 620.1103 2017-07-28 00:00:00.0 9.9210 239
76 630.0659 2017-07-29 00:00:00.0 9.9556 239
77 639.4684 2017-07-30 00:00:00.0 9.4025 239
78 648.1240 2017-07-31 00:00:00.0 8.6556 239
79 657.8990 2017-08-01 00:00:00.0 9.7750 239
80 665.4699 2017-08-02 00:00:00.0 7.5709 239
81 674.4821 2017-08-03 00:00:00.0 9.0122 239
82 683.6244 2017-08-04 00:00:00.0 9.1423 239
83 692.6366 2017-08-05 00:00:00.0 9.0122 239
84 701.4611 2017-08-06 00:00:00.0 8.8245 239
85 711.1162 2017-08-07 00:00:00.0 9.6551 239
86 720.8693 2017-08-08 00:00:00.0 9.7531 239
87 729.2693 2017-08-09 00:00:00.0 8.4000 239
88 738.3693 2017-08-10 00:00:00.0 9.1000 239
89 747.7795 2017-08-11 00:00:00.0 9.4102 239
90 757.0428 2017-08-12 00:00:00.0 9.2633 239
91 766.4872 2017-08-13 00:00:00.0 9.4444 239
92 776.0581 2017-08-14 00:00:00.0 9.5709 239
93 785.3214 2017-08-15 00:00:00.0 9.2633 239
94 795.0515 2017-08-16 00:00:00.0 9.7301 239
95 804.4265 2017-08-17 00:00:00.0 9.3750 239
96 814.2423 2017-08-18 00:00:00.0 9.8158 239
97 824.2403 2017-08-19 00:00:00.0 9.9980 239
98 833.2969 2017-08-20 00:00:00.0 9.0566 239
99 841.8637 2017-08-21 00:00:00.0 8.5668 239
100 850.1474 2017-08-22 00:00:00.0 8.2837 239
101 857.1224 2017-08-23 00:00:00.0 6.9750 239
102 864.6933 2017-08-24 00:00:00.0 7.5709 239
103 874.4234 2017-08-25 00:00:00.0 9.7301 239
104 883.9331 2017-08-26 00:00:00.0 9.5097 239
105 893.4107 2017-08-27 00:00:00.0 9.4776 239
106 903.3923 2017-08-28 00:00:00.0 9.9816 239
107 913.3903 2017-08-29 00:00:00.0 9.9980 239
108 921.9025 2017-08-30 00:00:00.0 8.5122 239
109 931.7551 2017-08-31 00:00:00.0 9.8526 239
110 941.7551 2017-09-01 00:00:00.0 10.0000 239
111 951.3832 2017-09-02 00:00:00.0 9.6281 239
112 961.0383 2017-09-03 00:00:00.0 9.6551 239
113 969.0771 2017-09-04 00:00:00.0 8.0388 239
114 975.3036 2017-09-05 00:00:00.0 6.2265 239
115 982.8745 2017-09-06 00:00:00.0 7.5709 239
116 991.5475 2017-09-07 00:00:00.0 8.6730 239
117 998.9026 2017-09-08 00:00:00.0 7.3551 239
118 1008.6557 2017-09-09 00:00:00.0 9.7531 239
119 1018.5063 2017-09-10 00:00:00.0 9.8506 239
120 1028.0772 2017-09-11 00:00:00.0 9.5709 239
121 1038.0661 2017-09-12 00:00:00.0 9.9889 239
122 1046.5227 2017-09-13 00:00:00.0 8.4566 239
123 1052.3900 2017-09-14 00:00:00.0 5.8673 239
124 1055.4058 2017-09-15 00:00:00.0 3.0158 239
125 1056.1073 2017-09-16 00:00:00.0 0.7015 239
126 1058.0073 2017-09-17 00:00:00.0 1.9000 239
127 1063.5945 2017-09-18 00:00:00.0 5.5872 239
128 1071.2353 2017-09-19 00:00:00.0 7.6408 239
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '239') 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 1071
9/18/2017 6 1064
9/17/2017 2 1058
9/16/2017 1 1056
9/15/2017 3 1055
9/14/2017 6 1052
9/13/2017 8 1047
9/12/2017 10 1038
9/11/2017 10 1028
9/10/2017 10 1019
9/9/2017 10 1009
9/8/2017 7 999
9/7/2017 9 992
9/6/2017 8 983
9/5/2017 6 975
9/4/2017 8 969
9/3/2017 10 961
9/2/2017 10 951
9/1/2017 10 942
8/31/2017 10 932
8/30/2017 9 922
8/29/2017 10 913
8/28/2017 10 903
8/27/2017 9 893
8/26/2017 10 884
8/25/2017 10 874
8/24/2017 8 865
8/23/2017 7 857
8/22/2017 8 850
8/21/2017 9 842
8/20/2017 9 833
8/19/2017 10 824
8/18/2017 10 814
8/17/2017 9 804
8/16/2017 10 795
8/15/2017 9 785
8/14/2017 10 776
8/13/2017 9 766
8/12/2017 9 757
8/11/2017 9 748
8/10/2017 9 738
8/9/2017 8 729
8/8/2017 10 721
8/7/2017 10 711
8/6/2017 9 701
8/5/2017 9 693
8/4/2017 9 684
8/3/2017 9 674
8/2/2017 8 665
8/1/2017 10 658
7/31/2017 9 648
7/30/2017 9 639
7/29/2017 10 630
7/28/2017 10 620
7/27/2017 10 610
7/26/2017 10 600
7/25/2017 10 590
7/24/2017 10 580
7/23/2017 10 571
7/22/2017 9 561
7/21/2017 10 551
7/20/2017 10 542
7/19/2017 9 532
7/18/2017 9 523
7/17/2017 10 514
7/16/2017 10 504
7/15/2017 10 494
7/14/2017 10 484
7/13/2017 9 474
7/12/2017 9 465
7/11/2017 10 456
7/10/2017 10 446
7/9/2017 10 437
7/8/2017 10 427
7/7/2017 10 417
7/6/2017 10 407
7/5/2017 10 397
7/4/2017 9 387
7/3/2017 10 378
7/2/2017 8 368
7/1/2017 9 359
6/30/2017 8 350
6/29/2017 9 342
6/28/2017 10 333
6/27/2017 10 323
6/26/2017 8 313
6/25/2017 6 305
6/24/2017 4 299
6/23/2017 6 296
6/22/2017 8 289
6/21/2017 9 281
6/20/2017 8 272
6/19/2017 8 264
6/18/2017 7 256
6/17/2017 7 249
6/16/2017 9 242
6/15/2017 8 233
6/14/2017 8 225
6/13/2017 9 217
6/12/2017 9 208
6/11/2017 9 199
6/10/2017 10 190
6/9/2017 9 180
6/8/2017 10 171
6/7/2017 9 161
6/6/2017 10 152
6/5/2017 10 142
6/4/2017 10 132
6/3/2017 10 122
6/2/2017 9 112
6/1/2017 10 103
5/31/2017 9 93
5/30/2017 6 84
5/29/2017 4 78
5/28/2017 6 74
5/27/2017 7 68
5/26/2017 6 61
5/25/2017 7 54
5/24/2017 8 47
5/23/2017 8 39
5/22/2017 5 32
5/21/2017 3 27
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