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.7595 2025-06-01 00:00:00.0 7.7595 558
2 14.7042 2025-06-02 00:00:00.0 6.9447 558
3 22.5595 2025-06-03 00:00:00.0 7.8553 558
4 28.5485 2025-06-04 00:00:00.0 5.9890 558
5 33.7666 2025-06-05 00:00:00.0 5.2181 558
6 39.6861 2025-06-06 00:00:00.0 5.9195 558
7 46.1980 2025-06-07 00:00:00.0 6.5119 558
8 53.8150 2025-06-08 00:00:00.0 7.6170 558
9 57.7894 2025-06-09 00:00:00.0 3.9744 558
10 64.4741 2025-06-10 00:00:00.0 6.6847 558
11 72.3834 2025-06-11 00:00:00.0 7.9093 558
12 78.3668 2025-06-12 00:00:00.0 5.9834 558
13 85.1202 2025-06-13 00:00:00.0 6.7534 558
14 92.3828 2025-06-14 00:00:00.0 7.2626 558
15 99.9306 2025-06-15 00:00:00.0 7.5478 558
16 108.4276 2025-06-16 00:00:00.0 8.4970 558
17 117.7160 2025-06-17 00:00:00.0 9.2884 558
18 125.9987 2025-06-18 00:00:00.0 8.2827 558
19 134.3932 2025-06-19 00:00:00.0 8.3945 558
20 142.5210 2025-06-20 00:00:00.0 8.1278 558
21 151.1485 2025-06-21 00:00:00.0 8.6275 558
22 160.3590 2025-06-22 00:00:00.0 9.2105 558
23 168.5688 2025-06-23 00:00:00.0 8.2098 558
24 173.1426 2025-06-24 00:00:00.0 4.5738 558
25 179.1009 2025-06-25 00:00:00.0 5.9583 558
26 185.7489 2025-06-26 00:00:00.0 6.6480 558
27 194.4421 2025-06-27 00:00:00.0 8.6932 558
28 202.3217 2025-06-28 00:00:00.0 7.8796 558
29 209.6489 2025-06-29 00:00:00.0 7.3272 558
30 218.5406 2025-06-30 00:00:00.0 8.8917 558
31 227.3535 2025-07-01 00:00:00.0 8.8129 558
32 234.9717 2025-07-02 00:00:00.0 7.6182 558
33 243.1500 2025-07-03 00:00:00.0 8.1783 558
34 250.5076 2025-07-04 00:00:00.0 7.3576 558
35 257.8279 2025-07-05 00:00:00.0 7.3203 558
36 265.6763 2025-07-06 00:00:00.0 7.8484 558
37 272.2066 2025-07-07 00:00:00.0 6.5303 558
38 278.9420 2025-07-08 00:00:00.0 6.7354 558
39 285.8414 2025-07-09 00:00:00.0 6.8994 558
40 293.5498 2025-07-10 00:00:00.0 7.7084 558
41 301.2457 2025-07-11 00:00:00.0 7.6959 558
42 309.7561 2025-07-12 00:00:00.0 8.5104 558
43 317.5072 2025-07-13 00:00:00.0 7.7511 558
44 325.9005 2025-07-14 00:00:00.0 8.3933 558
45 334.4636 2025-07-15 00:00:00.0 8.5631 558
46 341.5015 2025-07-16 00:00:00.0 7.0379 558
47 348.0688 2025-07-17 00:00:00.0 6.5673 558
48 353.9102 2025-07-18 00:00:00.0 5.8414 558
49 361.3448 2025-07-19 00:00:00.0 7.4346 558
50 368.2644 2025-07-20 00:00:00.0 6.9196 558
51 377.1719 2025-07-21 00:00:00.0 8.9075 558
52 385.9927 2025-07-22 00:00:00.0 8.8208 558
53 395.2301 2025-07-23 00:00:00.0 9.2374 558
54 404.1376 2025-07-24 00:00:00.0 8.9075 558
55 412.8434 2025-07-25 00:00:00.0 8.7058 558
56 420.4340 2025-07-26 00:00:00.0 7.5906 558
57 428.2925 2025-07-27 00:00:00.0 7.8585 558
58 437.4746 2025-07-28 00:00:00.0 9.1821 558
59 446.2021 2025-07-29 00:00:00.0 8.7275 558
60 454.4168 2025-07-30 00:00:00.0 8.2147 558
61 461.9168 2025-07-31 00:00:00.0 7.5000 558
62 468.7745 2025-08-01 00:00:00.0 6.8577 558
63 476.6084 2025-08-02 00:00:00.0 7.8339 558
64 485.1054 2025-08-03 00:00:00.0 8.4970 558
65 493.8370 2025-08-04 00:00:00.0 8.7316 558
66 502.9784 2025-08-05 00:00:00.0 9.1414 558
67 512.3496 2025-08-06 00:00:00.0 9.3712 558
68 521.4512 2025-08-07 00:00:00.0 9.1016 558
69 529.4929 2025-08-08 00:00:00.0 8.0417 558
70 539.1201 2025-08-09 00:00:00.0 9.6272 558
71 547.0398 2025-08-10 00:00:00.0 7.9197 558
72 556.2788 2025-08-11 00:00:00.0 9.2390 558
73 565.4832 2025-08-12 00:00:00.0 9.2044 558
74 573.4359 2025-08-13 00:00:00.0 7.9527 558
75 580.9052 2025-08-14 00:00:00.0 7.4693 558
76 584.2538 2025-08-15 00:00:00.0 3.3486 558
77 590.9182 2025-08-16 00:00:00.0 6.6644 558
78 598.4611 2025-08-17 00:00:00.0 7.5429 558
79 606.8970 2025-08-18 00:00:00.0 8.4359 558
80 616.1326 2025-08-19 00:00:00.0 9.2356 558
81 624.8230 2025-08-20 00:00:00.0 8.6904 558
82 632.4533 2025-08-21 00:00:00.0 7.6303 558
83 640.8240 2025-08-22 00:00:00.0 8.3707 558
84 647.0153 2025-08-23 00:00:00.0 6.1913 558
85 654.0231 2025-08-24 00:00:00.0 7.0078 558
86 659.4545 2025-08-25 00:00:00.0 5.4314 558
87 665.4945 2025-08-26 00:00:00.0 6.0400 558
88 672.4904 2025-08-27 00:00:00.0 6.9959 558
89 680.1947 2025-08-28 00:00:00.0 7.7043 558
90 688.2382 2025-08-29 00:00:00.0 8.0435 558
91 695.2234 2025-08-30 00:00:00.0 6.9852 558
92 702.2132 2025-08-31 00:00:00.0 6.9898 558
93 709.6794 2025-09-01 00:00:00.0 7.4662 558
94 717.6326 2025-09-02 00:00:00.0 7.9532 558
95 722.4346 2025-09-03 00:00:00.0 4.8020 558
96 724.4764 2025-09-04 00:00:00.0 2.0418 558
97 725.3784 2025-09-05 00:00:00.0 0.9020 558
98 728.6656 2025-09-06 00:00:00.0 3.2872 558
99 731.0074 2025-09-07 00:00:00.0 2.3418 558
100 735.1260 2025-09-08 00:00:00.0 4.1186 558
101 741.5110 2025-09-09 00:00:00.0 6.3850 558
102 749.1488 2025-09-10 00:00:00.0 7.6378 558
103 756.9333 2025-09-11 00:00:00.0 7.7845 558
104 765.7620 2025-09-12 00:00:00.0 8.8287 558
105 775.0397 2025-09-13 00:00:00.0 9.2777 558
CACHED false
EXECUTIONTIME 32
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '558') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-13'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/13/2025 9 775
9/12/2025 9 766
9/11/2025 8 757
9/10/2025 8 749
9/9/2025 6 742
9/8/2025 4 735
9/7/2025 2 731
9/6/2025 3 729
9/5/2025 1 725
9/4/2025 2 724
9/3/2025 5 722
9/2/2025 8 718
9/1/2025 7 710
8/31/2025 7 702
8/30/2025 7 695
8/29/2025 8 688
8/28/2025 8 680
8/27/2025 7 672
8/26/2025 6 665
8/25/2025 5 659
8/24/2025 7 654
8/23/2025 6 647
8/22/2025 8 641
8/21/2025 8 632
8/20/2025 9 625
8/19/2025 9 616
8/18/2025 8 607
8/17/2025 8 598
8/16/2025 7 591
8/15/2025 3 584
8/14/2025 7 581
8/13/2025 8 573
8/12/2025 9 565
8/11/2025 9 556
8/10/2025 8 547
8/9/2025 10 539
8/8/2025 8 529
8/7/2025 9 521
8/6/2025 9 512
8/5/2025 9 503
8/4/2025 9 494
8/3/2025 8 485
8/2/2025 8 477
8/1/2025 7 469
7/31/2025 8 462
7/30/2025 8 454
7/29/2025 9 446
7/28/2025 9 437
7/27/2025 8 428
7/26/2025 8 420
7/25/2025 9 413
7/24/2025 9 404
7/23/2025 9 395
7/22/2025 9 386
7/21/2025 9 377
7/20/2025 7 368
7/19/2025 7 361
7/18/2025 6 354
7/17/2025 7 348
7/16/2025 7 342
7/15/2025 9 334
7/14/2025 8 326
7/13/2025 8 318
7/12/2025 9 310
7/11/2025 8 301
7/10/2025 8 294
7/9/2025 7 286
7/8/2025 7 279
7/7/2025 7 272
7/6/2025 8 266
7/5/2025 7 258
7/4/2025 7 251
7/3/2025 8 243
7/2/2025 8 235
7/1/2025 9 227
6/30/2025 9 219
6/29/2025 7 210
6/28/2025 8 202
6/27/2025 9 194
6/26/2025 7 186
6/25/2025 6 179
6/24/2025 5 173
6/23/2025 8 169
6/22/2025 9 160
6/21/2025 9 151
6/20/2025 8 143
6/19/2025 8 134
6/18/2025 8 126
6/17/2025 9 118
6/16/2025 8 108
6/15/2025 8 100
6/14/2025 7 92
6/13/2025 7 85
6/12/2025 6 78
6/11/2025 8 72
6/10/2025 7 64
6/9/2025 4 58
6/8/2025 8 54
6/7/2025 7 46
6/6/2025 6 40
6/5/2025 5 34
6/4/2025 6 29
6/3/2025 8 23
6/2/2025 7 15
6/1/2025 8 8