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.3847 2025-06-01 00:00:00.0 7.3847 210
2 14.3321 2025-06-02 00:00:00.0 6.9474 210
3 22.7078 2025-06-03 00:00:00.0 8.3757 210
4 29.8691 2025-06-04 00:00:00.0 7.1613 210
5 36.4462 2025-06-05 00:00:00.0 6.5771 210
6 40.6002 2025-06-06 00:00:00.0 4.1540 210
7 46.8900 2025-06-07 00:00:00.0 6.2898 210
8 55.4259 2025-06-08 00:00:00.0 8.5359 210
9 61.5929 2025-06-09 00:00:00.0 6.1670 210
10 65.7062 2025-06-10 00:00:00.0 4.1133 210
11 71.4481 2025-06-11 00:00:00.0 5.7419 210
12 77.3670 2025-06-12 00:00:00.0 5.9189 210
13 83.7042 2025-06-13 00:00:00.0 6.3372 210
14 91.7427 2025-06-14 00:00:00.0 8.0385 210
15 100.1566 2025-06-15 00:00:00.0 8.4139 210
16 107.6668 2025-06-16 00:00:00.0 7.5102 210
17 116.6999 2025-06-17 00:00:00.0 9.0331 210
18 125.0218 2025-06-18 00:00:00.0 8.3219 210
19 133.1696 2025-06-19 00:00:00.0 8.1478 210
20 142.1045 2025-06-20 00:00:00.0 8.9349 210
21 149.5865 2025-06-21 00:00:00.0 7.4820 210
22 159.1431 2025-06-22 00:00:00.0 9.5566 210
23 167.2788 2025-06-23 00:00:00.0 8.1357 210
24 173.0106 2025-06-24 00:00:00.0 5.7318 210
25 178.8467 2025-06-25 00:00:00.0 5.8361 210
26 186.6108 2025-06-26 00:00:00.0 7.7641 210
27 195.2656 2025-06-27 00:00:00.0 8.6548 210
28 203.3340 2025-06-28 00:00:00.0 8.0684 210
29 210.4205 2025-06-29 00:00:00.0 7.0865 210
30 219.1301 2025-06-30 00:00:00.0 8.7096 210
31 227.6578 2025-07-01 00:00:00.0 8.5277 210
32 236.1791 2025-07-02 00:00:00.0 8.5213 210
33 244.3160 2025-07-03 00:00:00.0 8.1369 210
34 251.1082 2025-07-04 00:00:00.0 6.7922 210
35 257.3691 2025-07-05 00:00:00.0 6.2609 210
36 266.8499 2025-07-06 00:00:00.0 9.4808 210
37 274.6520 2025-07-07 00:00:00.0 7.8021 210
38 280.8702 2025-07-08 00:00:00.0 6.2182 210
39 288.4030 2025-07-09 00:00:00.0 7.5328 210
40 295.9500 2025-07-10 00:00:00.0 7.5470 210
41 301.8811 2025-07-11 00:00:00.0 5.9311 210
42 311.3991 2025-07-12 00:00:00.0 9.5180 210
43 319.8310 2025-07-13 00:00:00.0 8.4319 210
44 328.5293 2025-07-14 00:00:00.0 8.6983 210
45 336.9858 2025-07-15 00:00:00.0 8.4565 210
46 345.5265 2025-07-16 00:00:00.0 8.5407 210
47 351.5737 2025-07-17 00:00:00.0 6.0472 210
48 357.7264 2025-07-18 00:00:00.0 6.1527 210
49 364.8919 2025-07-19 00:00:00.0 7.1655 210
50 372.8177 2025-07-20 00:00:00.0 7.9258 210
51 380.3730 2025-07-21 00:00:00.0 7.5553 210
52 389.1505 2025-07-22 00:00:00.0 8.7775 210
53 398.6291 2025-07-23 00:00:00.0 9.4786 210
54 407.6160 2025-07-24 00:00:00.0 8.9869 210
55 416.5074 2025-07-25 00:00:00.0 8.8914 210
56 423.6697 2025-07-26 00:00:00.0 7.1623 210
57 430.6165 2025-07-27 00:00:00.0 6.9468 210
58 439.9832 2025-07-28 00:00:00.0 9.3667 210
59 448.5349 2025-07-29 00:00:00.0 8.5517 210
60 457.2161 2025-07-30 00:00:00.0 8.6812 210
61 464.0815 2025-07-31 00:00:00.0 6.8654 210
62 472.2855 2025-08-01 00:00:00.0 8.2040 210
63 479.6146 2025-08-02 00:00:00.0 7.3291 210
64 488.0169 2025-08-03 00:00:00.0 8.4023 210
65 495.9976 2025-08-04 00:00:00.0 7.9807 210
66 504.6551 2025-08-05 00:00:00.0 8.6575 210
67 512.8904 2025-08-06 00:00:00.0 8.2353 210
68 521.9057 2025-08-07 00:00:00.0 9.0153 210
69 530.4545 2025-08-08 00:00:00.0 8.5488 210
70 540.0021 2025-08-09 00:00:00.0 9.5476 210
71 549.1562 2025-08-10 00:00:00.0 9.1541 210
72 558.4222 2025-08-11 00:00:00.0 9.2660 210
73 567.7067 2025-08-12 00:00:00.0 9.2845 210
74 576.9098 2025-08-13 00:00:00.0 9.2031 210
75 584.3633 2025-08-14 00:00:00.0 7.4535 210
76 592.2746 2025-08-15 00:00:00.0 7.9113 210
77 600.6856 2025-08-16 00:00:00.0 8.4110 210
78 608.4821 2025-08-17 00:00:00.0 7.7965 210
79 616.6901 2025-08-18 00:00:00.0 8.2080 210
80 626.0908 2025-08-19 00:00:00.0 9.4007 210
81 635.0032 2025-08-20 00:00:00.0 8.9124 210
82 643.2590 2025-08-21 00:00:00.0 8.2558 210
83 652.2026 2025-08-22 00:00:00.0 8.9436 210
84 660.1170 2025-08-23 00:00:00.0 7.9144 210
85 668.0331 2025-08-24 00:00:00.0 7.9161 210
86 673.5013 2025-08-25 00:00:00.0 5.4682 210
87 678.5606 2025-08-26 00:00:00.0 5.0593 210
88 686.2082 2025-08-27 00:00:00.0 7.6476 210
89 695.0211 2025-08-28 00:00:00.0 8.8129 210
90 703.3219 2025-08-29 00:00:00.0 8.3008 210
91 710.8508 2025-08-30 00:00:00.0 7.5289 210
92 717.8404 2025-08-31 00:00:00.0 6.9896 210
93 725.3906 2025-09-01 00:00:00.0 7.5502 210
94 733.7004 2025-09-02 00:00:00.0 8.3098 210
95 738.8310 2025-09-03 00:00:00.0 5.1306 210
96 741.0802 2025-09-04 00:00:00.0 2.2492 210
97 741.5159 2025-09-05 00:00:00.0 0.4357 210
98 745.9969 2025-09-06 00:00:00.0 4.4810 210
99 748.8349 2025-09-07 00:00:00.0 2.8380 210
100 752.3887 2025-09-08 00:00:00.0 3.5538 210
101 759.4791 2025-09-09 00:00:00.0 7.0904 210
102 765.7807 2025-09-10 00:00:00.0 6.3016 210
103 771.9793 2025-09-11 00:00:00.0 6.1986 210
104 780.7711 2025-09-12 00:00:00.0 8.7918 210
105 789.9804 2025-09-13 00:00:00.0 9.2093 210
106 798.7244 2025-09-14 00:00:00.0 8.7440 210
107 807.6023 2025-09-15 00:00:00.0 8.8779 210
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '210') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-15'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/15/2025 9 808
9/14/2025 9 799
9/13/2025 9 790
9/12/2025 9 781
9/11/2025 6 772
9/10/2025 6 766
9/9/2025 7 759
9/8/2025 4 752
9/7/2025 3 749
9/6/2025 4 746
9/5/2025 0 742
9/4/2025 2 741
9/3/2025 5 739
9/2/2025 8 734
9/1/2025 8 725
8/31/2025 7 718
8/30/2025 8 711
8/29/2025 8 703
8/28/2025 9 695
8/27/2025 8 686
8/26/2025 5 679
8/25/2025 5 674
8/24/2025 8 668
8/23/2025 8 660
8/22/2025 9 652
8/21/2025 8 643
8/20/2025 9 635
8/19/2025 9 626
8/18/2025 8 617
8/17/2025 8 608
8/16/2025 8 601
8/15/2025 8 592
8/14/2025 7 584
8/13/2025 9 577
8/12/2025 9 568
8/11/2025 9 558
8/10/2025 9 549
8/9/2025 10 540
8/8/2025 9 530
8/7/2025 9 522
8/6/2025 8 513
8/5/2025 9 505
8/4/2025 8 496
8/3/2025 8 488
8/2/2025 7 480
8/1/2025 8 472
7/31/2025 7 464
7/30/2025 9 457
7/29/2025 9 449
7/28/2025 9 440
7/27/2025 7 431
7/26/2025 7 424
7/25/2025 9 417
7/24/2025 9 408
7/23/2025 9 399
7/22/2025 9 389
7/21/2025 8 380
7/20/2025 8 373
7/19/2025 7 365
7/18/2025 6 358
7/17/2025 6 352
7/16/2025 9 346
7/15/2025 8 337
7/14/2025 9 329
7/13/2025 8 320
7/12/2025 10 311
7/11/2025 6 302
7/10/2025 8 296
7/9/2025 8 288
7/8/2025 6 281
7/7/2025 8 275
7/6/2025 9 267
7/5/2025 6 257
7/4/2025 7 251
7/3/2025 8 244
7/2/2025 9 236
7/1/2025 9 228
6/30/2025 9 219
6/29/2025 7 210
6/28/2025 8 203
6/27/2025 9 195
6/26/2025 8 187
6/25/2025 6 179
6/24/2025 6 173
6/23/2025 8 167
6/22/2025 10 159
6/21/2025 7 150
6/20/2025 9 142
6/19/2025 8 133
6/18/2025 8 125
6/17/2025 9 117
6/16/2025 8 108
6/15/2025 8 100
6/14/2025 8 92
6/13/2025 6 84
6/12/2025 6 77
6/11/2025 6 71
6/10/2025 4 66
6/9/2025 6 62
6/8/2025 9 55
6/7/2025 6 47
6/6/2025 4 41
6/5/2025 7 36
6/4/2025 7 30
6/3/2025 8 23
6/2/2025 7 14
6/1/2025 7 7