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.9610 2025-06-01 00:00:00.0 6.9610 222
2 13.7532 2025-06-02 00:00:00.0 6.7922 222
3 22.3803 2025-06-03 00:00:00.0 8.6271 222
4 29.8862 2025-06-04 00:00:00.0 7.5059 222
5 37.1540 2025-06-05 00:00:00.0 7.2678 222
6 43.2352 2025-06-06 00:00:00.0 6.0812 222
7 49.8127 2025-06-07 00:00:00.0 6.5775 222
8 58.3240 2025-06-08 00:00:00.0 8.5113 222
9 63.5651 2025-06-09 00:00:00.0 5.2411 222
10 67.3750 2025-06-10 00:00:00.0 3.8099 222
11 74.1142 2025-06-11 00:00:00.0 6.7392 222
12 81.5085 2025-06-12 00:00:00.0 7.3943 222
13 88.2519 2025-06-13 00:00:00.0 6.7434 222
14 95.1018 2025-06-14 00:00:00.0 6.8499 222
15 101.7628 2025-06-15 00:00:00.0 6.6610 222
16 108.3403 2025-06-16 00:00:00.0 6.5775 222
17 117.6333 2025-06-17 00:00:00.0 9.2930 222
18 125.9173 2025-06-18 00:00:00.0 8.2840 222
19 134.1653 2025-06-19 00:00:00.0 8.2480 222
20 142.5395 2025-06-20 00:00:00.0 8.3742 222
21 150.5769 2025-06-21 00:00:00.0 8.0374 222
22 159.2040 2025-06-22 00:00:00.0 8.6271 222
23 167.8682 2025-06-23 00:00:00.0 8.6642 222
24 174.2487 2025-06-24 00:00:00.0 6.3805 222
25 179.9485 2025-06-25 00:00:00.0 5.6998 222
26 188.0446 2025-06-26 00:00:00.0 8.0961 222
27 196.4283 2025-06-27 00:00:00.0 8.3837 222
28 204.0300 2025-06-28 00:00:00.0 7.6017 222
29 211.6064 2025-06-29 00:00:00.0 7.5764 222
30 220.8575 2025-06-30 00:00:00.0 9.2511 222
31 229.9565 2025-07-01 00:00:00.0 9.0990 222
32 238.2804 2025-07-02 00:00:00.0 8.3239 222
33 247.1042 2025-07-03 00:00:00.0 8.8238 222
34 254.1202 2025-07-04 00:00:00.0 7.0160 222
35 261.8437 2025-07-05 00:00:00.0 7.7235 222
36 270.6131 2025-07-06 00:00:00.0 8.7694 222
37 278.3860 2025-07-07 00:00:00.0 7.7729 222
38 286.7817 2025-07-08 00:00:00.0 8.3957 222
39 294.3485 2025-07-09 00:00:00.0 7.5668 222
40 302.1141 2025-07-10 00:00:00.0 7.7656 222
41 309.1303 2025-07-11 00:00:00.0 7.0162 222
42 318.4866 2025-07-12 00:00:00.0 9.3563 222
43 327.0517 2025-07-13 00:00:00.0 8.5651 222
44 335.9841 2025-07-14 00:00:00.0 8.9324 222
45 344.6157 2025-07-15 00:00:00.0 8.6316 222
46 352.5354 2025-07-16 00:00:00.0 7.9197 222
47 358.8989 2025-07-17 00:00:00.0 6.3635 222
48 364.8553 2025-07-18 00:00:00.0 5.9564 222
49 372.5994 2025-07-19 00:00:00.0 7.7441 222
50 380.3288 2025-07-20 00:00:00.0 7.7294 222
51 388.8235 2025-07-21 00:00:00.0 8.4947 222
52 397.8137 2025-07-22 00:00:00.0 8.9902 222
53 407.4463 2025-07-23 00:00:00.0 9.6326 222
54 416.7616 2025-07-24 00:00:00.0 9.3153 222
55 425.5882 2025-07-25 00:00:00.0 8.8266 222
56 433.1644 2025-07-26 00:00:00.0 7.5762 222
57 440.8855 2025-07-27 00:00:00.0 7.7211 222
58 450.4973 2025-07-28 00:00:00.0 9.6118 222
59 459.5130 2025-07-29 00:00:00.0 9.0157 222
60 468.2784 2025-07-30 00:00:00.0 8.7654 222
61 476.2292 2025-07-31 00:00:00.0 7.9508 222
62 482.9527 2025-08-01 00:00:00.0 6.7235 222
63 489.6239 2025-08-02 00:00:00.0 6.6712 222
64 497.9374 2025-08-03 00:00:00.0 8.3135 222
65 505.8688 2025-08-04 00:00:00.0 7.9314 222
66 515.0162 2025-08-05 00:00:00.0 9.1474 222
67 523.7884 2025-08-06 00:00:00.0 8.7722 222
68 532.0371 2025-08-07 00:00:00.0 8.2487 222
69 539.6573 2025-08-08 00:00:00.0 7.6202 222
70 549.1062 2025-08-09 00:00:00.0 9.4489 222
71 558.2719 2025-08-10 00:00:00.0 9.1657 222
72 567.3731 2025-08-11 00:00:00.0 9.1012 222
73 576.4738 2025-08-12 00:00:00.0 9.1007 222
74 584.9823 2025-08-13 00:00:00.0 8.5085 222
75 591.5061 2025-08-14 00:00:00.0 6.5238 222
76 599.6478 2025-08-15 00:00:00.0 8.1417 222
77 607.7239 2025-08-16 00:00:00.0 8.0761 222
78 616.0353 2025-08-17 00:00:00.0 8.3114 222
79 624.1320 2025-08-18 00:00:00.0 8.0967 222
80 633.8009 2025-08-19 00:00:00.0 9.6689 222
81 643.1100 2025-08-20 00:00:00.0 9.3091 222
82 651.3308 2025-08-21 00:00:00.0 8.2208 222
83 660.1363 2025-08-22 00:00:00.0 8.8055 222
84 668.4618 2025-08-23 00:00:00.0 8.3255 222
85 676.3606 2025-08-24 00:00:00.0 7.8988 222
86 683.0994 2025-08-25 00:00:00.0 6.7388 222
87 688.7629 2025-08-26 00:00:00.0 5.6635 222
88 695.7016 2025-08-27 00:00:00.0 6.9387 222
89 704.1453 2025-08-28 00:00:00.0 8.4437 222
90 712.4162 2025-08-29 00:00:00.0 8.2709 222
91 719.7606 2025-08-30 00:00:00.0 7.3444 222
92 726.8277 2025-08-31 00:00:00.0 7.0671 222
93 734.2108 2025-09-01 00:00:00.0 7.3831 222
94 742.3660 2025-09-02 00:00:00.0 8.1552 222
95 748.0745 2025-09-03 00:00:00.0 5.7085 222
96 751.5193 2025-09-04 00:00:00.0 3.4448 222
97 751.7080 2025-09-05 00:00:00.0 0.1887 222
98 755.9574 2025-09-06 00:00:00.0 4.2494 222
99 759.6106 2025-09-07 00:00:00.0 3.6532 222
100 763.3282 2025-09-08 00:00:00.0 3.7176 222
101 769.5829 2025-09-09 00:00:00.0 6.2547 222
102 776.8732 2025-09-10 00:00:00.0 7.2903 222
103 783.5607 2025-09-11 00:00:00.0 6.6875 222
104 791.1632 2025-09-12 00:00:00.0 7.6025 222
105 800.5244 2025-09-13 00:00:00.0 9.3612 222
106 809.6018 2025-09-14 00:00:00.0 9.0774 222
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '222') 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 810
9/13/2025 9 801
9/12/2025 8 791
9/11/2025 7 784
9/10/2025 7 777
9/9/2025 6 770
9/8/2025 4 763
9/7/2025 4 760
9/6/2025 4 756
9/5/2025 0 752
9/4/2025 3 752
9/3/2025 6 748
9/2/2025 8 742
9/1/2025 7 734
8/31/2025 7 727
8/30/2025 7 720
8/29/2025 8 712
8/28/2025 8 704
8/27/2025 7 696
8/26/2025 6 689
8/25/2025 7 683
8/24/2025 8 676
8/23/2025 8 668
8/22/2025 9 660
8/21/2025 8 651
8/20/2025 9 643
8/19/2025 10 634
8/18/2025 8 624
8/17/2025 8 616
8/16/2025 8 608
8/15/2025 8 600
8/14/2025 7 592
8/13/2025 9 585
8/12/2025 9 576
8/11/2025 9 567
8/10/2025 9 558
8/9/2025 9 549
8/8/2025 8 540
8/7/2025 8 532
8/6/2025 9 524
8/5/2025 9 515
8/4/2025 8 506
8/3/2025 8 498
8/2/2025 7 490
8/1/2025 7 483
7/31/2025 8 476
7/30/2025 9 468
7/29/2025 9 460
7/28/2025 10 450
7/27/2025 8 441
7/26/2025 8 433
7/25/2025 9 426
7/24/2025 9 417
7/23/2025 10 407
7/22/2025 9 398
7/21/2025 8 389
7/20/2025 8 380
7/19/2025 8 373
7/18/2025 6 365
7/17/2025 6 359
7/16/2025 8 353
7/15/2025 9 345
7/14/2025 9 336
7/13/2025 9 327
7/12/2025 9 318
7/11/2025 7 309
7/10/2025 8 302
7/9/2025 8 294
7/8/2025 8 287
7/7/2025 8 278
7/6/2025 9 271
7/5/2025 8 262
7/4/2025 7 254
7/3/2025 9 247
7/2/2025 8 238
7/1/2025 9 230
6/30/2025 9 221
6/29/2025 8 212
6/28/2025 8 204
6/27/2025 8 196
6/26/2025 8 188
6/25/2025 6 180
6/24/2025 6 174
6/23/2025 9 168
6/22/2025 9 159
6/21/2025 8 151
6/20/2025 8 143
6/19/2025 8 134
6/18/2025 8 126
6/17/2025 9 118
6/16/2025 7 108
6/15/2025 7 102
6/14/2025 7 95
6/13/2025 7 88
6/12/2025 7 82
6/11/2025 7 74
6/10/2025 4 67
6/9/2025 5 64
6/8/2025 9 58
6/7/2025 7 50
6/6/2025 6 43
6/5/2025 7 37
6/4/2025 8 30
6/3/2025 9 22
6/2/2025 7 14
6/1/2025 7 7