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.0931 2025-06-01 00:00:00.0 7.0931 223
2 14.5050 2025-06-02 00:00:00.0 7.4119 223
3 23.1993 2025-06-03 00:00:00.0 8.6943 223
4 31.1085 2025-06-04 00:00:00.0 7.9092 223
5 38.3933 2025-06-05 00:00:00.0 7.2848 223
6 43.7919 2025-06-06 00:00:00.0 5.3986 223
7 51.0014 2025-06-07 00:00:00.0 7.2095 223
8 59.6278 2025-06-08 00:00:00.0 8.6264 223
9 65.1358 2025-06-09 00:00:00.0 5.5080 223
10 69.5431 2025-06-10 00:00:00.0 4.4073 223
11 75.8860 2025-06-11 00:00:00.0 6.3429 223
12 80.8048 2025-06-12 00:00:00.0 4.9188 223
13 88.7164 2025-06-13 00:00:00.0 7.9116 223
14 96.1112 2025-06-14 00:00:00.0 7.3948 223
15 103.7186 2025-06-15 00:00:00.0 7.6074 223
16 111.3946 2025-06-16 00:00:00.0 7.6760 223
17 120.9384 2025-06-17 00:00:00.0 9.5438 223
18 129.6763 2025-06-18 00:00:00.0 8.7379 223
19 137.4488 2025-06-19 00:00:00.0 7.7725 223
20 146.0245 2025-06-20 00:00:00.0 8.5757 223
21 154.0691 2025-06-21 00:00:00.0 8.0446 223
22 162.1000 2025-06-22 00:00:00.0 8.0309 223
23 170.8888 2025-06-23 00:00:00.0 8.7888 223
24 177.9908 2025-06-24 00:00:00.0 7.1020 223
25 183.4285 2025-06-25 00:00:00.0 5.4377 223
26 191.8433 2025-06-26 00:00:00.0 8.4148 223
27 200.6069 2025-06-27 00:00:00.0 8.7636 223
28 208.1855 2025-06-28 00:00:00.0 7.5786 223
29 215.5389 2025-06-29 00:00:00.0 7.3534 223
30 224.5211 2025-06-30 00:00:00.0 8.9822 223
31 233.5223 2025-07-01 00:00:00.0 9.0012 223
32 242.0334 2025-07-02 00:00:00.0 8.5111 223
33 250.2871 2025-07-03 00:00:00.0 8.2537 223
34 257.2342 2025-07-04 00:00:00.0 6.9471 223
35 264.1135 2025-07-05 00:00:00.0 6.8793 223
36 273.0756 2025-07-06 00:00:00.0 8.9621 223
37 281.0468 2025-07-07 00:00:00.0 7.9712 223
38 288.7795 2025-07-08 00:00:00.0 7.7327 223
39 297.0837 2025-07-09 00:00:00.0 8.3042 223
40 304.9955 2025-07-10 00:00:00.0 7.9118 223
41 311.9491 2025-07-11 00:00:00.0 6.9536 223
42 321.5051 2025-07-12 00:00:00.0 9.5560 223
43 330.1551 2025-07-13 00:00:00.0 8.6500 223
44 339.1681 2025-07-14 00:00:00.0 9.0130 223
45 348.4206 2025-07-15 00:00:00.0 9.2525 223
46 356.6928 2025-07-16 00:00:00.0 8.2722 223
47 362.5698 2025-07-17 00:00:00.0 5.8770 223
48 368.2724 2025-07-18 00:00:00.0 5.7026 223
49 376.2140 2025-07-19 00:00:00.0 7.9416 223
50 384.1142 2025-07-20 00:00:00.0 7.9002 223
51 391.8766 2025-07-21 00:00:00.0 7.7624 223
52 400.8085 2025-07-22 00:00:00.0 8.9319 223
53 410.3741 2025-07-23 00:00:00.0 9.5656 223
54 419.5514 2025-07-24 00:00:00.0 9.1773 223
55 428.5579 2025-07-25 00:00:00.0 9.0065 223
56 436.1160 2025-07-26 00:00:00.0 7.5581 223
57 443.6523 2025-07-27 00:00:00.0 7.5363 223
58 453.1737 2025-07-28 00:00:00.0 9.5214 223
59 462.0323 2025-07-29 00:00:00.0 8.8586 223
60 470.3808 2025-07-30 00:00:00.0 8.3485 223
61 476.8537 2025-07-31 00:00:00.0 6.4729 223
62 483.4767 2025-08-01 00:00:00.0 6.6230 223
63 491.3812 2025-08-02 00:00:00.0 7.9045 223
64 500.6121 2025-08-03 00:00:00.0 9.2309 223
65 508.7269 2025-08-04 00:00:00.0 8.1148 223
66 517.6393 2025-08-05 00:00:00.0 8.9124 223
67 526.8709 2025-08-06 00:00:00.0 9.2316 223
68 536.2421 2025-08-07 00:00:00.0 9.3712 223
69 543.9077 2025-08-08 00:00:00.0 7.6656 223
70 553.3337 2025-08-09 00:00:00.0 9.4260 223
71 562.8323 2025-08-10 00:00:00.0 9.4986 223
72 572.1322 2025-08-11 00:00:00.0 9.2999 223
73 581.5528 2025-08-12 00:00:00.0 9.4206 223
74 590.4148 2025-08-13 00:00:00.0 8.8620 223
75 597.0960 2025-08-14 00:00:00.0 6.6812 223
76 605.4740 2025-08-15 00:00:00.0 8.3780 223
77 614.2890 2025-08-16 00:00:00.0 8.8150 223
78 622.5270 2025-08-17 00:00:00.0 8.2380 223
79 630.9867 2025-08-18 00:00:00.0 8.4597 223
80 640.5312 2025-08-19 00:00:00.0 9.5445 223
81 649.5048 2025-08-20 00:00:00.0 8.9736 223
82 658.1040 2025-08-21 00:00:00.0 8.5992 223
83 667.2006 2025-08-22 00:00:00.0 9.0966 223
84 675.5645 2025-08-23 00:00:00.0 8.3639 223
85 683.0815 2025-08-24 00:00:00.0 7.5170 223
86 688.6635 2025-08-25 00:00:00.0 5.5820 223
87 693.2188 2025-08-26 00:00:00.0 4.5553 223
88 701.4081 2025-08-27 00:00:00.0 8.1893 223
89 710.5003 2025-08-28 00:00:00.0 9.0922 223
90 718.2233 2025-08-29 00:00:00.0 7.7230 223
91 726.0546 2025-08-30 00:00:00.0 7.8313 223
92 733.7202 2025-08-31 00:00:00.0 7.6656 223
93 741.8632 2025-09-01 00:00:00.0 8.1430 223
94 750.7867 2025-09-02 00:00:00.0 8.9235 223
95 756.3649 2025-09-03 00:00:00.0 5.5782 223
96 759.3362 2025-09-04 00:00:00.0 2.9713 223
97 759.6213 2025-09-05 00:00:00.0 0.2851 223
98 763.8381 2025-09-06 00:00:00.0 4.2168 223
99 767.3375 2025-09-07 00:00:00.0 3.4994 223
100 770.5564 2025-09-08 00:00:00.0 3.2189 223
101 777.5346 2025-09-09 00:00:00.0 6.9782 223
102 784.2225 2025-09-10 00:00:00.0 6.6879 223
103 791.0891 2025-09-11 00:00:00.0 6.8666 223
104 799.8175 2025-09-12 00:00:00.0 8.7284 223
105 808.9888 2025-09-13 00:00:00.0 9.1713 223
106 818.2744 2025-09-14 00:00:00.0 9.2856 223
107 827.9465 2025-09-15 00:00:00.0 9.6721 223
108 836.6678 2025-09-16 00:00:00.0 8.7213 223
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '223') 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 9 837
9/15/2025 10 828
9/14/2025 9 818
9/13/2025 9 809
9/12/2025 9 800
9/11/2025 7 791
9/10/2025 7 784
9/9/2025 7 778
9/8/2025 3 771
9/7/2025 3 767
9/6/2025 4 764
9/5/2025 0 760
9/4/2025 3 759
9/3/2025 6 756
9/2/2025 9 751
9/1/2025 8 742
8/31/2025 8 734
8/30/2025 8 726
8/29/2025 8 718
8/28/2025 9 711
8/27/2025 8 701
8/26/2025 5 693
8/25/2025 6 689
8/24/2025 8 683
8/23/2025 8 676
8/22/2025 9 667
8/21/2025 9 658
8/20/2025 9 650
8/19/2025 10 641
8/18/2025 8 631
8/17/2025 8 623
8/16/2025 9 614
8/15/2025 8 605
8/14/2025 7 597
8/13/2025 9 590
8/12/2025 9 582
8/11/2025 9 572
8/10/2025 9 563
8/9/2025 9 553
8/8/2025 8 544
8/7/2025 9 536
8/6/2025 9 527
8/5/2025 9 518
8/4/2025 8 509
8/3/2025 9 501
8/2/2025 8 491
8/1/2025 7 483
7/31/2025 6 477
7/30/2025 8 470
7/29/2025 9 462
7/28/2025 10 453
7/27/2025 8 444
7/26/2025 8 436
7/25/2025 9 429
7/24/2025 9 420
7/23/2025 10 410
7/22/2025 9 401
7/21/2025 8 392
7/20/2025 8 384
7/19/2025 8 376
7/18/2025 6 368
7/17/2025 6 363
7/16/2025 8 357
7/15/2025 9 348
7/14/2025 9 339
7/13/2025 9 330
7/12/2025 10 322
7/11/2025 7 312
7/10/2025 8 305
7/9/2025 8 297
7/8/2025 8 289
7/7/2025 8 281
7/6/2025 9 273
7/5/2025 7 264
7/4/2025 7 257
7/3/2025 8 250
7/2/2025 9 242
7/1/2025 9 234
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 5 183
6/24/2025 7 178
6/23/2025 9 171
6/22/2025 8 162
6/21/2025 8 154
6/20/2025 9 146
6/19/2025 8 137
6/18/2025 9 130
6/17/2025 10 121
6/16/2025 8 111
6/15/2025 8 104
6/14/2025 7 96
6/13/2025 8 89
6/12/2025 5 81
6/11/2025 6 76
6/10/2025 4 70
6/9/2025 6 65
6/8/2025 9 60
6/7/2025 7 51
6/6/2025 5 44
6/5/2025 7 38
6/4/2025 8 31
6/3/2025 9 23
6/2/2025 7 15
6/1/2025 7 7