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 7.3387 2025-06-01 00:00:00.0 7.3387 230
2 14.3088 2025-06-02 00:00:00.0 6.9701 230
3 22.9844 2025-06-03 00:00:00.0 8.6756 230
4 31.3950 2025-06-04 00:00:00.0 8.4106 230
5 38.9278 2025-06-05 00:00:00.0 7.5328 230
6 46.2360 2025-06-06 00:00:00.0 7.3082 230
7 53.7261 2025-06-07 00:00:00.0 7.4901 230
8 62.1400 2025-06-08 00:00:00.0 8.4139 230
9 67.2161 2025-06-09 00:00:00.0 5.0761 230
10 73.0561 2025-06-10 00:00:00.0 5.8400 230
11 80.6921 2025-06-11 00:00:00.0 7.6360 230
12 88.3984 2025-06-12 00:00:00.0 7.7063 230
13 95.6111 2025-06-13 00:00:00.0 7.2127 230
14 102.6958 2025-06-14 00:00:00.0 7.0847 230
15 110.5281 2025-06-15 00:00:00.0 7.8323 230
16 118.2812 2025-06-16 00:00:00.0 7.7531 230
17 127.5874 2025-06-17 00:00:00.0 9.3062 230
18 136.2890 2025-06-18 00:00:00.0 8.7016 230
19 143.8574 2025-06-19 00:00:00.0 7.5684 230
20 151.7618 2025-06-20 00:00:00.0 7.9044 230
21 159.7187 2025-06-21 00:00:00.0 7.9569 230
22 167.6794 2025-06-22 00:00:00.0 7.9607 230
23 176.4703 2025-06-23 00:00:00.0 8.7909 230
24 182.4261 2025-06-24 00:00:00.0 5.9558 230
25 188.4410 2025-06-25 00:00:00.0 6.0149 230
26 196.9342 2025-06-26 00:00:00.0 8.4932 230
27 205.7574 2025-06-27 00:00:00.0 8.8232 230
28 213.9263 2025-06-28 00:00:00.0 8.1689 230
29 221.3658 2025-06-29 00:00:00.0 7.4395 230
30 230.4650 2025-06-30 00:00:00.0 9.0992 230
31 239.3885 2025-07-01 00:00:00.0 8.9235 230
32 246.5900 2025-07-02 00:00:00.0 7.2015 230
33 254.0792 2025-07-03 00:00:00.0 7.4892 230
34 261.4812 2025-07-04 00:00:00.0 7.4020 230
35 267.2023 2025-07-05 00:00:00.0 5.7211 230
36 276.4108 2025-07-06 00:00:00.0 9.2085 230
37 284.5870 2025-07-07 00:00:00.0 8.1762 230
38 293.0934 2025-07-08 00:00:00.0 8.5064 230
39 300.4500 2025-07-09 00:00:00.0 7.3566 230
40 308.7209 2025-07-10 00:00:00.0 8.2709 230
41 315.4010 2025-07-11 00:00:00.0 6.6801 230
42 324.6490 2025-07-12 00:00:00.0 9.2480 230
43 333.3105 2025-07-13 00:00:00.0 8.6615 230
44 342.1641 2025-07-14 00:00:00.0 8.8536 230
45 351.5428 2025-07-15 00:00:00.0 9.3787 230
46 351.5428 2025-07-16 00:00:00.0 0.0000 230
47 358.8696 2025-07-17 00:00:00.0 7.3268 230
48 365.1504 2025-07-18 00:00:00.0 6.2808 230
49 373.5743 2025-07-19 00:00:00.0 8.4239 230
50 380.8454 2025-07-20 00:00:00.0 7.2711 230
51 389.4308 2025-07-21 00:00:00.0 8.5854 230
52 397.8399 2025-07-22 00:00:00.0 8.4091 230
53 407.4200 2025-07-23 00:00:00.0 9.5801 230
54 416.2449 2025-07-24 00:00:00.0 8.8249 230
55 424.9333 2025-07-25 00:00:00.0 8.6884 230
56 432.5908 2025-07-26 00:00:00.0 7.6575 230
57 438.9250 2025-07-27 00:00:00.0 6.3342 230
58 447.9655 2025-07-28 00:00:00.0 9.0405 230
59 457.1128 2025-07-29 00:00:00.0 9.1473 230
60 465.7665 2025-07-30 00:00:00.0 8.6537 230
61 473.6854 2025-07-31 00:00:00.0 7.9189 230
62 480.2437 2025-08-01 00:00:00.0 6.5583 230
63 487.3335 2025-08-02 00:00:00.0 7.0898 230
64 496.1848 2025-08-03 00:00:00.0 8.8513 230
65 504.7619 2025-08-04 00:00:00.0 8.5771 230
66 514.2696 2025-08-05 00:00:00.0 9.5077 230
67 523.4031 2025-08-06 00:00:00.0 9.1335 230
68 531.5472 2025-08-07 00:00:00.0 8.1441 230
69 538.3213 2025-08-08 00:00:00.0 6.7741 230
70 547.6417 2025-08-09 00:00:00.0 9.3204 230
71 556.7937 2025-08-10 00:00:00.0 9.1520 230
72 566.1737 2025-08-11 00:00:00.0 9.3800 230
73 575.5236 2025-08-12 00:00:00.0 9.3499 230
74 583.7888 2025-08-13 00:00:00.0 8.2652 230
75 591.1413 2025-08-14 00:00:00.0 7.3525 230
76 599.1324 2025-08-15 00:00:00.0 7.9911 230
77 607.7178 2025-08-16 00:00:00.0 8.5854 230
78 616.3319 2025-08-17 00:00:00.0 8.6141 230
79 624.6096 2025-08-18 00:00:00.0 8.2777 230
80 633.6556 2025-08-19 00:00:00.0 9.0460 230
81 641.5889 2025-08-20 00:00:00.0 7.9333 230
82 649.6808 2025-08-21 00:00:00.0 8.0919 230
83 657.8534 2025-08-22 00:00:00.0 8.1726 230
84 665.4477 2025-08-23 00:00:00.0 7.5943 230
85 673.6396 2025-08-24 00:00:00.0 8.1919 230
86 679.4206 2025-08-25 00:00:00.0 5.7810 230
87 685.6071 2025-08-26 00:00:00.0 6.1865 230
88 693.5563 2025-08-27 00:00:00.0 7.9492 230
89 700.6376 2025-08-28 00:00:00.0 7.0813 230
90 708.1547 2025-08-29 00:00:00.0 7.5171 230
91 714.6946 2025-08-30 00:00:00.0 6.5399 230
92 721.9103 2025-08-31 00:00:00.0 7.2157 230
93 729.5431 2025-09-01 00:00:00.0 7.6328 230
94 738.0006 2025-09-02 00:00:00.0 8.4575 230
95 744.3792 2025-09-03 00:00:00.0 6.3786 230
96 748.1786 2025-09-04 00:00:00.0 3.7994 230
97 748.4949 2025-09-05 00:00:00.0 0.3163 230
98 752.8250 2025-09-06 00:00:00.0 4.3301 230
99 756.9990 2025-09-07 00:00:00.0 4.1740 230
100 761.2413 2025-09-08 00:00:00.0 4.2423 230
101 767.4141 2025-09-09 00:00:00.0 6.1728 230
102 774.1046 2025-09-10 00:00:00.0 6.6905 230
103 781.0398 2025-09-11 00:00:00.0 6.9352 230
104 789.1174 2025-09-12 00:00:00.0 8.0776 230
105 797.3545 2025-09-13 00:00:00.0 8.2371 230
106 806.7699 2025-09-14 00:00:00.0 9.4154 230
107 815.4972 2025-09-15 00:00:00.0 8.7273 230
108 825.2720 2025-09-16 00:00:00.0 9.7748 230
CACHED false
EXECUTIONTIME 78
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '230') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-16'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/16/2025 10 825
9/15/2025 9 815
9/14/2025 9 807
9/13/2025 8 797
9/12/2025 8 789
9/11/2025 7 781
9/10/2025 7 774
9/9/2025 6 767
9/8/2025 4 761
9/7/2025 4 757
9/6/2025 4 753
9/5/2025 0 748
9/4/2025 4 748
9/3/2025 6 744
9/2/2025 8 738
9/1/2025 8 730
8/31/2025 7 722
8/30/2025 7 715
8/29/2025 8 708
8/28/2025 7 701
8/27/2025 8 694
8/26/2025 6 686
8/25/2025 6 679
8/24/2025 8 674
8/23/2025 8 665
8/22/2025 8 658
8/21/2025 8 650
8/20/2025 8 642
8/19/2025 9 634
8/18/2025 8 625
8/17/2025 9 616
8/16/2025 9 608
8/15/2025 8 599
8/14/2025 7 591
8/13/2025 8 584
8/12/2025 9 576
8/11/2025 9 566
8/10/2025 9 557
8/9/2025 9 548
8/8/2025 7 538
8/7/2025 8 532
8/6/2025 9 523
8/5/2025 10 514
8/4/2025 9 505
8/3/2025 9 496
8/2/2025 7 487
8/1/2025 7 480
7/31/2025 8 474
7/30/2025 9 466
7/29/2025 9 457
7/28/2025 9 448
7/27/2025 6 439
7/26/2025 8 433
7/25/2025 9 425
7/24/2025 9 416
7/23/2025 10 407
7/22/2025 8 398
7/21/2025 9 389
7/20/2025 7 381
7/19/2025 8 374
7/18/2025 6 365
7/17/2025 7 359
7/16/2025 0 352
7/15/2025 9 352
7/14/2025 9 342
7/13/2025 9 333
7/12/2025 9 325
7/11/2025 7 315
7/10/2025 8 309
7/9/2025 7 300
7/8/2025 9 293
7/7/2025 8 285
7/6/2025 9 276
7/5/2025 6 267
7/4/2025 7 261
7/3/2025 7 254
7/2/2025 7 247
7/1/2025 9 239
6/30/2025 9 230
6/29/2025 7 221
6/28/2025 8 214
6/27/2025 9 206
6/26/2025 8 197
6/25/2025 6 188
6/24/2025 6 182
6/23/2025 9 176
6/22/2025 8 168
6/21/2025 8 160
6/20/2025 8 152
6/19/2025 8 144
6/18/2025 9 136
6/17/2025 9 128
6/16/2025 8 118
6/15/2025 8 111
6/14/2025 7 103
6/13/2025 7 96
6/12/2025 8 88
6/11/2025 8 81
6/10/2025 6 73
6/9/2025 5 67
6/8/2025 8 62
6/7/2025 7 54
6/6/2025 7 46
6/5/2025 8 39
6/4/2025 8 31
6/3/2025 9 23
6/2/2025 7 14
6/1/2025 7 7