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.2472 2025-06-01 00:00:00.0 8.2472 554
2 15.5178 2025-06-02 00:00:00.0 7.2706 554
3 24.0339 2025-06-03 00:00:00.0 8.5161 554
4 32.0693 2025-06-04 00:00:00.0 8.0354 554
5 39.2913 2025-06-05 00:00:00.0 7.2220 554
6 45.1261 2025-06-06 00:00:00.0 5.8348 554
7 53.4525 2025-06-07 00:00:00.0 8.3264 554
8 62.0400 2025-06-08 00:00:00.0 8.5875 554
9 66.1567 2025-06-09 00:00:00.0 4.1167 554
10 71.6810 2025-06-10 00:00:00.0 5.5243 554
11 79.4030 2025-06-11 00:00:00.0 7.7220 554
12 86.6878 2025-06-12 00:00:00.0 7.2848 554
13 94.2879 2025-06-13 00:00:00.0 7.6001 554
14 101.4796 2025-06-14 00:00:00.0 7.1917 554
15 109.0064 2025-06-15 00:00:00.0 7.5268 554
16 117.3003 2025-06-16 00:00:00.0 8.2939 554
17 126.7818 2025-06-17 00:00:00.0 9.4815 554
18 135.7167 2025-06-18 00:00:00.0 8.9349 554
19 144.7482 2025-06-19 00:00:00.0 9.0315 554
20 153.4483 2025-06-20 00:00:00.0 8.7001 554
21 161.8849 2025-06-21 00:00:00.0 8.4366 554
22 171.3908 2025-06-22 00:00:00.0 9.5059 554
23 179.4564 2025-06-23 00:00:00.0 8.0656 554
24 185.2617 2025-06-24 00:00:00.0 5.8053 554
25 191.3703 2025-06-25 00:00:00.0 6.1086 554
26 199.0157 2025-06-26 00:00:00.0 7.6454 554
27 207.9385 2025-06-27 00:00:00.0 8.9228 554
28 216.3389 2025-06-28 00:00:00.0 8.4004 554
29 223.6667 2025-06-29 00:00:00.0 7.3278 554
30 233.1286 2025-06-30 00:00:00.0 9.4619 554
31 242.0101 2025-07-01 00:00:00.0 8.8815 554
32 250.4197 2025-07-02 00:00:00.0 8.4096 554
33 259.3573 2025-07-03 00:00:00.0 8.9376 554
34 267.1333 2025-07-04 00:00:00.0 7.7760 554
35 273.7716 2025-07-05 00:00:00.0 6.6383 554
36 282.9229 2025-07-06 00:00:00.0 9.1513 554
37 290.8252 2025-07-07 00:00:00.0 7.9023 554
38 298.4700 2025-07-08 00:00:00.0 7.6448 554
39 306.6462 2025-07-09 00:00:00.0 8.1762 554
40 315.0769 2025-07-10 00:00:00.0 8.4307 554
41 322.9287 2025-07-11 00:00:00.0 7.8518 554
42 331.7454 2025-07-12 00:00:00.0 8.8167 554
43 340.4455 2025-07-13 00:00:00.0 8.7001 554
44 349.7177 2025-07-14 00:00:00.0 9.2722 554
45 358.8580 2025-07-15 00:00:00.0 9.1403 554
46 366.2624 2025-07-16 00:00:00.0 7.4044 554
47 372.9848 2025-07-17 00:00:00.0 6.7224 554
48 379.7350 2025-07-18 00:00:00.0 6.7502 554
49 387.5729 2025-07-19 00:00:00.0 7.8379 554
50 395.8139 2025-07-20 00:00:00.0 8.2410 554
51 404.5284 2025-07-21 00:00:00.0 8.7145 554
52 412.8497 2025-07-22 00:00:00.0 8.3213 554
53 422.3670 2025-07-23 00:00:00.0 9.5173 554
54 431.5967 2025-07-24 00:00:00.0 9.2297 554
55 440.8741 2025-07-25 00:00:00.0 9.2774 554
56 448.4684 2025-07-26 00:00:00.0 7.5943 554
57 456.9045 2025-07-27 00:00:00.0 8.4361 554
58 466.3219 2025-07-28 00:00:00.0 9.4174 554
59 475.6937 2025-07-29 00:00:00.0 9.3718 554
60 484.5352 2025-07-30 00:00:00.0 8.8415 554
61 492.9039 2025-07-31 00:00:00.0 8.3687 554
62 501.2259 2025-08-01 00:00:00.0 8.3220 554
63 509.4302 2025-08-02 00:00:00.0 8.2043 554
64 518.7293 2025-08-03 00:00:00.0 9.2991 554
65 527.4205 2025-08-04 00:00:00.0 8.6912 554
66 536.5929 2025-08-05 00:00:00.0 9.1724 554
67 545.7822 2025-08-06 00:00:00.0 9.1893 554
68 554.4743 2025-08-07 00:00:00.0 8.6921 554
69 563.3235 2025-08-08 00:00:00.0 8.8492 554
70 573.0234 2025-08-09 00:00:00.0 9.6999 554
71 582.2936 2025-08-10 00:00:00.0 9.2702 554
72 591.5652 2025-08-11 00:00:00.0 9.2716 554
73 601.2181 2025-08-12 00:00:00.0 9.6529 554
74 609.3914 2025-08-13 00:00:00.0 8.1733 554
75 616.6345 2025-08-14 00:00:00.0 7.2431 554
76 625.2052 2025-08-15 00:00:00.0 8.5707 554
77 633.6864 2025-08-16 00:00:00.0 8.4812 554
78 640.9403 2025-08-17 00:00:00.0 7.2539 554
79 648.7174 2025-08-18 00:00:00.0 7.7771 554
80 658.3032 2025-08-19 00:00:00.0 9.5858 554
81 667.2029 2025-08-20 00:00:00.0 8.8997 554
82 675.2049 2025-08-21 00:00:00.0 8.0020 554
83 684.1163 2025-08-22 00:00:00.0 8.9114 554
84 692.5477 2025-08-23 00:00:00.0 8.4314 554
85 700.1426 2025-08-24 00:00:00.0 7.5949 554
86 706.7240 2025-08-25 00:00:00.0 6.5814 554
87 712.7938 2025-08-26 00:00:00.0 6.0698 554
88 721.1036 2025-08-27 00:00:00.0 8.3098 554
89 729.9197 2025-08-28 00:00:00.0 8.8161 554
90 738.1389 2025-08-29 00:00:00.0 8.2192 554
91 745.8762 2025-08-30 00:00:00.0 7.7373 554
92 753.3426 2025-08-31 00:00:00.0 7.4664 554
93 761.4389 2025-09-01 00:00:00.0 8.0963 554
94 770.2288 2025-09-02 00:00:00.0 8.7899 554
95 777.0784 2025-09-03 00:00:00.0 6.8496 554
96 780.1918 2025-09-04 00:00:00.0 3.1134 554
97 780.3805 2025-09-05 00:00:00.0 0.1887 554
98 783.8927 2025-09-06 00:00:00.0 3.5122 554
99 787.4483 2025-09-07 00:00:00.0 3.5556 554
100 791.8857 2025-09-08 00:00:00.0 4.4374 554
101 798.1074 2025-09-09 00:00:00.0 6.2217 554
102 806.0022 2025-09-10 00:00:00.0 7.8948 554
103 813.2513 2025-09-11 00:00:00.0 7.2491 554
104 820.5978 2025-09-12 00:00:00.0 7.3465 554
105 830.1303 2025-09-13 00:00:00.0 9.5325 554
106 839.0245 2025-09-14 00:00:00.0 8.8942 554
107 848.6573 2025-09-15 00:00:00.0 9.6328 554
108 858.4321 2025-09-16 00:00:00.0 9.7748 554
109 867.7710 2025-09-17 00:00:00.0 9.3389 554
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '554') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-17'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/17/2025 9 868
9/16/2025 10 858
9/15/2025 10 849
9/14/2025 9 839
9/13/2025 10 830
9/12/2025 7 821
9/11/2025 7 813
9/10/2025 8 806
9/9/2025 6 798
9/8/2025 4 792
9/7/2025 4 787
9/6/2025 4 784
9/5/2025 0 780
9/4/2025 3 780
9/3/2025 7 777
9/2/2025 9 770
9/1/2025 8 761
8/31/2025 7 753
8/30/2025 8 746
8/29/2025 8 738
8/28/2025 9 730
8/27/2025 8 721
8/26/2025 6 713
8/25/2025 7 707
8/24/2025 8 700
8/23/2025 8 693
8/22/2025 9 684
8/21/2025 8 675
8/20/2025 9 667
8/19/2025 10 658
8/18/2025 8 649
8/17/2025 7 641
8/16/2025 8 634
8/15/2025 9 625
8/14/2025 7 617
8/13/2025 8 609
8/12/2025 10 601
8/11/2025 9 592
8/10/2025 9 582
8/9/2025 10 573
8/8/2025 9 563
8/7/2025 9 554
8/6/2025 9 546
8/5/2025 9 537
8/4/2025 9 527
8/3/2025 9 519
8/2/2025 8 509
8/1/2025 8 501
7/31/2025 8 493
7/30/2025 9 485
7/29/2025 9 476
7/28/2025 9 466
7/27/2025 8 457
7/26/2025 8 448
7/25/2025 9 441
7/24/2025 9 432
7/23/2025 10 422
7/22/2025 8 413
7/21/2025 9 405
7/20/2025 8 396
7/19/2025 8 388
7/18/2025 7 380
7/17/2025 7 373
7/16/2025 7 366
7/15/2025 9 359
7/14/2025 9 350
7/13/2025 9 340
7/12/2025 9 332
7/11/2025 8 323
7/10/2025 8 315
7/9/2025 8 307
7/8/2025 8 298
7/7/2025 8 291
7/6/2025 9 283
7/5/2025 7 274
7/4/2025 8 267
7/3/2025 9 259
7/2/2025 8 250
7/1/2025 9 242
6/30/2025 9 233
6/29/2025 7 224
6/28/2025 8 216
6/27/2025 9 208
6/26/2025 8 199
6/25/2025 6 191
6/24/2025 6 185
6/23/2025 8 179
6/22/2025 10 171
6/21/2025 8 162
6/20/2025 9 153
6/19/2025 9 145
6/18/2025 9 136
6/17/2025 9 127
6/16/2025 8 117
6/15/2025 8 109
6/14/2025 7 101
6/13/2025 8 94
6/12/2025 7 87
6/11/2025 8 79
6/10/2025 6 72
6/9/2025 4 66
6/8/2025 9 62
6/7/2025 8 53
6/6/2025 6 45
6/5/2025 7 39
6/4/2025 8 32
6/3/2025 9 24
6/2/2025 7 16
6/1/2025 8 8