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.3388 2017-05-15 00:00:00.0 9.3388 244
2 16.5449 2017-05-16 00:00:00.0 7.2061 244
3 18.5730 2017-05-17 00:00:00.0 2.0281 244
4 19.9506 2017-05-18 00:00:00.0 1.3776 244
5 24.3256 2017-05-19 00:00:00.0 4.3750 244
6 28.5929 2017-05-20 00:00:00.0 4.2673 244
7 29.7031 2017-05-21 00:00:00.0 1.1102 244
8 33.0725 2017-05-22 00:00:00.0 3.3694 244
9 40.1256 2017-05-23 00:00:00.0 7.0531 244
10 48.1006 2017-05-24 00:00:00.0 7.9750 244
11 56.1394 2017-05-25 00:00:00.0 8.0388 244
12 64.1144 2017-05-26 00:00:00.0 7.9750 244
13 72.3981 2017-05-27 00:00:00.0 8.2837 244
14 78.3568 2017-05-28 00:00:00.0 5.9587 244
15 81.3726 2017-05-29 00:00:00.0 3.0158 244
16 87.5109 2017-05-30 00:00:00.0 6.1383 244
17 96.7742 2017-05-31 00:00:00.0 9.2633 244
18 103.9298 2017-06-01 00:00:00.0 7.1556 244
19 112.5026 2017-06-02 00:00:00.0 8.5728 244
20 122.0088 2017-06-03 00:00:00.0 9.5062 244
21 131.9675 2017-06-04 00:00:00.0 9.9587 244
22 141.9070 2017-06-05 00:00:00.0 9.9395 244
23 151.6984 2017-06-06 00:00:00.0 9.7914 244
24 161.6249 2017-06-07 00:00:00.0 9.9265 244
25 171.6244 2017-06-08 00:00:00.0 9.9995 244
26 181.5509 2017-06-09 00:00:00.0 9.9265 244
27 191.5096 2017-06-10 00:00:00.0 9.9587 244
28 201.5076 2017-06-11 00:00:00.0 9.9980 244
29 210.9520 2017-06-12 00:00:00.0 9.4444 244
30 220.1760 2017-06-13 00:00:00.0 9.2240 244
31 229.8311 2017-06-14 00:00:00.0 9.6551 244
32 239.0148 2017-06-15 00:00:00.0 9.1837 244
33 248.4250 2017-06-16 00:00:00.0 9.4102 244
34 256.7673 2017-06-17 00:00:00.0 8.3423 244
35 264.3382 2017-06-18 00:00:00.0 7.5709 244
36 272.8504 2017-06-19 00:00:00.0 8.5122 244
37 281.7234 2017-06-20 00:00:00.0 8.8730 244
38 291.0984 2017-06-21 00:00:00.0 9.3750 244
39 300.1106 2017-06-22 00:00:00.0 9.0122 244
40 307.8882 2017-06-23 00:00:00.0 7.7776 244
41 312.3698 2017-06-24 00:00:00.0 4.4816 244
42 318.3285 2017-06-25 00:00:00.0 5.9587 244
43 326.8953 2017-06-26 00:00:00.0 8.5668 244
44 336.7111 2017-06-27 00:00:00.0 9.8158 244
45 346.2208 2017-06-28 00:00:00.0 9.5097 244
46 355.6652 2017-06-29 00:00:00.0 9.4444 244
47 364.6320 2017-06-30 00:00:00.0 8.9668 244
48 373.4070 2017-07-01 00:00:00.0 8.7750 244
49 382.3274 2017-07-02 00:00:00.0 8.9204 244
50 392.3146 2017-07-03 00:00:00.0 9.9872 244
51 401.2763 2017-07-04 00:00:00.0 8.9617 244
52 410.7319 2017-07-05 00:00:00.0 9.4556 244
53 420.4159 2017-07-06 00:00:00.0 9.6840 244
54 430.2118 2017-07-07 00:00:00.0 9.7959 244
55 440.1920 2017-07-08 00:00:00.0 9.9802 244
56 450.0685 2017-07-09 00:00:00.0 9.8765 244
57 460.0376 2017-07-10 00:00:00.0 9.9691 244
58 470.0364 2017-07-11 00:00:00.0 9.9988 244
59 478.9094 2017-07-12 00:00:00.0 8.8730 244
60 488.0931 2017-07-13 00:00:00.0 9.1837 244
61 498.0196 2017-07-14 00:00:00.0 9.9265 244
62 508.0191 2017-07-15 00:00:00.0 9.9995 244
63 517.9574 2017-07-16 00:00:00.0 9.9383 244
64 527.7796 2017-07-17 00:00:00.0 9.8222 244
65 537.5755 2017-07-18 00:00:00.0 9.7959 244
66 546.7592 2017-07-19 00:00:00.0 9.1837 244
67 556.6730 2017-07-20 00:00:00.0 9.9138 244
68 566.6619 2017-07-21 00:00:00.0 9.9889 244
69 576.4369 2017-07-22 00:00:00.0 9.7750 244
70 586.3956 2017-07-23 00:00:00.0 9.9587 244
71 596.3166 2017-07-24 00:00:00.0 9.9210 244
72 606.2968 2017-07-25 00:00:00.0 9.9802 244
73 616.2963 2017-07-26 00:00:00.0 9.9995 244
74 626.2654 2017-07-27 00:00:00.0 9.9691 244
75 635.8197 2017-07-28 00:00:00.0 9.5543 244
76 645.3259 2017-07-29 00:00:00.0 9.5062 244
77 653.8136 2017-07-30 00:00:00.0 8.4877 244
78 662.0309 2017-07-31 00:00:00.0 8.2173 244
79 672.0181 2017-08-01 00:00:00.0 9.9872 244
80 680.3604 2017-08-02 00:00:00.0 8.3423 244
81 689.5844 2017-08-03 00:00:00.0 9.2240 244
82 698.9946 2017-08-04 00:00:00.0 9.4102 244
83 708.3334 2017-08-05 00:00:00.0 9.3388 244
84 717.6722 2017-08-06 00:00:00.0 9.3388 244
85 727.4472 2017-08-07 00:00:00.0 9.7750 244
86 737.2819 2017-08-08 00:00:00.0 9.8347 244
87 746.5452 2017-08-09 00:00:00.0 9.2633 244
88 756.2753 2017-08-10 00:00:00.0 9.7301 244
89 765.7850 2017-08-11 00:00:00.0 9.5097 244
90 775.5600 2017-08-12 00:00:00.0 9.7750 244
91 785.4126 2017-08-13 00:00:00.0 9.8526 244
92 795.2652 2017-08-14 00:00:00.0 9.8526 244
93 805.0402 2017-08-15 00:00:00.0 9.7750 244
94 814.7933 2017-08-16 00:00:00.0 9.7531 244
95 824.4484 2017-08-17 00:00:00.0 9.6551 244
96 834.3749 2017-08-18 00:00:00.0 9.9265 244
97 844.3305 2017-08-19 00:00:00.0 9.9556 244
98 854.2157 2017-08-20 00:00:00.0 9.8852 244
99 862.4397 2017-08-21 00:00:00.0 8.2240 244
100 871.2642 2017-08-22 00:00:00.0 8.8245 244
101 877.4025 2017-08-23 00:00:00.0 6.1383 244
102 884.9734 2017-08-24 00:00:00.0 7.5709 244
103 894.4510 2017-08-25 00:00:00.0 9.4776 244
104 903.7898 2017-08-26 00:00:00.0 9.3388 244
105 913.5857 2017-08-27 00:00:00.0 9.7959 244
106 923.5808 2017-08-28 00:00:00.0 9.9951 244
107 933.2648 2017-08-29 00:00:00.0 9.6840 244
108 942.4071 2017-08-30 00:00:00.0 9.1423 244
109 951.9479 2017-08-31 00:00:00.0 9.5408 244
110 961.5188 2017-09-01 00:00:00.0 9.5709 244
111 971.1999 2017-09-02 00:00:00.0 9.6811 244
112 980.8810 2017-09-03 00:00:00.0 9.6811 244
113 989.6055 2017-09-04 00:00:00.0 8.7245 244
114 997.0336 2017-09-05 00:00:00.0 7.4281 244
115 1003.0826 2017-09-06 00:00:00.0 6.0490 244
116 1012.3459 2017-09-07 00:00:00.0 9.2633 244
117 1019.8459 2017-09-08 00:00:00.0 7.5000 244
118 1029.2209 2017-09-09 00:00:00.0 9.3750 244
119 1039.0715 2017-09-10 00:00:00.0 9.8506 244
120 1048.9715 2017-09-11 00:00:00.0 9.9000 244
121 1058.6937 2017-09-12 00:00:00.0 9.7222 244
122 1068.3218 2017-09-13 00:00:00.0 9.6281 244
123 1076.2320 2017-09-14 00:00:00.0 7.9102 244
124 1080.4993 2017-09-15 00:00:00.0 4.2673 244
125 1082.5274 2017-09-16 00:00:00.0 2.0281 244
126 1086.1274 2017-09-17 00:00:00.0 3.6000 244
127 1092.0861 2017-09-18 00:00:00.0 5.9587 244
128 1101.0529 2017-09-19 00:00:00.0 8.9668 244
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '244') 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 1101
9/18/2017 6 1092
9/17/2017 4 1086
9/16/2017 2 1083
9/15/2017 4 1080
9/14/2017 8 1076
9/13/2017 10 1068
9/12/2017 10 1059
9/11/2017 10 1049
9/10/2017 10 1039
9/9/2017 9 1029
9/8/2017 8 1020
9/7/2017 9 1012
9/6/2017 6 1003
9/5/2017 7 997
9/4/2017 9 990
9/3/2017 10 981
9/2/2017 10 971
9/1/2017 10 962
8/31/2017 10 952
8/30/2017 9 942
8/29/2017 10 933
8/28/2017 10 924
8/27/2017 10 914
8/26/2017 9 904
8/25/2017 9 894
8/24/2017 8 885
8/23/2017 6 877
8/22/2017 9 871
8/21/2017 8 862
8/20/2017 10 854
8/19/2017 10 844
8/18/2017 10 834
8/17/2017 10 824
8/16/2017 10 815
8/15/2017 10 805
8/14/2017 10 795
8/13/2017 10 785
8/12/2017 10 776
8/11/2017 10 766
8/10/2017 10 756
8/9/2017 9 747
8/8/2017 10 737
8/7/2017 10 727
8/6/2017 9 718
8/5/2017 9 708
8/4/2017 9 699
8/3/2017 9 690
8/2/2017 8 680
8/1/2017 10 672
7/31/2017 8 662
7/30/2017 8 654
7/29/2017 10 645
7/28/2017 10 636
7/27/2017 10 626
7/26/2017 10 616
7/25/2017 10 606
7/24/2017 10 596
7/23/2017 10 586
7/22/2017 10 576
7/21/2017 10 567
7/20/2017 10 557
7/19/2017 9 547
7/18/2017 10 538
7/17/2017 10 528
7/16/2017 10 518
7/15/2017 10 508
7/14/2017 10 498
7/13/2017 9 488
7/12/2017 9 479
7/11/2017 10 470
7/10/2017 10 460
7/9/2017 10 450
7/8/2017 10 440
7/7/2017 10 430
7/6/2017 10 420
7/5/2017 9 411
7/4/2017 9 401
7/3/2017 10 392
7/2/2017 9 382
7/1/2017 9 373
6/30/2017 9 365
6/29/2017 9 356
6/28/2017 10 346
6/27/2017 10 337
6/26/2017 9 327
6/25/2017 6 318
6/24/2017 4 312
6/23/2017 8 308
6/22/2017 9 300
6/21/2017 9 291
6/20/2017 9 282
6/19/2017 9 273
6/18/2017 8 264
6/17/2017 8 257
6/16/2017 9 248
6/15/2017 9 239
6/14/2017 10 230
6/13/2017 9 220
6/12/2017 9 211
6/11/2017 10 202
6/10/2017 10 192
6/9/2017 10 182
6/8/2017 10 172
6/7/2017 10 162
6/6/2017 10 152
6/5/2017 10 142
6/4/2017 10 132
6/3/2017 10 122
6/2/2017 9 113
6/1/2017 7 104
5/31/2017 9 97
5/30/2017 6 88
5/29/2017 3 81
5/28/2017 6 78
5/27/2017 8 72
5/26/2017 8 64
5/25/2017 8 56
5/24/2017 8 48
5/23/2017 7 40
5/22/2017 3 33
5/21/2017 1 30
5/20/2017 4 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