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.9203 2026-06-01 00:00:00.0 7.9203 559
2 16.8637 2026-06-02 00:00:00.0 8.9434 559
3 24.5742 2026-06-03 00:00:00.0 7.7105 559
4 33.5739 2026-06-04 00:00:00.0 8.9997 559
5 42.4082 2026-06-05 00:00:00.0 8.8343 559
6 50.8912 2026-06-06 00:00:00.0 8.4830 559
7 57.9256 2026-06-07 00:00:00.0 7.0344 559
8 62.6995 2026-06-08 00:00:00.0 4.7739 559
9 71.4755 2026-06-09 00:00:00.0 8.7760 559
10 78.1683 2026-06-10 00:00:00.0 6.6928 559
11 87.3396 2026-06-11 00:00:00.0 9.1713 559
12 95.9510 2026-06-12 00:00:00.0 8.6114 559
13 103.2151 2026-06-13 00:00:00.0 7.2641 559
14 109.6585 2026-06-14 00:00:00.0 6.4434 559
15 115.3411 2026-06-15 00:00:00.0 5.6826 559
16 121.7270 2026-06-16 00:00:00.0 6.3859 559
17 127.5973 2026-06-17 00:00:00.0 5.8703 559
18 133.0038 2026-06-18 00:00:00.0 5.4065 559
19 140.0554 2026-06-19 00:00:00.0 7.0516 559
20 147.8508 2026-06-20 00:00:00.0 7.7954 559
21 153.7505 2026-06-21 00:00:00.0 5.8997 559
22 159.4530 2026-06-22 00:00:00.0 5.7025 559
23 166.6822 2026-06-23 00:00:00.0 7.2292 559
24 174.7580 2026-06-24 00:00:00.0 8.0758 559
25 183.5209 2026-06-25 00:00:00.0 8.7629 559
26 190.4659 2026-06-26 00:00:00.0 6.9450 559
27 198.9613 2026-06-27 00:00:00.0 8.4954 559
28 208.3522 2026-06-28 00:00:00.0 9.3909 559
29 217.2389 2026-06-29 00:00:00.0 8.8867 559
30 226.7058 2026-06-30 00:00:00.0 9.4669 559
31 235.9497 2026-07-01 00:00:00.0 9.2439 559
32 245.0398 2026-07-02 00:00:00.0 9.0901 559
33 253.8403 2026-07-03 00:00:00.0 8.8005 559
34 261.8943 2026-07-04 00:00:00.0 8.0540 559
35 269.9571 2026-07-05 00:00:00.0 8.0628 559
36 277.4286 2026-07-06 00:00:00.0 7.4715 559
37 286.2312 2026-07-07 00:00:00.0 8.8026 559
38 294.3723 2026-07-08 00:00:00.0 8.1411 559
39 302.9864 2026-07-09 00:00:00.0 8.6141 559
40 312.2251 2026-07-10 00:00:00.0 9.2387 559
41 320.5705 2026-07-11 00:00:00.0 8.3454 559
42 327.1457 2026-07-12 00:00:00.0 6.5752 559
43 331.5264 2026-07-13 00:00:00.0 4.3807 559
44 336.4242 2026-07-14 00:00:00.0 4.8978 559
45 345.7611 2026-07-15 00:00:00.0 9.3369 559
46 355.3723 2026-07-16 00:00:00.0 9.6112 559
47 363.9806 2026-07-17 00:00:00.0 8.6083 559
48 372.8718 2026-07-18 00:00:00.0 8.8912 559
49 380.8630 2026-07-19 00:00:00.0 7.9912 559
50 388.0807 2026-07-20 00:00:00.0 7.2177 559
51 397.2013 2026-07-21 00:00:00.0 9.1206 559
52 406.1088 2026-07-22 00:00:00.0 8.9075 559
53 414.4310 2026-07-23 00:00:00.0 8.3222 559
54 423.0695 2026-07-24 00:00:00.0 8.6385 559
55 430.8900 2026-07-25 00:00:00.0 7.8205 559
56 439.0092 2026-07-26 00:00:00.0 8.1192 559
57 446.9553 2026-07-27 00:00:00.0 7.9461 559
58 455.2791 2026-07-28 00:00:00.0 8.3238 559
59 462.9888 2026-07-29 00:00:00.0 7.7097 559
60 469.5509 2026-07-30 00:00:00.0 6.5621 559
61 478.3670 2026-07-31 00:00:00.0 8.8161 559
62 486.4664 2026-08-01 00:00:00.0 8.0994 559
63 495.4908 2026-08-02 00:00:00.0 9.0244 559
64 502.3850 2026-08-03 00:00:00.0 6.8942 559
65 510.9546 2026-08-04 00:00:00.0 8.5696 559
66 517.8098 2026-08-05 00:00:00.0 6.8552 559
67 525.0585 2026-08-06 00:00:00.0 7.2487 559
68 532.7285 2026-08-07 00:00:00.0 7.6700 559
69 539.8785 2026-08-08 00:00:00.0 7.1500 559
70 546.5891 2026-08-09 00:00:00.0 6.7106 559
71 552.6787 2026-08-10 00:00:00.0 6.0896 559
72 561.6784 2026-08-11 00:00:00.0 8.9997 559
73 568.9854 2026-08-12 00:00:00.0 7.3070 559
74 577.5029 2026-08-13 00:00:00.0 8.5175 559
75 585.9307 2026-08-14 00:00:00.0 8.4278 559
76 594.7498 2026-08-15 00:00:00.0 8.8191 559
77 603.5103 2026-08-16 00:00:00.0 8.7605 559
78 611.1597 2026-08-17 00:00:00.0 7.6494 559
79 618.5395 2026-08-18 00:00:00.0 7.3798 559
80 624.6696 2026-08-19 00:00:00.0 6.1301 559
81 631.1134 2026-08-20 00:00:00.0 6.4438 559
82 638.1296 2026-08-21 00:00:00.0 7.0162 559
83 646.3069 2026-08-22 00:00:00.0 8.1773 559
84 652.7725 2026-08-23 00:00:00.0 6.4656 559
85 660.3852 2026-08-24 00:00:00.0 7.6127 559
86 668.6644 2026-08-25 00:00:00.0 8.2792 559
87 677.8896 2026-08-26 00:00:00.0 9.2252 559
88 685.7711 2026-08-27 00:00:00.0 7.8815 559
89 692.1312 2026-08-28 00:00:00.0 6.3601 559
90 700.3146 2026-08-29 00:00:00.0 8.1834 559
91 708.5204 2026-08-30 00:00:00.0 8.2058 559
92 717.0029 2026-08-31 00:00:00.0 8.4825 559
93 725.8673 2026-09-01 00:00:00.0 8.8644 559
94 734.7667 2026-09-02 00:00:00.0 8.8994 559
95 742.5690 2026-09-03 00:00:00.0 7.8023 559
96 750.2599 2026-09-04 00:00:00.0 7.6909 559
97 758.6131 2026-09-05 00:00:00.0 8.3532 559
98 767.3089 2026-09-06 00:00:00.0 8.6958 559
99 776.1889 2026-09-07 00:00:00.0 8.8800 559
100 786.0278 2026-09-08 00:00:00.0 9.8389 559
101 794.9783 2026-09-09 00:00:00.0 8.9505 559
102 803.1334 2026-09-10 00:00:00.0 8.1551 559
103 810.6194 2026-09-11 00:00:00.0 7.4860 559
104 818.3899 2026-09-12 00:00:00.0 7.7705 559
105 822.3986 2026-09-13 00:00:00.0 4.0087 559
106 825.4294 2026-09-14 00:00:00.0 3.0308 559
107 829.3727 2026-09-15 00:00:00.0 3.9433 559
108 832.7583 2026-09-16 00:00:00.0 3.3856 559
109 835.3996 2026-09-17 00:00:00.0 2.6413 559
110 839.0218 2026-09-18 00:00:00.0 3.6222 559
111 845.7825 2026-09-19 00:00:00.0 6.7607 559
112 853.6571 2026-09-20 00:00:00.0 7.8746 559
113 857.4810 2026-09-21 00:00:00.0 3.8239 559
114 862.2369 2026-09-22 00:00:00.0 4.7559 559
115 867.0948 2026-09-23 00:00:00.0 4.8579 559
116 873.3141 2026-09-24 00:00:00.0 6.2193 559
117 881.9387 2026-09-25 00:00:00.0 8.6246 559
118 889.9646 2026-09-26 00:00:00.0 8.0259 559
119 898.2679 2026-09-27 00:00:00.0 8.3033 559
120 902.8660 2026-09-28 00:00:00.0 4.5981 559
121 907.5675 2026-09-29 00:00:00.0 4.7015 559
122 915.4386 2026-09-30 00:00:00.0 7.8711 559
123 919.7132 2026-10-01 00:00:00.0 4.2746 559
124 921.9274 2026-10-02 00:00:00.0 2.2142 559
125 925.1136 2026-10-03 00:00:00.0 3.1862 559
126 929.9847 2026-10-04 00:00:00.0 4.8711 559
127 933.0976 2026-10-05 00:00:00.0 3.1129 559
128 936.6426 2026-10-06 00:00:00.0 3.5450 559
129 941.6590 2026-10-07 00:00:00.0 5.0164 559
130 945.5151 2026-10-08 00:00:00.0 3.8561 559
131 947.6873 2026-10-09 00:00:00.0 2.1722 559
132 952.5898 2026-10-10 00:00:00.0 4.9025 559
133 960.6558 2026-10-11 00:00:00.0 8.0660 559
134 962.0839 2026-10-12 00:00:00.0 1.4281 559
135 962.0839 2026-10-13 00:00:00.0 0.0000 559
136 962.3374 2026-10-14 00:00:00.0 0.2535 559
137 963.3994 2026-10-15 00:00:00.0 1.0620 559
138 963.7002 2026-10-16 00:00:00.0 0.3008 559
139 964.3125 2026-10-17 00:00:00.0 0.6123 559
140 968.6155 2026-10-18 00:00:00.0 4.3030 559
141 970.9783 2026-10-19 00:00:00.0 2.3628 559
142 973.2223 2026-10-20 00:00:00.0 2.2440 559
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '559') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-10-20'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/20/2026 2 973
10/19/2026 2 971
10/18/2026 4 969
10/17/2026 1 964
10/16/2026 0 964
10/15/2026 1 963
10/14/2026 0 962
10/13/2026 0 962
10/12/2026 1 962
10/11/2026 8 961
10/10/2026 5 953
10/9/2026 2 948
10/8/2026 4 946
10/7/2026 5 942
10/6/2026 4 937
10/5/2026 3 933
10/4/2026 5 930
10/3/2026 3 925
10/2/2026 2 922
10/1/2026 4 920
9/30/2026 8 915
9/29/2026 5 908
9/28/2026 5 903
9/27/2026 8 898
9/26/2026 8 890
9/25/2026 9 882
9/24/2026 6 873
9/23/2026 5 867
9/22/2026 5 862
9/21/2026 4 857
9/20/2026 8 854
9/19/2026 7 846
9/18/2026 4 839
9/17/2026 3 835
9/16/2026 3 833
9/15/2026 4 829
9/14/2026 3 825
9/13/2026 4 822
9/12/2026 8 818
9/11/2026 7 811
9/10/2026 8 803
9/9/2026 9 795
9/8/2026 10 786
9/7/2026 9 776
9/6/2026 9 767
9/5/2026 8 759
9/4/2026 8 750
9/3/2026 8 743
9/2/2026 9 735
9/1/2026 9 726
8/31/2026 8 717
8/30/2026 8 709
8/29/2026 8 700
8/28/2026 6 692
8/27/2026 8 686
8/26/2026 9 678
8/25/2026 8 669
8/24/2026 8 660
8/23/2026 6 653
8/22/2026 8 646
8/21/2026 7 638
8/20/2026 6 631
8/19/2026 6 625
8/18/2026 7 619
8/17/2026 8 611
8/16/2026 9 604
8/15/2026 9 595
8/14/2026 8 586
8/13/2026 9 578
8/12/2026 7 569
8/11/2026 9 562
8/10/2026 6 553
8/9/2026 7 547
8/8/2026 7 540
8/7/2026 8 533
8/6/2026 7 525
8/5/2026 7 518
8/4/2026 9 511
8/3/2026 7 502
8/2/2026 9 495
8/1/2026 8 486
7/31/2026 9 478
7/30/2026 7 470
7/29/2026 8 463
7/28/2026 8 455
7/27/2026 8 447
7/26/2026 8 439
7/25/2026 8 431
7/24/2026 9 423
7/23/2026 8 414
7/22/2026 9 406
7/21/2026 9 397
7/20/2026 7 388
7/19/2026 8 381
7/18/2026 9 373
7/17/2026 9 364
7/16/2026 10 355
7/15/2026 9 346
7/14/2026 5 336
7/13/2026 4 332
7/12/2026 7 327
7/11/2026 8 321
7/10/2026 9 312
7/9/2026 9 303
7/8/2026 8 294
7/7/2026 9 286
7/6/2026 7 277
7/5/2026 8 270
7/4/2026 8 262
7/3/2026 9 254
7/2/2026 9 245
7/1/2026 9 236
6/30/2026 9 227
6/29/2026 9 217
6/28/2026 9 208
6/27/2026 8 199
6/26/2026 7 190
6/25/2026 9 184
6/24/2026 8 175
6/23/2026 7 167
6/22/2026 6 159
6/21/2026 6 154
6/20/2026 8 148
6/19/2026 7 140
6/18/2026 5 133
6/17/2026 6 128
6/16/2026 6 122
6/15/2026 6 115
6/14/2026 6 110
6/13/2026 7 103
6/12/2026 9 96
6/11/2026 9 87
6/10/2026 7 78
6/9/2026 9 71
6/8/2026 5 63
6/7/2026 7 58
6/6/2026 8 51
6/5/2026 9 42
6/4/2026 9 34
6/3/2026 8 25
6/2/2026 9 17
6/1/2026 8 8