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.2260 2025-06-01 00:00:00.0 7.2260 524
2 14.1060 2025-06-02 00:00:00.0 6.8800 524
3 22.6594 2025-06-03 00:00:00.0 8.5534 524
4 30.7148 2025-06-04 00:00:00.0 8.0554 524
5 37.9958 2025-06-05 00:00:00.0 7.2810 524
6 43.3968 2025-06-06 00:00:00.0 5.4010 524
7 50.8240 2025-06-07 00:00:00.0 7.4272 524
8 59.1433 2025-06-08 00:00:00.0 8.3193 524
9 64.3413 2025-06-09 00:00:00.0 5.1980 524
10 69.7559 2025-06-10 00:00:00.0 5.4146 524
11 77.1029 2025-06-11 00:00:00.0 7.3470 524
12 83.8719 2025-06-12 00:00:00.0 6.7690 524
13 90.7574 2025-06-13 00:00:00.0 6.8855 524
14 98.1099 2025-06-14 00:00:00.0 7.3525 524
15 105.0115 2025-06-15 00:00:00.0 6.9016 524
16 112.5788 2025-06-16 00:00:00.0 7.5673 524
17 121.7752 2025-06-17 00:00:00.0 9.1964 524
18 130.2865 2025-06-18 00:00:00.0 8.5113 524
19 138.4052 2025-06-19 00:00:00.0 8.1187 524
20 146.7938 2025-06-20 00:00:00.0 8.3886 524
21 154.7888 2025-06-21 00:00:00.0 7.9950 524
22 163.7944 2025-06-22 00:00:00.0 9.0056 524
23 172.6762 2025-06-23 00:00:00.0 8.8818 524
24 178.5218 2025-06-24 00:00:00.0 5.8456 524
25 184.5054 2025-06-25 00:00:00.0 5.9836 524
26 192.3194 2025-06-26 00:00:00.0 7.8140 524
27 200.8394 2025-06-27 00:00:00.0 8.5200 524
28 208.3979 2025-06-28 00:00:00.0 7.5585 524
29 215.8380 2025-06-29 00:00:00.0 7.4401 524
30 224.6761 2025-06-30 00:00:00.0 8.8381 524
31 233.3965 2025-07-01 00:00:00.0 8.7204 524
32 241.4657 2025-07-02 00:00:00.0 8.0692 524
33 250.1383 2025-07-03 00:00:00.0 8.6726 524
34 257.0990 2025-07-04 00:00:00.0 6.9607 524
35 264.1127 2025-07-05 00:00:00.0 7.0137 524
36 272.6691 2025-07-06 00:00:00.0 8.5564 524
37 280.0463 2025-07-07 00:00:00.0 7.3772 524
38 288.0124 2025-07-08 00:00:00.0 7.9661 524
39 295.5854 2025-07-09 00:00:00.0 7.5730 524
40 303.3220 2025-07-10 00:00:00.0 7.7366 524
41 310.2591 2025-07-11 00:00:00.0 6.9371 524
42 319.4609 2025-07-12 00:00:00.0 9.2018 524
43 327.8847 2025-07-13 00:00:00.0 8.4238 524
44 336.3621 2025-07-14 00:00:00.0 8.4774 524
45 344.9906 2025-07-15 00:00:00.0 8.6285 524
46 352.0729 2025-07-16 00:00:00.0 7.0823 524
47 358.2077 2025-07-17 00:00:00.0 6.1348 524
48 364.7430 2025-07-18 00:00:00.0 6.5353 524
49 372.6982 2025-07-19 00:00:00.0 7.9552 524
50 380.3802 2025-07-20 00:00:00.0 7.6820 524
51 388.2238 2025-07-21 00:00:00.0 7.8436 524
52 396.9620 2025-07-22 00:00:00.0 8.7382 524
53 406.5611 2025-07-23 00:00:00.0 9.5991 524
54 415.9060 2025-07-24 00:00:00.0 9.3449 524
55 425.1564 2025-07-25 00:00:00.0 9.2504 524
56 432.7326 2025-07-26 00:00:00.0 7.5762 524
57 440.3232 2025-07-27 00:00:00.0 7.5906 524
58 449.8606 2025-07-28 00:00:00.0 9.5374 524
59 459.0226 2025-07-29 00:00:00.0 9.1620 524
60 467.8261 2025-07-30 00:00:00.0 8.8035 524
61 475.3092 2025-07-31 00:00:00.0 7.4831 524
62 483.1129 2025-08-01 00:00:00.0 7.8037 524
63 489.5278 2025-08-02 00:00:00.0 6.4149 524
64 497.9444 2025-08-03 00:00:00.0 8.4166 524
65 506.0560 2025-08-04 00:00:00.0 8.1116 524
66 515.2398 2025-08-05 00:00:00.0 9.1838 524
67 524.1529 2025-08-06 00:00:00.0 8.9131 524
68 532.2732 2025-08-07 00:00:00.0 8.1203 524
69 539.8856 2025-08-08 00:00:00.0 7.6124 524
70 549.4545 2025-08-09 00:00:00.0 9.5689 524
71 558.4757 2025-08-10 00:00:00.0 9.0212 524
72 567.6854 2025-08-11 00:00:00.0 9.2097 524
73 577.0232 2025-08-12 00:00:00.0 9.3378 524
74 585.6073 2025-08-13 00:00:00.0 8.5841 524
75 592.3584 2025-08-14 00:00:00.0 6.7511 524
76 600.5642 2025-08-15 00:00:00.0 8.2058 524
77 608.8565 2025-08-16 00:00:00.0 8.2923 524
78 617.4028 2025-08-17 00:00:00.0 8.5463 524
79 625.1550 2025-08-18 00:00:00.0 7.7522 524
80 634.5760 2025-08-19 00:00:00.0 9.4210 524
81 643.6028 2025-08-20 00:00:00.0 9.0268 524
82 651.7322 2025-08-21 00:00:00.0 8.1294 524
83 660.3274 2025-08-22 00:00:00.0 8.5952 524
84 668.3084 2025-08-23 00:00:00.0 7.9810 524
85 676.1382 2025-08-24 00:00:00.0 7.8298 524
86 682.8989 2025-08-25 00:00:00.0 6.7607 524
87 688.9888 2025-08-26 00:00:00.0 6.0899 524
88 696.6031 2025-08-27 00:00:00.0 7.6143 524
89 704.6081 2025-08-28 00:00:00.0 8.0050 524
90 712.1205 2025-08-29 00:00:00.0 7.5124 524
91 719.5838 2025-08-30 00:00:00.0 7.4633 524
92 726.7016 2025-08-31 00:00:00.0 7.1178 524
93 734.0322 2025-09-01 00:00:00.0 7.3306 524
94 742.2990 2025-09-02 00:00:00.0 8.2668 524
95 747.2663 2025-09-03 00:00:00.0 4.9673 524
96 750.9624 2025-09-04 00:00:00.0 3.6961 524
97 751.1838 2025-09-05 00:00:00.0 0.2214 524
98 755.6648 2025-09-06 00:00:00.0 4.4810 524
99 759.3179 2025-09-07 00:00:00.0 3.6531 524
100 763.4887 2025-09-08 00:00:00.0 4.1708 524
101 769.8909 2025-09-09 00:00:00.0 6.4022 524
102 776.9638 2025-09-10 00:00:00.0 7.0729 524
103 783.4583 2025-09-11 00:00:00.0 6.4945 524
104 790.6563 2025-09-12 00:00:00.0 7.1980 524
105 799.8549 2025-09-13 00:00:00.0 9.1986 524
106 808.5646 2025-09-14 00:00:00.0 8.7097 524
107 818.1069 2025-09-15 00:00:00.0 9.5423 524
108 827.4531 2025-09-16 00:00:00.0 9.3462 524
109 836.4181 2025-09-17 00:00:00.0 8.9650 524
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '524') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-17'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/17/2025 9 836
9/16/2025 9 827
9/15/2025 10 818
9/14/2025 9 809
9/13/2025 9 800
9/12/2025 7 791
9/11/2025 6 783
9/10/2025 7 777
9/9/2025 6 770
9/8/2025 4 763
9/7/2025 4 759
9/6/2025 4 756
9/5/2025 0 751
9/4/2025 4 751
9/3/2025 5 747
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 705
8/27/2025 8 697
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 652
8/20/2025 9 644
8/19/2025 9 635
8/18/2025 8 625
8/17/2025 9 617
8/16/2025 8 609
8/15/2025 8 601
8/14/2025 7 592
8/13/2025 9 586
8/12/2025 9 577
8/11/2025 9 568
8/10/2025 9 558
8/9/2025 10 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 6 490
8/1/2025 8 483
7/31/2025 7 475
7/30/2025 9 468
7/29/2025 9 459
7/28/2025 10 450
7/27/2025 8 440
7/26/2025 8 433
7/25/2025 9 425
7/24/2025 9 416
7/23/2025 10 407
7/22/2025 9 397
7/21/2025 8 388
7/20/2025 8 380
7/19/2025 8 373
7/18/2025 7 365
7/17/2025 6 358
7/16/2025 7 352
7/15/2025 9 345
7/14/2025 8 336
7/13/2025 8 328
7/12/2025 9 319
7/11/2025 7 310
7/10/2025 8 303
7/9/2025 8 296
7/8/2025 8 288
7/7/2025 7 280
7/6/2025 9 273
7/5/2025 7 264
7/4/2025 7 257
7/3/2025 9 250
7/2/2025 8 241
7/1/2025 9 233
6/30/2025 9 225
6/29/2025 7 216
6/28/2025 8 208
6/27/2025 9 201
6/26/2025 8 192
6/25/2025 6 185
6/24/2025 6 179
6/23/2025 9 173
6/22/2025 9 164
6/21/2025 8 155
6/20/2025 8 147
6/19/2025 8 138
6/18/2025 9 130
6/17/2025 9 122
6/16/2025 8 113
6/15/2025 7 105
6/14/2025 7 98
6/13/2025 7 91
6/12/2025 7 84
6/11/2025 7 77
6/10/2025 5 70
6/9/2025 5 64
6/8/2025 8 59
6/7/2025 7 51
6/6/2025 5 43
6/5/2025 7 38
6/4/2025 8 31
6/3/2025 9 23
6/2/2025 7 14
6/1/2025 7 7