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.1122 2025-06-01 00:00:00.0 7.1122 536
2 13.8467 2025-06-02 00:00:00.0 6.7345 536
3 21.9827 2025-06-03 00:00:00.0 8.1360 536
4 28.2932 2025-06-04 00:00:00.0 6.3105 536
5 34.0716 2025-06-05 00:00:00.0 5.7784 536
6 39.5935 2025-06-06 00:00:00.0 5.5219 536
7 45.9513 2025-06-07 00:00:00.0 6.3578 536
8 53.7592 2025-06-08 00:00:00.0 7.8079 536
9 58.0431 2025-06-09 00:00:00.0 4.2839 536
10 61.5162 2025-06-10 00:00:00.0 3.4731 536
11 67.5078 2025-06-11 00:00:00.0 5.9916 536
12 73.4911 2025-06-12 00:00:00.0 5.9833 536
13 80.5548 2025-06-13 00:00:00.0 7.0637 536
14 87.9721 2025-06-14 00:00:00.0 7.4173 536
15 94.5816 2025-06-15 00:00:00.0 6.6095 536
16 101.5661 2025-06-16 00:00:00.0 6.9845 536
17 110.0313 2025-06-17 00:00:00.0 8.4652 536
18 118.2723 2025-06-18 00:00:00.0 8.2410 536
19 126.1184 2025-06-19 00:00:00.0 7.8461 536
20 134.3558 2025-06-20 00:00:00.0 8.2374 536
21 142.9083 2025-06-21 00:00:00.0 8.5525 536
22 152.4459 2025-06-22 00:00:00.0 9.5376 536
23 160.7285 2025-06-23 00:00:00.0 8.2826 536
24 165.8040 2025-06-24 00:00:00.0 5.0755 536
25 170.9301 2025-06-25 00:00:00.0 5.1261 536
26 178.0526 2025-06-26 00:00:00.0 7.1225 536
27 186.5473 2025-06-27 00:00:00.0 8.4947 536
28 193.4256 2025-06-28 00:00:00.0 6.8783 536
29 200.8651 2025-06-29 00:00:00.0 7.4395 536
30 209.4799 2025-06-30 00:00:00.0 8.6148 536
31 218.3229 2025-07-01 00:00:00.0 8.8430 536
32 226.4598 2025-07-02 00:00:00.0 8.1369 536
33 235.2274 2025-07-03 00:00:00.0 8.7676 536
34 242.5840 2025-07-04 00:00:00.0 7.3566 536
35 250.0443 2025-07-05 00:00:00.0 7.4603 536
36 259.0901 2025-07-06 00:00:00.0 9.0458 536
37 266.7150 2025-07-07 00:00:00.0 7.6249 536
38 273.1758 2025-07-08 00:00:00.0 6.4608 536
39 280.4410 2025-07-09 00:00:00.0 7.2652 536
40 287.9411 2025-07-10 00:00:00.0 7.5001 536
41 287.9411 2025-07-11 00:00:00.0 0.0000 536
42 297.2284 2025-07-12 00:00:00.0 9.2873 536
43 305.9048 2025-07-13 00:00:00.0 8.6764 536
44 314.2047 2025-07-14 00:00:00.0 8.2999 536
45 322.7141 2025-07-15 00:00:00.0 8.5094 536
46 330.6839 2025-07-16 00:00:00.0 7.9698 536
47 338.0675 2025-07-17 00:00:00.0 7.3836 536
48 343.9112 2025-07-18 00:00:00.0 5.8437 536
49 350.5162 2025-07-19 00:00:00.0 6.6050 536
50 358.2006 2025-07-20 00:00:00.0 7.6844 536
51 366.6017 2025-07-21 00:00:00.0 8.4011 536
52 375.2379 2025-07-22 00:00:00.0 8.6362 536
53 384.2837 2025-07-23 00:00:00.0 9.0458 536
54 393.3800 2025-07-24 00:00:00.0 9.0963 536
55 402.2517 2025-07-25 00:00:00.0 8.8717 536
56 409.5864 2025-07-26 00:00:00.0 7.3347 536
57 417.9913 2025-07-27 00:00:00.0 8.4049 536
58 427.3836 2025-07-28 00:00:00.0 9.3923 536
59 435.7533 2025-07-29 00:00:00.0 8.3697 536
60 440.8856 2025-07-30 00:00:00.0 5.1323 536
61 448.4238 2025-07-31 00:00:00.0 7.5382 536
62 454.9281 2025-08-01 00:00:00.0 6.5043 536
63 461.4416 2025-08-02 00:00:00.0 6.5135 536
64 469.2797 2025-08-03 00:00:00.0 7.8381 536
65 477.0798 2025-08-04 00:00:00.0 7.8001 536
66 485.7961 2025-08-05 00:00:00.0 8.7163 536
67 494.7239 2025-08-06 00:00:00.0 8.9278 536
68 502.7759 2025-08-07 00:00:00.0 8.0520 536
69 510.9908 2025-08-08 00:00:00.0 8.2149 536
70 520.3708 2025-08-09 00:00:00.0 9.3800 536
71 529.2820 2025-08-10 00:00:00.0 8.9112 536
72 538.4606 2025-08-11 00:00:00.0 9.1786 536
73 547.7146 2025-08-12 00:00:00.0 9.2540 536
74 556.0542 2025-08-13 00:00:00.0 8.3396 536
75 562.4044 2025-08-14 00:00:00.0 6.3502 536
76 570.6566 2025-08-15 00:00:00.0 8.2522 536
77 577.4557 2025-08-16 00:00:00.0 6.7991 536
78 585.1761 2025-08-17 00:00:00.0 7.7204 536
79 593.2741 2025-08-18 00:00:00.0 8.0980 536
80 602.7766 2025-08-19 00:00:00.0 9.5025 536
81 611.6637 2025-08-20 00:00:00.0 8.8871 536
82 619.5948 2025-08-21 00:00:00.0 7.9311 536
83 628.6826 2025-08-22 00:00:00.0 9.0878 536
84 635.9453 2025-08-23 00:00:00.0 7.2627 536
85 643.6261 2025-08-24 00:00:00.0 7.6808 536
86 649.5557 2025-08-25 00:00:00.0 5.9296 536
87 655.4414 2025-08-26 00:00:00.0 5.8857 536
88 661.9880 2025-08-27 00:00:00.0 6.5466 536
89 670.7026 2025-08-28 00:00:00.0 8.7146 536
90 678.4392 2025-08-29 00:00:00.0 7.7366 536
91 685.8572 2025-08-30 00:00:00.0 7.4180 536
92 692.9868 2025-08-31 00:00:00.0 7.1296 536
93 700.3555 2025-09-01 00:00:00.0 7.3687 536
94 708.5559 2025-09-02 00:00:00.0 8.2004 536
95 714.0479 2025-09-03 00:00:00.0 5.4920 536
96 717.0127 2025-09-04 00:00:00.0 2.9648 536
97 717.2662 2025-09-05 00:00:00.0 0.2535 536
98 722.0162 2025-09-06 00:00:00.0 4.7500 536
99 725.0612 2025-09-07 00:00:00.0 3.0450 536
100 729.0627 2025-09-08 00:00:00.0 4.0015 536
101 735.6210 2025-09-09 00:00:00.0 6.5583 536
102 742.5110 2025-09-10 00:00:00.0 6.8900 536
103 749.8198 2025-09-11 00:00:00.0 7.3088 536
104 757.6547 2025-09-12 00:00:00.0 7.8349 536
105 767.0879 2025-09-13 00:00:00.0 9.4332 536
106 776.1053 2025-09-14 00:00:00.0 9.0174 536
107 785.7372 2025-09-15 00:00:00.0 9.6319 536
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '536') 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 10 786
9/14/2025 9 776
9/13/2025 9 767
9/12/2025 8 758
9/11/2025 7 750
9/10/2025 7 743
9/9/2025 7 736
9/8/2025 4 729
9/7/2025 3 725
9/6/2025 5 722
9/5/2025 0 717
9/4/2025 3 717
9/3/2025 5 714
9/2/2025 8 709
9/1/2025 7 700
8/31/2025 7 693
8/30/2025 7 686
8/29/2025 8 678
8/28/2025 9 671
8/27/2025 7 662
8/26/2025 6 655
8/25/2025 6 650
8/24/2025 8 644
8/23/2025 7 636
8/22/2025 9 629
8/21/2025 8 620
8/20/2025 9 612
8/19/2025 10 603
8/18/2025 8 593
8/17/2025 8 585
8/16/2025 7 577
8/15/2025 8 571
8/14/2025 6 562
8/13/2025 8 556
8/12/2025 9 548
8/11/2025 9 538
8/10/2025 9 529
8/9/2025 9 520
8/8/2025 8 511
8/7/2025 8 503
8/6/2025 9 495
8/5/2025 9 486
8/4/2025 8 477
8/3/2025 8 469
8/2/2025 7 461
8/1/2025 7 455
7/31/2025 8 448
7/30/2025 5 441
7/29/2025 8 436
7/28/2025 9 427
7/27/2025 8 418
7/26/2025 7 410
7/25/2025 9 402
7/24/2025 9 393
7/23/2025 9 384
7/22/2025 9 375
7/21/2025 8 367
7/20/2025 8 358
7/19/2025 7 351
7/18/2025 6 344
7/17/2025 7 338
7/16/2025 8 331
7/15/2025 9 323
7/14/2025 8 314
7/13/2025 9 306
7/12/2025 9 297
7/11/2025 0 288
7/10/2025 8 288
7/9/2025 7 280
7/8/2025 6 273
7/7/2025 8 267
7/6/2025 9 259
7/5/2025 7 250
7/4/2025 7 243
7/3/2025 9 235
7/2/2025 8 226
7/1/2025 9 218
6/30/2025 9 209
6/29/2025 7 201
6/28/2025 7 193
6/27/2025 8 187
6/26/2025 7 178
6/25/2025 5 171
6/24/2025 5 166
6/23/2025 8 161
6/22/2025 10 152
6/21/2025 9 143
6/20/2025 8 134
6/19/2025 8 126
6/18/2025 8 118
6/17/2025 8 110
6/16/2025 7 102
6/15/2025 7 95
6/14/2025 7 88
6/13/2025 7 81
6/12/2025 6 73
6/11/2025 6 68
6/10/2025 3 62
6/9/2025 4 58
6/8/2025 8 54
6/7/2025 6 46
6/6/2025 6 40
6/5/2025 6 34
6/4/2025 6 28
6/3/2025 8 22
6/2/2025 7 14
6/1/2025 7 7