Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Wawanesa Glenboro Glenora Treherne Holland Gladstone Portage East High Bluff Oakland Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler Kane Brunkild Austin Bagot Elie Kenton Neepawa St. Claude


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 45.9949 2024-06-06 00:00:00.0 6.3261 222
2 52.8472 2024-06-07 00:00:00.0 6.8523 222
3 59.5943 2024-06-08 00:00:00.0 6.7471 222
4 65.2245 2024-06-09 00:00:00.0 5.6302 222
5 71.2261 2024-06-10 00:00:00.0 6.0016 222
6 80.0441 2024-06-11 00:00:00.0 8.8180 222
7 88.6930 2024-06-12 00:00:00.0 8.6489 222
8 97.1145 2024-06-13 00:00:00.0 8.4215 222
9 103.8637 2024-06-14 00:00:00.0 6.7492 222
10 112.0641 2024-06-15 00:00:00.0 8.2004 222
11 121.3721 2024-06-16 00:00:00.0 9.3080 222
12 128.4642 2024-06-17 00:00:00.0 7.0921 222
13 134.8482 2024-06-18 00:00:00.0 6.3840 222
14 142.3969 2024-06-19 00:00:00.0 7.5487 222
15 149.8358 2024-06-20 00:00:00.0 7.4389 222
16 158.0206 2024-06-21 00:00:00.0 8.1848 222
17 167.0040 2024-06-22 00:00:00.0 8.9834 222
18 175.6823 2024-06-23 00:00:00.0 8.6783 222
19 183.0221 2024-06-24 00:00:00.0 7.3398 222
20 192.2276 2024-06-25 00:00:00.0 9.2055 222
21 199.9772 2024-06-26 00:00:00.0 7.7496 222
22 206.0845 2024-06-27 00:00:00.0 6.1073 222
23 212.9580 2024-06-28 00:00:00.0 6.8735 222
24 219.7180 2024-06-29 00:00:00.0 6.7600 222
25 225.5274 2024-06-30 00:00:00.0 5.8094 222
26 234.0587 2024-07-01 00:00:00.0 8.5313 222
27 243.5779 2024-07-02 00:00:00.0 9.5192 222
28 252.7384 2024-07-03 00:00:00.0 9.1605 222
29 261.7427 2024-07-04 00:00:00.0 9.0043 222
30 270.8027 2024-07-05 00:00:00.0 9.0600 222
31 279.4726 2024-07-06 00:00:00.0 8.6699 222
32 287.7763 2024-07-07 00:00:00.0 8.3037 222
33 296.3470 2024-07-08 00:00:00.0 8.5707 222
34 304.4376 2024-07-09 00:00:00.0 8.0906 222
35 312.7474 2024-07-10 00:00:00.0 8.3098 222
36 320.2612 2024-07-11 00:00:00.0 7.5138 222
37 327.5734 2024-07-12 00:00:00.0 7.3122 222
38 334.9418 2024-07-13 00:00:00.0 7.3684 222
39 343.3665 2024-07-14 00:00:00.0 8.4247 222
40 352.5415 2024-07-15 00:00:00.0 9.1750 222
41 360.7614 2024-07-16 00:00:00.0 8.2199 222
42 368.1319 2024-07-17 00:00:00.0 7.3705 222
43 375.1978 2024-07-18 00:00:00.0 7.0659 222
44 383.2846 2024-07-19 00:00:00.0 8.0868 222
45 391.4260 2024-07-20 00:00:00.0 8.1414 222
46 399.9374 2024-07-21 00:00:00.0 8.5114 222
47 409.3980 2024-07-22 00:00:00.0 9.4606 222
48 418.9243 2024-07-23 00:00:00.0 9.5263 222
49 427.8013 2024-07-24 00:00:00.0 8.8770 222
50 436.2941 2024-07-25 00:00:00.0 8.4928 222
51 442.8801 2024-07-26 00:00:00.0 6.5860 222
52 450.9248 2024-07-27 00:00:00.0 8.0447 222
53 460.1592 2024-07-28 00:00:00.0 9.2344 222
54 468.4365 2024-07-29 00:00:00.0 8.2773 222
55 475.9669 2024-07-30 00:00:00.0 7.5304 222
56 484.4978 2024-07-31 00:00:00.0 8.5309 222
57 491.3884 2024-08-01 00:00:00.0 6.8906 222
58 499.6101 2024-08-02 00:00:00.0 8.2217 222
59 508.2913 2024-08-03 00:00:00.0 8.6812 222
60 514.6561 2024-08-04 00:00:00.0 6.3648 222
61 522.9069 2024-08-05 00:00:00.0 8.2508 222
62 529.9871 2024-08-06 00:00:00.0 7.0802 222
63 537.5681 2024-08-07 00:00:00.0 7.5810 222
64 543.8188 2024-08-08 00:00:00.0 6.2507 222
65 551.1469 2024-08-09 00:00:00.0 7.3281 222
66 557.5462 2024-08-10 00:00:00.0 6.3993 222
67 564.9489 2024-08-11 00:00:00.0 7.4027 222
68 572.6168 2024-08-12 00:00:00.0 7.6679 222
69 580.0544 2024-08-13 00:00:00.0 7.4376 222
70 588.9304 2024-08-14 00:00:00.0 8.8760 222
71 598.6640 2024-08-15 00:00:00.0 9.7336 222
72 608.1355 2024-08-16 00:00:00.0 9.4715 222
73 617.0078 2024-08-17 00:00:00.0 8.8723 222
74 625.0251 2024-08-18 00:00:00.0 8.0173 222
75 633.0599 2024-08-19 00:00:00.0 8.0348 222
76 641.1774 2024-08-20 00:00:00.0 8.1175 222
77 649.9156 2024-08-21 00:00:00.0 8.7382 222
78 659.1484 2024-08-22 00:00:00.0 9.2328 222
79 667.4258 2024-08-23 00:00:00.0 8.2774 222
80 674.7290 2024-08-24 00:00:00.0 7.3032 222
81 681.8771 2024-08-25 00:00:00.0 7.1481 222
82 690.5254 2024-08-26 00:00:00.0 8.6483 222
83 697.5732 2024-08-27 00:00:00.0 7.0478 222
84 704.7495 2024-08-28 00:00:00.0 7.1763 222
85 713.6437 2024-08-29 00:00:00.0 8.8942 222
86 722.3781 2024-08-30 00:00:00.0 8.7344 222
87 730.3763 2024-08-31 00:00:00.0 7.9982 222
88 736.6565 2024-09-01 00:00:00.0 6.2802 222
89 743.6439 2024-09-02 00:00:00.0 6.9874 222
90 751.2384 2024-09-03 00:00:00.0 7.5945 222
91 760.6385 2024-09-04 00:00:00.0 9.4001 222
92 767.9199 2024-09-05 00:00:00.0 7.2814 222
93 773.9440 2024-09-06 00:00:00.0 6.0241 222
94 779.4039 2024-09-07 00:00:00.0 5.4599 222
95 786.6403 2024-09-08 00:00:00.0 7.2364 222
96 793.7620 2024-09-09 00:00:00.0 7.1217 222
97 802.4655 2024-09-10 00:00:00.0 8.7035 222
98 810.1143 2024-09-11 00:00:00.0 7.6488 222
99 817.5167 2024-09-12 00:00:00.0 7.4024 222
100 827.1567 2024-09-13 00:00:00.0 9.6400 222
101 835.5242 2024-09-14 00:00:00.0 8.3675 222
102 843.2341 2024-09-15 00:00:00.0 7.7099 222
103 851.6658 2024-09-16 00:00:00.0 8.4317 222
104 861.1032 2024-09-17 00:00:00.0 9.4374 222
105 870.2764 2024-09-18 00:00:00.0 9.1732 222
106 880.0845 2024-09-19 00:00:00.0 9.8081 222
107 888.8539 2024-09-20 00:00:00.0 8.7694 222
108 895.8758 2024-09-21 00:00:00.0 7.0219 222
109 900.9788 2024-09-22 00:00:00.0 5.1030 222
110 908.2695 2024-09-23 00:00:00.0 7.2907 222
111 915.9819 2024-09-24 00:00:00.0 7.7124 222
112 923.1945 2024-09-25 00:00:00.0 7.2126 222
113 930.8220 2024-09-26 00:00:00.0 7.6275 222
114 938.0874 2024-09-27 00:00:00.0 7.2654 222
115 945.0599 2024-09-28 00:00:00.0 6.9725 222
116 951.4422 2024-09-29 00:00:00.0 6.3823 222
117 959.0106 2024-09-30 00:00:00.0 7.5684 222
118 962.8345 2024-10-01 00:00:00.0 3.8239 222
119 967.7707 2024-10-02 00:00:00.0 4.9362 222
120 969.2857 2024-10-03 00:00:00.0 1.5150 222
121 972.6448 2024-10-04 00:00:00.0 3.3591 222
122 978.2430 2024-10-05 00:00:00.0 5.5982 222
123 981.3683 2024-10-06 00:00:00.0 3.1253 222
124 984.8354 2024-10-07 00:00:00.0 3.4671 222
125 989.7852 2024-10-08 00:00:00.0 4.9498 222
126 996.1250 2024-10-09 00:00:00.0 6.3398 222
127 1002.4712 2024-10-10 00:00:00.0 6.3462 222
128 1005.9589 2024-10-11 00:00:00.0 3.4877 222
129 1008.1353 2024-10-12 00:00:00.0 2.1764 222
130 1009.1939 2024-10-13 00:00:00.0 1.0586 222
131 1009.3158 2024-10-14 00:00:00.0 0.1219 222
132 1009.7800 2024-10-15 00:00:00.0 0.4642 222
133 1012.8343 2024-10-16 00:00:00.0 3.0543 222
134 1018.0179 2024-10-17 00:00:00.0 5.1836 222
135 1019.8532 2024-10-18 00:00:00.0 1.8353 222
136 1021.6661 2024-10-19 00:00:00.0 1.8129 222
137 1027.2412 2024-10-20 00:00:00.0 5.5751 222
138 1031.9054 2024-10-21 00:00:00.0 4.6642 222
139 1033.9217 2024-10-22 00:00:00.0 2.0163 222
140 1035.9456 2024-10-23 00:00:00.0 2.0239 222
141 1036.5450 2024-10-24 00:00:00.0 0.5994 222
142 1037.1052 2024-10-25 00:00:00.0 0.5602 222
143 1037.5409 2024-10-26 00:00:00.0 0.4357 222
144 1039.2225 2024-10-27 00:00:00.0 1.6816 222
145 1042.0430 2024-10-28 00:00:00.0 2.8205 222
146 1042.8439 2024-10-29 00:00:00.0 0.8009 222
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '222') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-29'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/29/2024 1 1043
10/28/2024 3 1042
10/27/2024 2 1039
10/26/2024 0 1038
10/25/2024 1 1037
10/24/2024 1 1037
10/23/2024 2 1036
10/22/2024 2 1034
10/21/2024 5 1032
10/20/2024 6 1027
10/19/2024 2 1022
10/18/2024 2 1020
10/17/2024 5 1018
10/16/2024 3 1013
10/15/2024 0 1010
10/14/2024 0 1009
10/13/2024 1 1009
10/12/2024 2 1008
10/11/2024 3 1006
10/10/2024 6 1002
10/9/2024 6 996
10/8/2024 5 990
10/7/2024 3 985
10/6/2024 3 981
10/5/2024 6 978
10/4/2024 3 973
10/3/2024 2 969
10/2/2024 5 968
10/1/2024 4 963
9/30/2024 8 959
9/29/2024 6 951
9/28/2024 7 945
9/27/2024 7 938
9/26/2024 8 931
9/25/2024 7 923
9/24/2024 8 916
9/23/2024 7 908
9/22/2024 5 901
9/21/2024 7 896
9/20/2024 9 889
9/19/2024 10 880
9/18/2024 9 870
9/17/2024 9 861
9/16/2024 8 852
9/15/2024 8 843
9/14/2024 8 836
9/13/2024 10 827
9/12/2024 7 818
9/11/2024 8 810
9/10/2024 9 802
9/9/2024 7 794
9/8/2024 7 787
9/7/2024 5 779
9/6/2024 6 774
9/5/2024 7 768
9/4/2024 9 761
9/3/2024 8 751
9/2/2024 7 744
9/1/2024 6 737
8/31/2024 8 730
8/30/2024 9 722
8/29/2024 9 714
8/28/2024 7 705
8/27/2024 7 698
8/26/2024 9 691
8/25/2024 7 682
8/24/2024 7 675
8/23/2024 8 667
8/22/2024 9 659
8/21/2024 9 650
8/20/2024 8 641
8/19/2024 8 633
8/18/2024 8 625
8/17/2024 9 617
8/16/2024 9 608
8/15/2024 10 599
8/14/2024 9 589
8/13/2024 7 580
8/12/2024 8 573
8/11/2024 7 565
8/10/2024 6 558
8/9/2024 7 551
8/8/2024 6 544
8/7/2024 8 538
8/6/2024 7 530
8/5/2024 8 523
8/4/2024 6 515
8/3/2024 9 508
8/2/2024 8 500
8/1/2024 7 491
7/31/2024 9 484
7/30/2024 8 476
7/29/2024 8 468
7/28/2024 9 460
7/27/2024 8 451
7/26/2024 7 443
7/25/2024 8 436
7/24/2024 9 428
7/23/2024 10 419
7/22/2024 9 409
7/21/2024 9 400
7/20/2024 8 391
7/19/2024 8 383
7/18/2024 7 375
7/17/2024 7 368
7/16/2024 8 361
7/15/2024 9 353
7/14/2024 8 343
7/13/2024 7 335
7/12/2024 7 328
7/11/2024 8 320
7/10/2024 8 313
7/9/2024 8 304
7/8/2024 9 296
7/7/2024 8 288
7/6/2024 9 279
7/5/2024 9 271
7/4/2024 9 262
7/3/2024 9 253
7/2/2024 10 244
7/1/2024 9 234
6/30/2024 6 226
6/29/2024 7 220
6/28/2024 7 213
6/27/2024 6 206
6/26/2024 8 200
6/25/2024 9 192
6/24/2024 7 183
6/23/2024 9 176
6/22/2024 9 167
6/21/2024 8 158
6/20/2024 7 150
6/19/2024 8 142
6/18/2024 6 135
6/17/2024 7 128
6/16/2024 9 121
6/15/2024 8 112
6/14/2024 7 104
6/13/2024 8 97
6/12/2024 9 89
6/11/2024 9 80
6/10/2024 6 71
6/9/2024 6 65
6/8/2024 7 60
6/7/2024 7 53