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 8.1339 2026-06-01 00:00:00.0 8.1339 524
2 17.0860 2026-06-02 00:00:00.0 8.9521 524
3 24.7968 2026-06-03 00:00:00.0 7.7108 524
4 34.3031 2026-06-04 00:00:00.0 9.5063 524
5 43.4863 2026-06-05 00:00:00.0 9.1832 524
6 52.2179 2026-06-06 00:00:00.0 8.7316 524
7 59.5131 2026-06-07 00:00:00.0 7.2952 524
8 65.4850 2026-06-08 00:00:00.0 5.9719 524
9 74.7826 2026-06-09 00:00:00.0 9.2976 524
10 81.2600 2026-06-10 00:00:00.0 6.4774 524
11 90.4578 2026-06-11 00:00:00.0 9.1978 524
12 99.5822 2026-06-12 00:00:00.0 9.1244 524
13 107.5214 2026-06-13 00:00:00.0 7.9392 524
14 113.1979 2026-06-14 00:00:00.0 5.6765 524
15 119.4899 2026-06-15 00:00:00.0 6.2920 524
16 126.8697 2026-06-16 00:00:00.0 7.3798 524
17 134.1282 2026-06-17 00:00:00.0 7.2585 524
18 141.5190 2026-06-18 00:00:00.0 7.3908 524
19 146.9789 2026-06-19 00:00:00.0 5.4599 524
20 155.0976 2026-06-20 00:00:00.0 8.1187 524
21 160.7193 2026-06-21 00:00:00.0 5.6217 524
22 166.4530 2026-06-22 00:00:00.0 5.7337 524
23 173.0958 2026-06-23 00:00:00.0 6.6428 524
24 181.5001 2026-06-24 00:00:00.0 8.4043 524
25 190.3474 2026-06-25 00:00:00.0 8.8473 524
26 198.6229 2026-06-26 00:00:00.0 8.2755 524
27 206.9611 2026-06-27 00:00:00.0 8.3382 524
28 215.8534 2026-06-28 00:00:00.0 8.8923 524
29 225.1150 2026-06-29 00:00:00.0 9.2616 524
30 234.4573 2026-06-30 00:00:00.0 9.3423 524
31 243.7233 2026-07-01 00:00:00.0 9.2660 524
32 253.1107 2026-07-02 00:00:00.0 9.3874 524
33 261.8395 2026-07-03 00:00:00.0 8.7288 524
34 269.4322 2026-07-04 00:00:00.0 7.5927 524
35 277.8915 2026-07-05 00:00:00.0 8.4593 524
36 285.5286 2026-07-06 00:00:00.0 7.6371 524
37 294.1701 2026-07-07 00:00:00.0 8.6415 524
38 303.1154 2026-07-08 00:00:00.0 8.9453 524
39 312.2011 2026-07-09 00:00:00.0 9.0857 524
40 320.7252 2026-07-10 00:00:00.0 8.5241 524
41 328.7893 2026-07-11 00:00:00.0 8.0641 524
42 336.0107 2026-07-12 00:00:00.0 7.2214 524
43 340.9961 2026-07-13 00:00:00.0 4.9854 524
44 345.8912 2026-07-14 00:00:00.0 4.8951 524
45 354.9042 2026-07-15 00:00:00.0 9.0130 524
46 364.6295 2026-07-16 00:00:00.0 9.7253 524
47 373.8611 2026-07-17 00:00:00.0 9.2316 524
48 383.0442 2026-07-18 00:00:00.0 9.1831 524
49 390.5133 2026-07-19 00:00:00.0 7.4691 524
50 397.9120 2026-07-20 00:00:00.0 7.3987 524
51 406.9636 2026-07-21 00:00:00.0 9.0516 524
52 415.9294 2026-07-22 00:00:00.0 8.9658 524
53 423.9688 2026-07-23 00:00:00.0 8.0394 524
54 432.5333 2026-07-24 00:00:00.0 8.5645 524
55 440.0452 2026-07-25 00:00:00.0 7.5119 524
56 448.4964 2026-07-26 00:00:00.0 8.4512 524
57 456.2349 2026-07-27 00:00:00.0 7.7385 524
58 464.4905 2026-07-28 00:00:00.0 8.2556 524
59 472.0079 2026-07-29 00:00:00.0 7.5174 524
60 477.6237 2026-07-30 00:00:00.0 5.6158 524
61 485.9029 2026-07-31 00:00:00.0 8.2792 524
62 494.3152 2026-08-01 00:00:00.0 8.4123 524
63 502.8582 2026-08-02 00:00:00.0 8.5430 524
64 510.0825 2026-08-03 00:00:00.0 7.2243 524
65 518.8262 2026-08-04 00:00:00.0 8.7437 524
66 526.8217 2026-08-05 00:00:00.0 7.9955 524
67 533.8589 2026-08-06 00:00:00.0 7.0372 524
68 541.2145 2026-08-07 00:00:00.0 7.3556 524
69 548.9838 2026-08-08 00:00:00.0 7.7693 524
70 556.9840 2026-08-09 00:00:00.0 8.0002 524
71 564.2882 2026-08-10 00:00:00.0 7.3042 524
72 573.0155 2026-08-11 00:00:00.0 8.7273 524
73 580.8841 2026-08-12 00:00:00.0 7.8686 524
74 588.5901 2026-08-13 00:00:00.0 7.7060 524
75 596.3432 2026-08-14 00:00:00.0 7.7531 524
76 605.1622 2026-08-15 00:00:00.0 8.8190 524
77 614.8166 2026-08-16 00:00:00.0 9.6544 524
78 623.5831 2026-08-17 00:00:00.0 8.7665 524
79 632.0778 2026-08-18 00:00:00.0 8.4947 524
80 639.2544 2026-08-19 00:00:00.0 7.1766 524
81 646.1816 2026-08-20 00:00:00.0 6.9272 524
82 654.3114 2026-08-21 00:00:00.0 8.1298 524
83 662.8306 2026-08-22 00:00:00.0 8.5192 524
84 670.7159 2026-08-23 00:00:00.0 7.8853 524
85 677.0472 2026-08-24 00:00:00.0 6.3313 524
86 685.2372 2026-08-25 00:00:00.0 8.1900 524
87 694.6583 2026-08-26 00:00:00.0 9.4211 524
88 703.2081 2026-08-27 00:00:00.0 8.5498 524
89 710.1980 2026-08-28 00:00:00.0 6.9899 524
90 716.8107 2026-08-29 00:00:00.0 6.6127 524
91 724.9170 2026-08-30 00:00:00.0 8.1063 524
92 733.0896 2026-08-31 00:00:00.0 8.1726 524
93 742.1007 2026-09-01 00:00:00.0 9.0111 524
94 751.2418 2026-09-02 00:00:00.0 9.1411 524
95 759.5051 2026-09-03 00:00:00.0 8.2633 524
96 767.9541 2026-09-04 00:00:00.0 8.4490 524
97 776.5601 2026-09-05 00:00:00.0 8.6060 524
98 785.6376 2026-09-06 00:00:00.0 9.0775 524
99 793.9185 2026-09-07 00:00:00.0 8.2809 524
100 803.7226 2026-09-08 00:00:00.0 9.8041 524
101 813.2406 2026-09-09 00:00:00.0 9.5180 524
102 822.0980 2026-09-10 00:00:00.0 8.8574 524
103 829.0220 2026-09-11 00:00:00.0 6.9240 524
104 837.8226 2026-09-12 00:00:00.0 8.8006 524
105 843.5506 2026-09-13 00:00:00.0 5.7280 524
106 847.9975 2026-09-14 00:00:00.0 4.4469 524
107 850.7721 2026-09-15 00:00:00.0 2.7746 524
108 855.3689 2026-09-16 00:00:00.0 4.5968 524
109 858.3738 2026-09-17 00:00:00.0 3.0049 524
110 862.9310 2026-09-18 00:00:00.0 4.5572 524
111 868.6704 2026-09-19 00:00:00.0 5.7394 524
112 876.1859 2026-09-20 00:00:00.0 7.5155 524
113 879.6187 2026-09-21 00:00:00.0 3.4328 524
114 884.1697 2026-09-22 00:00:00.0 4.5510 524
115 888.6399 2026-09-23 00:00:00.0 4.4702 524
116 893.9579 2026-09-24 00:00:00.0 5.3180 524
117 902.5134 2026-09-25 00:00:00.0 8.5555 524
118 910.5835 2026-09-26 00:00:00.0 8.0701 524
119 919.6107 2026-09-27 00:00:00.0 9.0272 524
120 925.4404 2026-09-28 00:00:00.0 5.8297 524
121 929.2634 2026-09-29 00:00:00.0 3.8230 524
122 938.2588 2026-09-30 00:00:00.0 8.9954 524
123 943.9038 2026-10-01 00:00:00.0 5.6450 524
124 947.4238 2026-10-02 00:00:00.0 3.5200 524
125 950.4401 2026-10-03 00:00:00.0 3.0163 524
126 956.0530 2026-10-04 00:00:00.0 5.6129 524
127 959.6806 2026-10-05 00:00:00.0 3.6276 524
128 962.7637 2026-10-06 00:00:00.0 3.0831 524
129 968.3856 2026-10-07 00:00:00.0 5.6219 524
130 973.7452 2026-10-08 00:00:00.0 5.3596 524
131 977.3739 2026-10-09 00:00:00.0 3.6287 524
132 982.2787 2026-10-10 00:00:00.0 4.9048 524
133 990.2028 2026-10-11 00:00:00.0 7.9241 524
134 992.4831 2026-10-12 00:00:00.0 2.2803 524
135 992.4831 2026-10-13 00:00:00.0 0.0000 524
136 993.0944 2026-10-14 00:00:00.0 0.6113 524
137 993.5202 2026-10-15 00:00:00.0 0.4258 524
138 995.1733 2026-10-16 00:00:00.0 1.6531 524
139 995.7067 2026-10-17 00:00:00.0 0.5334 524
140 999.0164 2026-10-18 00:00:00.0 3.3097 524
141 1002.4898 2026-10-19 00:00:00.0 3.4734 524
142 1004.6891 2026-10-20 00:00:00.0 2.1993 524
143 1008.2923 2026-10-21 00:00:00.0 3.6032 524
144 1011.1244 2026-10-22 00:00:00.0 2.8321 524
145 1014.7340 2026-10-23 00:00:00.0 3.6096 524
146 1021.8518 2026-10-24 00:00:00.0 7.1178 524
147 1025.2289 2026-10-25 00:00:00.0 3.3771 524
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '524') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-10-25'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/25/2026 3 1025
10/24/2026 7 1022
10/23/2026 4 1015
10/22/2026 3 1011
10/21/2026 4 1008
10/20/2026 2 1005
10/19/2026 3 1002
10/18/2026 3 999
10/17/2026 1 996
10/16/2026 2 995
10/15/2026 0 994
10/14/2026 1 993
10/13/2026 0 992
10/12/2026 2 992
10/11/2026 8 990
10/10/2026 5 982
10/9/2026 4 977
10/8/2026 5 974
10/7/2026 6 968
10/6/2026 3 963
10/5/2026 4 960
10/4/2026 6 956
10/3/2026 3 950
10/2/2026 4 947
10/1/2026 6 944
9/30/2026 9 938
9/29/2026 4 929
9/28/2026 6 925
9/27/2026 9 920
9/26/2026 8 911
9/25/2026 9 903
9/24/2026 5 894
9/23/2026 4 889
9/22/2026 5 884
9/21/2026 3 880
9/20/2026 8 876
9/19/2026 6 869
9/18/2026 5 863
9/17/2026 3 858
9/16/2026 5 855
9/15/2026 3 851
9/14/2026 4 848
9/13/2026 6 844
9/12/2026 9 838
9/11/2026 7 829
9/10/2026 9 822
9/9/2026 10 813
9/8/2026 10 804
9/7/2026 8 794
9/6/2026 9 786
9/5/2026 9 777
9/4/2026 8 768
9/3/2026 8 760
9/2/2026 9 751
9/1/2026 9 742
8/31/2026 8 733
8/30/2026 8 725
8/29/2026 7 717
8/28/2026 7 710
8/27/2026 9 703
8/26/2026 9 695
8/25/2026 8 685
8/24/2026 6 677
8/23/2026 8 671
8/22/2026 9 663
8/21/2026 8 654
8/20/2026 7 646
8/19/2026 7 639
8/18/2026 8 632
8/17/2026 9 624
8/16/2026 10 615
8/15/2026 9 605
8/14/2026 8 596
8/13/2026 8 589
8/12/2026 8 581
8/11/2026 9 573
8/10/2026 7 564
8/9/2026 8 557
8/8/2026 8 549
8/7/2026 7 541
8/6/2026 7 534
8/5/2026 8 527
8/4/2026 9 519
8/3/2026 7 510
8/2/2026 9 503
8/1/2026 8 494
7/31/2026 8 486
7/30/2026 6 478
7/29/2026 8 472
7/28/2026 8 464
7/27/2026 8 456
7/26/2026 8 448
7/25/2026 8 440
7/24/2026 9 433
7/23/2026 8 424
7/22/2026 9 416
7/21/2026 9 407
7/20/2026 7 398
7/19/2026 7 391
7/18/2026 9 383
7/17/2026 9 374
7/16/2026 10 365
7/15/2026 9 355
7/14/2026 5 346
7/13/2026 5 341
7/12/2026 7 336
7/11/2026 8 329
7/10/2026 9 321
7/9/2026 9 312
7/8/2026 9 303
7/7/2026 9 294
7/6/2026 8 286
7/5/2026 8 278
7/4/2026 8 269
7/3/2026 9 262
7/2/2026 9 253
7/1/2026 9 244
6/30/2026 9 234
6/29/2026 9 225
6/28/2026 9 216
6/27/2026 8 207
6/26/2026 8 199
6/25/2026 9 190
6/24/2026 8 182
6/23/2026 7 173
6/22/2026 6 166
6/21/2026 6 161
6/20/2026 8 155
6/19/2026 5 147
6/18/2026 7 142
6/17/2026 7 134
6/16/2026 7 127
6/15/2026 6 119
6/14/2026 6 113
6/13/2026 8 108
6/12/2026 9 100
6/11/2026 9 90
6/10/2026 6 81
6/9/2026 9 75
6/8/2026 6 65
6/7/2026 7 60
6/6/2026 9 52
6/5/2026 9 43
6/4/2026 10 34
6/3/2026 8 25
6/2/2026 9 17
6/1/2026 8 8