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.5057 2025-06-01 00:00:00.0 7.5057 239
2 14.4863 2025-06-02 00:00:00.0 6.9806 239
3 22.5441 2025-06-03 00:00:00.0 8.0578 239
4 29.2770 2025-06-04 00:00:00.0 6.7329 239
5 35.2156 2025-06-05 00:00:00.0 5.9386 239
6 40.5860 2025-06-06 00:00:00.0 5.3704 239
7 47.3877 2025-06-07 00:00:00.0 6.8017 239
8 55.4696 2025-06-08 00:00:00.0 8.0819 239
9 59.6948 2025-06-09 00:00:00.0 4.2252 239
10 66.1797 2025-06-10 00:00:00.0 6.4849 239
11 73.8554 2025-06-11 00:00:00.0 7.6757 239
12 79.7571 2025-06-12 00:00:00.0 5.9017 239
13 86.7612 2025-06-13 00:00:00.0 7.0041 239
14 93.8932 2025-06-14 00:00:00.0 7.1320 239
15 101.4585 2025-06-15 00:00:00.0 7.5653 239
16 109.3038 2025-06-16 00:00:00.0 7.8453 239
17 118.6674 2025-06-17 00:00:00.0 9.3636 239
18 127.1933 2025-06-18 00:00:00.0 8.5259 239
19 135.3268 2025-06-19 00:00:00.0 8.1335 239
20 143.6209 2025-06-20 00:00:00.0 8.2941 239
21 152.2318 2025-06-21 00:00:00.0 8.6109 239
22 161.8551 2025-06-22 00:00:00.0 9.6233 239
23 169.2925 2025-06-23 00:00:00.0 7.4374 239
24 173.7807 2025-06-24 00:00:00.0 4.4882 239
25 179.6786 2025-06-25 00:00:00.0 5.8979 239
26 187.3119 2025-06-26 00:00:00.0 7.6333 239
27 195.8914 2025-06-27 00:00:00.0 8.5795 239
28 203.9148 2025-06-28 00:00:00.0 8.0234 239
29 211.3061 2025-06-29 00:00:00.0 7.3913 239
30 220.0111 2025-06-30 00:00:00.0 8.7050 239
31 228.5511 2025-07-01 00:00:00.0 8.5400 239
32 236.0929 2025-07-02 00:00:00.0 7.5418 239
33 244.7731 2025-07-03 00:00:00.0 8.6802 239
34 251.9404 2025-07-04 00:00:00.0 7.1673 239
35 258.6389 2025-07-05 00:00:00.0 6.6985 239
36 266.8962 2025-07-06 00:00:00.0 8.2573 239
37 273.3668 2025-07-07 00:00:00.0 6.4706 239
38 279.9375 2025-07-08 00:00:00.0 6.5707 239
39 286.4383 2025-07-09 00:00:00.0 6.5008 239
40 294.4531 2025-07-10 00:00:00.0 8.0148 239
41 302.0437 2025-07-11 00:00:00.0 7.5906 239
42 311.0878 2025-07-12 00:00:00.0 9.0441 239
43 318.8415 2025-07-13 00:00:00.0 7.7537 239
44 327.2682 2025-07-14 00:00:00.0 8.4267 239
45 335.8237 2025-07-15 00:00:00.0 8.5555 239
46 342.9239 2025-07-16 00:00:00.0 7.1002 239
47 348.7536 2025-07-17 00:00:00.0 5.8297 239
48 354.2755 2025-07-18 00:00:00.0 5.5219 239
49 361.6764 2025-07-19 00:00:00.0 7.4009 239
50 368.3214 2025-07-20 00:00:00.0 6.6450 239
51 377.3098 2025-07-21 00:00:00.0 8.9884 239
52 386.2534 2025-07-22 00:00:00.0 8.9436 239
53 395.2748 2025-07-23 00:00:00.0 9.0214 239
54 404.6102 2025-07-24 00:00:00.0 9.3354 239
55 405.6922 2025-07-25 00:00:00.0 1.0820 239
56 413.1987 2025-07-26 00:00:00.0 7.5065 239
57 421.1424 2025-07-27 00:00:00.0 7.9437 239
58 430.2178 2025-07-28 00:00:00.0 9.0754 239
59 438.7087 2025-07-29 00:00:00.0 8.4909 239
60 446.8168 2025-07-30 00:00:00.0 8.1081 239
61 454.6071 2025-07-31 00:00:00.0 7.7903 239
62 461.0698 2025-08-01 00:00:00.0 6.4627 239
63 468.3415 2025-08-02 00:00:00.0 7.2717 239
64 477.0422 2025-08-03 00:00:00.0 8.7007 239
65 485.3133 2025-08-04 00:00:00.0 8.2711 239
66 493.7936 2025-08-05 00:00:00.0 8.4803 239
67 503.1449 2025-08-06 00:00:00.0 9.3513 239
68 512.1550 2025-08-07 00:00:00.0 9.0101 239
69 520.0712 2025-08-08 00:00:00.0 7.9162 239
70 529.7103 2025-08-09 00:00:00.0 9.6391 239
71 538.0998 2025-08-10 00:00:00.0 8.3895 239
72 547.2988 2025-08-11 00:00:00.0 9.1990 239
73 556.5617 2025-08-12 00:00:00.0 9.2629 239
74 564.1925 2025-08-13 00:00:00.0 7.6308 239
75 571.0579 2025-08-14 00:00:00.0 6.8654 239
76 579.8427 2025-08-15 00:00:00.0 8.7848 239
77 586.6126 2025-08-16 00:00:00.0 6.7699 239
78 594.6623 2025-08-17 00:00:00.0 8.0497 239
79 603.1858 2025-08-18 00:00:00.0 8.5235 239
80 612.5022 2025-08-19 00:00:00.0 9.3164 239
81 621.4154 2025-08-20 00:00:00.0 8.9132 239
82 628.9272 2025-08-21 00:00:00.0 7.5118 239
83 637.5657 2025-08-22 00:00:00.0 8.6385 239
84 644.4487 2025-08-23 00:00:00.0 6.8830 239
85 651.7373 2025-08-24 00:00:00.0 7.2886 239
86 657.2967 2025-08-25 00:00:00.0 5.5594 239
87 662.8648 2025-08-26 00:00:00.0 5.5681 239
88 669.8293 2025-08-27 00:00:00.0 6.9645 239
89 677.2390 2025-08-28 00:00:00.0 7.4097 239
90 684.4047 2025-08-29 00:00:00.0 7.1657 239
91 691.6084 2025-08-30 00:00:00.0 7.2037 239
92 698.6937 2025-08-31 00:00:00.0 7.0853 239
93 706.0855 2025-09-01 00:00:00.0 7.3918 239
94 714.1203 2025-09-02 00:00:00.0 8.0348 239
95 719.2490 2025-09-03 00:00:00.0 5.1287 239
96 721.4544 2025-09-04 00:00:00.0 2.2054 239
97 722.3413 2025-09-05 00:00:00.0 0.8869 239
98 725.7861 2025-09-06 00:00:00.0 3.4448 239
99 728.5024 2025-09-07 00:00:00.0 2.7163 239
100 732.2597 2025-09-08 00:00:00.0 3.7573 239
101 739.8129 2025-09-09 00:00:00.0 7.5532 239
102 746.4374 2025-09-10 00:00:00.0 6.6245 239
103 753.7085 2025-09-11 00:00:00.0 7.2711 239
104 763.0312 2025-09-12 00:00:00.0 9.3227 239
105 772.1372 2025-09-13 00:00:00.0 9.1060 239
106 781.2904 2025-09-14 00:00:00.0 9.1532 239
107 791.0646 2025-09-15 00:00:00.0 9.7742 239
108 800.8278 2025-09-16 00:00:00.0 9.7632 239
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '239') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-16'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/16/2025 10 801
9/15/2025 10 791
9/14/2025 9 781
9/13/2025 9 772
9/12/2025 9 763
9/11/2025 7 754
9/10/2025 7 746
9/9/2025 8 740
9/8/2025 4 732
9/7/2025 3 729
9/6/2025 3 726
9/5/2025 1 722
9/4/2025 2 721
9/3/2025 5 719
9/2/2025 8 714
9/1/2025 7 706
8/31/2025 7 699
8/30/2025 7 692
8/29/2025 7 684
8/28/2025 7 677
8/27/2025 7 670
8/26/2025 6 663
8/25/2025 6 657
8/24/2025 7 652
8/23/2025 7 644
8/22/2025 9 638
8/21/2025 8 629
8/20/2025 9 621
8/19/2025 9 613
8/18/2025 9 603
8/17/2025 8 595
8/16/2025 7 587
8/15/2025 9 580
8/14/2025 7 571
8/13/2025 8 564
8/12/2025 9 557
8/11/2025 9 547
8/10/2025 8 538
8/9/2025 10 530
8/8/2025 8 520
8/7/2025 9 512
8/6/2025 9 503
8/5/2025 8 494
8/4/2025 8 485
8/3/2025 9 477
8/2/2025 7 468
8/1/2025 6 461
7/31/2025 8 455
7/30/2025 8 447
7/29/2025 8 439
7/28/2025 9 430
7/27/2025 8 421
7/26/2025 8 413
7/25/2025 1 406
7/24/2025 9 405
7/23/2025 9 395
7/22/2025 9 386
7/21/2025 9 377
7/20/2025 7 368
7/19/2025 7 362
7/18/2025 6 354
7/17/2025 6 349
7/16/2025 7 343
7/15/2025 9 336
7/14/2025 8 327
7/13/2025 8 319
7/12/2025 9 311
7/11/2025 8 302
7/10/2025 8 294
7/9/2025 7 286
7/8/2025 7 280
7/7/2025 6 273
7/6/2025 8 267
7/5/2025 7 259
7/4/2025 7 252
7/3/2025 9 245
7/2/2025 8 236
7/1/2025 9 229
6/30/2025 9 220
6/29/2025 7 211
6/28/2025 8 204
6/27/2025 9 196
6/26/2025 8 187
6/25/2025 6 180
6/24/2025 4 174
6/23/2025 7 169
6/22/2025 10 162
6/21/2025 9 152
6/20/2025 8 144
6/19/2025 8 135
6/18/2025 9 127
6/17/2025 9 119
6/16/2025 8 109
6/15/2025 8 101
6/14/2025 7 94
6/13/2025 7 87
6/12/2025 6 80
6/11/2025 8 74
6/10/2025 6 66
6/9/2025 4 60
6/8/2025 8 55
6/7/2025 7 47
6/6/2025 5 41
6/5/2025 6 35
6/4/2025 7 29
6/3/2025 8 23
6/2/2025 7 14
6/1/2025 8 8