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 8.0563 2025-06-01 00:00:00.0 8.0563 550
2 15.3782 2025-06-02 00:00:00.0 7.3219 550
3 21.9507 2025-06-03 00:00:00.0 6.5725 550
4 27.4388 2025-06-04 00:00:00.0 5.4881 550
5 32.4538 2025-06-05 00:00:00.0 5.0150 550
6 37.4875 2025-06-06 00:00:00.0 5.0337 550
7 44.2946 2025-06-07 00:00:00.0 6.8071 550
8 51.1047 2025-06-08 00:00:00.0 6.8101 550
9 54.0606 2025-06-09 00:00:00.0 2.9559 550
10 60.4318 2025-06-10 00:00:00.0 6.3712 550
11 68.1294 2025-06-11 00:00:00.0 7.6976 550
12 73.9388 2025-06-12 00:00:00.0 5.8094 550
13 80.2286 2025-06-13 00:00:00.0 6.2898 550
14 88.5126 2025-06-14 00:00:00.0 8.2840 550
15 95.9661 2025-06-15 00:00:00.0 7.4535 550
16 104.6341 2025-06-16 00:00:00.0 8.6680 550
17 113.5690 2025-06-17 00:00:00.0 8.9349 550
18 121.1633 2025-06-18 00:00:00.0 7.5943 550
19 129.4855 2025-06-19 00:00:00.0 8.3222 550
20 137.7367 2025-06-20 00:00:00.0 8.2512 550
21 146.6176 2025-06-21 00:00:00.0 8.8809 550
22 155.7437 2025-06-22 00:00:00.0 9.1261 550
23 163.4895 2025-06-23 00:00:00.0 7.7458 550
24 167.2836 2025-06-24 00:00:00.0 3.7941 550
25 173.5504 2025-06-25 00:00:00.0 6.2668 550
26 180.6065 2025-06-26 00:00:00.0 7.0561 550
27 188.9593 2025-06-27 00:00:00.0 8.3528 550
28 196.9273 2025-06-28 00:00:00.0 7.9680 550
29 205.1240 2025-06-29 00:00:00.0 8.1967 550
30 213.1426 2025-06-30 00:00:00.0 8.0186 550
31 222.0779 2025-07-01 00:00:00.0 8.9353 550
32 229.7887 2025-07-02 00:00:00.0 7.7108 550
33 238.3451 2025-07-03 00:00:00.0 8.5564 550
34 245.6327 2025-07-04 00:00:00.0 7.2876 550
35 253.4046 2025-07-05 00:00:00.0 7.7719 550
36 261.1539 2025-07-06 00:00:00.0 7.7493 550
37 268.0629 2025-07-07 00:00:00.0 6.9090 550
38 274.9473 2025-07-08 00:00:00.0 6.8844 550
39 281.5610 2025-07-09 00:00:00.0 6.6137 550
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '550') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-07-09'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/9/2025 7 282
7/8/2025 7 275
7/7/2025 7 268
7/6/2025 8 261
7/5/2025 8 253
7/4/2025 7 246
7/3/2025 9 238
7/2/2025 8 230
7/1/2025 9 222
6/30/2025 8 213
6/29/2025 8 205
6/28/2025 8 197
6/27/2025 8 189
6/26/2025 7 181
6/25/2025 6 174
6/24/2025 4 167
6/23/2025 8 163
6/22/2025 9 156
6/21/2025 9 147
6/20/2025 8 138
6/19/2025 8 129
6/18/2025 8 121
6/17/2025 9 114
6/16/2025 9 105
6/15/2025 7 96
6/14/2025 8 89
6/13/2025 6 80
6/12/2025 6 74
6/11/2025 8 68
6/10/2025 6 60
6/9/2025 3 54
6/8/2025 7 51
6/7/2025 7 44
6/6/2025 5 37
6/5/2025 5 32
6/4/2025 5 27
6/3/2025 7 22
6/2/2025 7 15
6/1/2025 8 8