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 6.9012 2025-06-01 00:00:00.0 6.9012 530
2 13.3477 2025-06-02 00:00:00.0 6.4465 530
3 22.0221 2025-06-03 00:00:00.0 8.6744 530
4 29.5478 2025-06-04 00:00:00.0 7.5257 530
5 35.7052 2025-06-05 00:00:00.0 6.1574 530
6 40.6484 2025-06-06 00:00:00.0 4.9432 530
7 46.8580 2025-06-07 00:00:00.0 6.2096 530
8 54.8207 2025-06-08 00:00:00.0 7.9627 530
9 59.6867 2025-06-09 00:00:00.0 4.8660 530
10 63.3387 2025-06-10 00:00:00.0 3.6520 530
11 70.0429 2025-06-11 00:00:00.0 6.7042 530
12 76.5018 2025-06-12 00:00:00.0 6.4589 530
13 82.6155 2025-06-13 00:00:00.0 6.1137 530
14 89.5632 2025-06-14 00:00:00.0 6.9477 530
15 96.5060 2025-06-15 00:00:00.0 6.9428 530
16 102.9327 2025-06-16 00:00:00.0 6.4267 530
17 111.6173 2025-06-17 00:00:00.0 8.6846 530
18 119.4652 2025-06-18 00:00:00.0 7.8479 530
19 127.4111 2025-06-19 00:00:00.0 7.9459 530
20 135.5270 2025-06-20 00:00:00.0 8.1159 530
21 143.7603 2025-06-21 00:00:00.0 8.2333 530
22 153.0464 2025-06-22 00:00:00.0 9.2861 530
23 161.6780 2025-06-23 00:00:00.0 8.6316 530
24 166.8404 2025-06-24 00:00:00.0 5.1624 530
25 172.0651 2025-06-25 00:00:00.0 5.2247 530
26 179.8485 2025-06-26 00:00:00.0 7.7834 530
27 188.3024 2025-06-27 00:00:00.0 8.4539 530
28 195.4313 2025-06-28 00:00:00.0 7.1289 530
29 202.4131 2025-06-29 00:00:00.0 6.9818 530
30 211.1422 2025-06-30 00:00:00.0 8.7291 530
31 220.0432 2025-07-01 00:00:00.0 8.9010 530
32 228.3385 2025-07-02 00:00:00.0 8.2953 530
33 236.8033 2025-07-03 00:00:00.0 8.4648 530
34 243.7381 2025-07-04 00:00:00.0 6.9348 530
35 250.6822 2025-07-05 00:00:00.0 6.9441 530
36 258.9386 2025-07-06 00:00:00.0 8.2564 530
37 266.3158 2025-07-07 00:00:00.0 7.3772 530
38 273.3895 2025-07-08 00:00:00.0 7.0737 530
39 280.5391 2025-07-09 00:00:00.0 7.1496 530
40 288.0719 2025-07-10 00:00:00.0 7.5328 530
41 295.1537 2025-07-11 00:00:00.0 7.0818 530
42 304.3297 2025-07-12 00:00:00.0 9.1760 530
43 312.9962 2025-07-13 00:00:00.0 8.6665 530
44 321.4934 2025-07-14 00:00:00.0 8.4972 530
45 329.8429 2025-07-15 00:00:00.0 8.3495 530
46 336.6981 2025-07-16 00:00:00.0 6.8552 530
47 342.5395 2025-07-17 00:00:00.0 5.8414 530
48 348.3797 2025-07-18 00:00:00.0 5.8402 530
49 355.3614 2025-07-19 00:00:00.0 6.9817 530
50 362.5791 2025-07-20 00:00:00.0 7.2177 530
51 370.5043 2025-07-21 00:00:00.0 7.9252 530
52 379.0829 2025-07-22 00:00:00.0 8.5786 530
53 388.3618 2025-07-23 00:00:00.0 9.2789 530
54 397.4084 2025-07-24 00:00:00.0 9.0466 530
55 406.3100 2025-07-25 00:00:00.0 8.9016 530
56 413.5424 2025-07-26 00:00:00.0 7.2324 530
57 421.5293 2025-07-27 00:00:00.0 7.9869 530
58 430.9066 2025-07-28 00:00:00.0 9.3773 530
59 439.0755 2025-07-29 00:00:00.0 8.1689 530
60 447.2609 2025-07-30 00:00:00.0 8.1854 530
61 454.6782 2025-07-31 00:00:00.0 7.4173 530
62 461.0194 2025-08-01 00:00:00.0 6.3412 530
63 466.9694 2025-08-02 00:00:00.0 5.9500 530
64 475.1292 2025-08-03 00:00:00.0 8.1598 530
65 482.8186 2025-08-04 00:00:00.0 7.6894 530
66 491.6896 2025-08-05 00:00:00.0 8.8710 530
67 500.4550 2025-08-06 00:00:00.0 8.7654 530
68 508.7901 2025-08-07 00:00:00.0 8.3351 530
69 516.2663 2025-08-08 00:00:00.0 7.4762 530
70 525.7893 2025-08-09 00:00:00.0 9.5230 530
71 534.8383 2025-08-10 00:00:00.0 9.0490 530
72 543.9785 2025-08-11 00:00:00.0 9.1402 530
73 553.3316 2025-08-12 00:00:00.0 9.3531 530
74 561.9937 2025-08-13 00:00:00.0 8.6621 530
75 568.3193 2025-08-14 00:00:00.0 6.3256 530
76 576.2469 2025-08-15 00:00:00.0 7.9276 530
77 584.2779 2025-08-16 00:00:00.0 8.0310 530
78 592.6615 2025-08-17 00:00:00.0 8.3836 530
79 600.4153 2025-08-18 00:00:00.0 7.7538 530
80 610.0330 2025-08-19 00:00:00.0 9.6177 530
81 619.0022 2025-08-20 00:00:00.0 8.9692 530
82 626.9138 2025-08-21 00:00:00.0 7.9116 530
83 635.8941 2025-08-22 00:00:00.0 8.9803 530
84 643.7209 2025-08-23 00:00:00.0 7.8268 530
85 651.3436 2025-08-24 00:00:00.0 7.6227 530
86 657.1282 2025-08-25 00:00:00.0 5.7846 530
87 662.8331 2025-08-26 00:00:00.0 5.7049 530
88 670.1575 2025-08-27 00:00:00.0 7.3244 530
89 678.9193 2025-08-28 00:00:00.0 8.7618 530
90 686.8590 2025-08-29 00:00:00.0 7.9397 530
91 694.1058 2025-08-30 00:00:00.0 7.2468 530
92 701.2041 2025-08-31 00:00:00.0 7.0983 530
93 708.7208 2025-09-01 00:00:00.0 7.5167 530
94 717.0999 2025-09-02 00:00:00.0 8.3791 530
95 722.4041 2025-09-03 00:00:00.0 5.3042 530
96 725.4774 2025-09-04 00:00:00.0 3.0733 530
97 725.7309 2025-09-05 00:00:00.0 0.2535 530
98 730.0047 2025-09-06 00:00:00.0 4.2738 530
99 733.1452 2025-09-07 00:00:00.0 3.1405 530
100 736.7038 2025-09-08 00:00:00.0 3.5586 530
101 743.4273 2025-09-09 00:00:00.0 6.7235 530
102 750.3571 2025-09-10 00:00:00.0 6.9298 530
103 757.0069 2025-09-11 00:00:00.0 6.6498 530
104 764.6968 2025-09-12 00:00:00.0 7.6899 530
105 773.8850 2025-09-13 00:00:00.0 9.1882 530
106 783.2184 2025-09-14 00:00:00.0 9.3334 530
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '530') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-14'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/14/2025 9 783
9/13/2025 9 774
9/12/2025 8 765
9/11/2025 7 757
9/10/2025 7 750
9/9/2025 7 743
9/8/2025 4 737
9/7/2025 3 733
9/6/2025 4 730
9/5/2025 0 726
9/4/2025 3 725
9/3/2025 5 722
9/2/2025 8 717
9/1/2025 8 709
8/31/2025 7 701
8/30/2025 7 694
8/29/2025 8 687
8/28/2025 9 679
8/27/2025 7 670
8/26/2025 6 663
8/25/2025 6 657
8/24/2025 8 651
8/23/2025 8 644
8/22/2025 9 636
8/21/2025 8 627
8/20/2025 9 619
8/19/2025 10 610
8/18/2025 8 600
8/17/2025 8 593
8/16/2025 8 584
8/15/2025 8 576
8/14/2025 6 568
8/13/2025 9 562
8/12/2025 9 553
8/11/2025 9 544
8/10/2025 9 535
8/9/2025 10 526
8/8/2025 7 516
8/7/2025 8 509
8/6/2025 9 500
8/5/2025 9 492
8/4/2025 8 483
8/3/2025 8 475
8/2/2025 6 467
8/1/2025 6 461
7/31/2025 7 455
7/30/2025 8 447
7/29/2025 8 439
7/28/2025 9 431
7/27/2025 8 422
7/26/2025 7 414
7/25/2025 9 406
7/24/2025 9 397
7/23/2025 9 388
7/22/2025 9 379
7/21/2025 8 371
7/20/2025 7 363
7/19/2025 7 355
7/18/2025 6 348
7/17/2025 6 343
7/16/2025 7 337
7/15/2025 8 330
7/14/2025 8 321
7/13/2025 9 313
7/12/2025 9 304
7/11/2025 7 295
7/10/2025 8 288
7/9/2025 7 281
7/8/2025 7 273
7/7/2025 7 266
7/6/2025 8 259
7/5/2025 7 251
7/4/2025 7 244
7/3/2025 8 237
7/2/2025 8 228
7/1/2025 9 220
6/30/2025 9 211
6/29/2025 7 202
6/28/2025 7 195
6/27/2025 8 188
6/26/2025 8 180
6/25/2025 5 172
6/24/2025 5 167
6/23/2025 9 162
6/22/2025 9 153
6/21/2025 8 144
6/20/2025 8 136
6/19/2025 8 127
6/18/2025 8 119
6/17/2025 9 112
6/16/2025 6 103
6/15/2025 7 97
6/14/2025 7 90
6/13/2025 6 83
6/12/2025 6 77
6/11/2025 7 70
6/10/2025 4 63
6/9/2025 5 60
6/8/2025 8 55
6/7/2025 6 47
6/6/2025 5 41
6/5/2025 6 36
6/4/2025 8 30
6/3/2025 9 22
6/2/2025 6 13
6/1/2025 7 7