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
40 288.8530 2025-07-10 00:00:00.0 7.2920 550
41 297.5021 2025-07-11 00:00:00.0 8.6491 550
42 305.2341 2025-07-12 00:00:00.0 7.7320 550
43 311.6383 2025-07-13 00:00:00.0 6.4042 550
44 319.7647 2025-07-14 00:00:00.0 8.1264 550
45 327.8997 2025-07-15 00:00:00.0 8.1350 550
46 334.2960 2025-07-16 00:00:00.0 6.3963 550
47 340.5354 2025-07-17 00:00:00.0 6.2394 550
48 340.5354 2025-07-18 00:00:00.0 0.0000 550
49 347.6617 2025-07-19 00:00:00.0 7.1263 550
50 354.8966 2025-07-20 00:00:00.0 7.2349 550
51 363.8736 2025-07-21 00:00:00.0 8.9770 550
52 372.6088 2025-07-22 00:00:00.0 8.7352 550
53 381.8777 2025-07-23 00:00:00.0 9.2689 550
54 391.1721 2025-07-24 00:00:00.0 9.2944 550
55 399.0133 2025-07-25 00:00:00.0 7.8412 550
56 406.3882 2025-07-26 00:00:00.0 7.3749 550
57 414.8009 2025-07-27 00:00:00.0 8.4127 550
58 423.7750 2025-07-28 00:00:00.0 8.9741 550
59 432.4063 2025-07-29 00:00:00.0 8.6313 550
60 440.2626 2025-07-30 00:00:00.0 7.8563 550
61 447.3654 2025-07-31 00:00:00.0 7.1028 550
62 453.6989 2025-08-01 00:00:00.0 6.3335 550
63 461.4315 2025-08-02 00:00:00.0 7.7326 550
64 469.5035 2025-08-03 00:00:00.0 8.0720 550
65 478.4213 2025-08-04 00:00:00.0 8.9178 550
66 487.6881 2025-08-05 00:00:00.0 9.2668 550
67 497.3186 2025-08-06 00:00:00.0 9.6305 550
68 506.1594 2025-08-07 00:00:00.0 8.8408 550
69 514.2448 2025-08-08 00:00:00.0 8.0854 550
70 524.0120 2025-08-09 00:00:00.0 9.7672 550
71 531.8559 2025-08-10 00:00:00.0 7.8439 550
72 540.9894 2025-08-11 00:00:00.0 9.1335 550
73 549.5764 2025-08-12 00:00:00.0 8.5870 550
74 557.4097 2025-08-13 00:00:00.0 7.8333 550
75 565.3300 2025-08-14 00:00:00.0 7.9203 550
76 573.9598 2025-08-15 00:00:00.0 8.6298 550
77 579.7764 2025-08-16 00:00:00.0 5.8166 550
78 587.2489 2025-08-17 00:00:00.0 7.4725 550
79 596.0437 2025-08-18 00:00:00.0 8.7948 550
80 605.2315 2025-08-19 00:00:00.0 9.1878 550
81 613.8296 2025-08-20 00:00:00.0 8.5981 550
82 621.4340 2025-08-21 00:00:00.0 7.6044 550
83 629.8063 2025-08-22 00:00:00.0 8.3723 550
84 634.9899 2025-08-23 00:00:00.0 5.1836 550
85 640.3072 2025-08-24 00:00:00.0 5.3173 550
86 645.3242 2025-08-25 00:00:00.0 5.0170 550
87 651.0679 2025-08-26 00:00:00.0 5.7437 550
88 656.9866 2025-08-27 00:00:00.0 5.9187 550
89 663.5553 2025-08-28 00:00:00.0 6.5687 550
90 671.7582 2025-08-29 00:00:00.0 8.2029 550
91 679.3694 2025-08-30 00:00:00.0 7.6112 550
92 686.6928 2025-08-31 00:00:00.0 7.3234 550
93 694.5447 2025-09-01 00:00:00.0 7.8519 550
94 702.7712 2025-09-02 00:00:00.0 8.2265 550
95 706.9628 2025-09-03 00:00:00.0 4.1916 550
96 708.7655 2025-09-04 00:00:00.0 1.8027 550
97 710.2103 2025-09-05 00:00:00.0 1.4448 550
98 712.4390 2025-09-06 00:00:00.0 2.2287 550
99 714.4706 2025-09-07 00:00:00.0 2.0316 550
100 718.4119 2025-09-08 00:00:00.0 3.9413 550
101 724.6324 2025-09-09 00:00:00.0 6.2205 550
102 732.2717 2025-09-10 00:00:00.0 7.6393 550
103 739.9986 2025-09-11 00:00:00.0 7.7269 550
104 748.9036 2025-09-12 00:00:00.0 8.9050 550
105 757.9964 2025-09-13 00:00:00.0 9.0928 550
106 767.5264 2025-09-14 00:00:00.0 9.5300 550
107 777.1521 2025-09-15 00:00:00.0 9.6257 550
108 786.6622 2025-09-16 00:00:00.0 9.5101 550
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '550') 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 787
9/15/2025 10 777
9/14/2025 10 768
9/13/2025 9 758
9/12/2025 9 749
9/11/2025 8 740
9/10/2025 8 732
9/9/2025 6 725
9/8/2025 4 718
9/7/2025 2 714
9/6/2025 2 712
9/5/2025 1 710
9/4/2025 2 709
9/3/2025 4 707
9/2/2025 8 703
9/1/2025 8 695
8/31/2025 7 687
8/30/2025 8 679
8/29/2025 8 672
8/28/2025 7 664
8/27/2025 6 657
8/26/2025 6 651
8/25/2025 5 645
8/24/2025 5 640
8/23/2025 5 635
8/22/2025 8 630
8/21/2025 8 621
8/20/2025 9 614
8/19/2025 9 605
8/18/2025 9 596
8/17/2025 7 587
8/16/2025 6 580
8/15/2025 9 574
8/14/2025 8 565
8/13/2025 8 557
8/12/2025 9 550
8/11/2025 9 541
8/10/2025 8 532
8/9/2025 10 524
8/8/2025 8 514
8/7/2025 9 506
8/6/2025 10 497
8/5/2025 9 488
8/4/2025 9 478
8/3/2025 8 470
8/2/2025 8 461
8/1/2025 6 454
7/31/2025 7 447
7/30/2025 8 440
7/29/2025 9 432
7/28/2025 9 424
7/27/2025 8 415
7/26/2025 7 406
7/25/2025 8 399
7/24/2025 9 391
7/23/2025 9 382
7/22/2025 9 373
7/21/2025 9 364
7/20/2025 7 355
7/19/2025 7 348
7/18/2025 0 341
7/17/2025 6 341
7/16/2025 6 334
7/15/2025 8 328
7/14/2025 8 320
7/13/2025 6 312
7/12/2025 8 305
7/11/2025 9 298
7/10/2025 7 289
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