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.1387 2022-06-06 00:00:00.0 7.1387 243
2 13.4661 2022-06-07 00:00:00.0 6.3274 243
3 20.4420 2022-06-08 00:00:00.0 6.9759 243
4 26.8691 2022-06-09 00:00:00.0 6.4271 243
5 35.6217 2022-06-10 00:00:00.0 8.7526 243
6 44.4503 2022-06-11 00:00:00.0 8.8286 243
7 53.6034 2022-06-12 00:00:00.0 9.1531 243
8 61.9002 2022-06-13 00:00:00.0 8.2968 243
9 71.0285 2022-06-14 00:00:00.0 9.1283 243
10 79.9125 2022-06-15 00:00:00.0 8.8840 243
11 88.4886 2022-06-16 00:00:00.0 8.5761 243
12 97.4450 2022-06-17 00:00:00.0 8.9564 243
13 105.7286 2022-06-18 00:00:00.0 8.2836 243
14 109.3156 2022-06-19 00:00:00.0 3.5870 243
15 115.6253 2022-06-20 00:00:00.0 6.3097 243
16 124.0608 2022-06-21 00:00:00.0 8.4355 243
17 130.9307 2022-06-22 00:00:00.0 6.8699 243
18 137.2763 2022-06-23 00:00:00.0 6.3456 243
19 145.9279 2022-06-24 00:00:00.0 8.6516 243
20 154.0210 2022-06-25 00:00:00.0 8.0931 243
21 161.8679 2022-06-26 00:00:00.0 7.8469 243
22 169.4659 2022-06-27 00:00:00.0 7.5980 243
23 178.1756 2022-06-28 00:00:00.0 8.7097 243
24 186.5332 2022-06-29 00:00:00.0 8.3576 243
25 195.5726 2022-06-30 00:00:00.0 9.0394 243
26 202.2338 2022-07-01 00:00:00.0 6.6612 243
27 210.6095 2022-07-02 00:00:00.0 8.3757 243
28 218.8428 2022-07-03 00:00:00.0 8.2333 243
29 228.4681 2022-07-04 00:00:00.0 9.6253 243
30 237.8489 2022-07-05 00:00:00.0 9.3808 243
31 246.6775 2022-07-06 00:00:00.0 8.8286 243
32 256.0851 2022-07-07 00:00:00.0 9.4076 243
33 264.5812 2022-07-08 00:00:00.0 8.4961 243
34 272.1485 2022-07-09 00:00:00.0 7.5673 243
35 281.1709 2022-07-10 00:00:00.0 9.0224 243
36 290.5605 2022-07-11 00:00:00.0 9.3896 243
37 299.7910 2022-07-12 00:00:00.0 9.2305 243
38 308.1540 2022-07-13 00:00:00.0 8.3630 243
39 317.7979 2022-07-14 00:00:00.0 9.6439 243
40 325.6218 2022-07-15 00:00:00.0 7.8239 243
41 334.1694 2022-07-16 00:00:00.0 8.5476 243
42 340.3880 2022-07-17 00:00:00.0 6.2186 243
43 347.7324 2022-07-18 00:00:00.0 7.3444 243
44 357.3001 2022-07-19 00:00:00.0 9.5677 243
45 366.1960 2022-07-20 00:00:00.0 8.8959 243
46 374.9088 2022-07-21 00:00:00.0 8.7128 243
47 384.0002 2022-07-22 00:00:00.0 9.0914 243
48 393.1276 2022-07-23 00:00:00.0 9.1274 243
49 400.8629 2022-07-24 00:00:00.0 7.7353 243
50 408.0783 2022-07-25 00:00:00.0 7.2154 243
51 417.2722 2022-07-26 00:00:00.0 9.1939 243
52 425.4066 2022-07-27 00:00:00.0 8.1344 243
53 433.7951 2022-07-28 00:00:00.0 8.3885 243
54 441.5014 2022-07-29 00:00:00.0 7.7063 243
55 449.6048 2022-07-30 00:00:00.0 8.1034 243
56 458.1326 2022-07-31 00:00:00.0 8.5278 243
57 465.9835 2022-08-01 00:00:00.0 7.8509 243
58 474.7857 2022-08-02 00:00:00.0 8.8022 243
59 483.5234 2022-08-03 00:00:00.0 8.7377 243
60 491.8252 2022-08-04 00:00:00.0 8.3018 243
61 500.6979 2022-08-05 00:00:00.0 8.8727 243
62 508.2798 2022-08-06 00:00:00.0 7.5819 243
63 514.6001 2022-08-07 00:00:00.0 6.3203 243
64 522.5432 2022-08-08 00:00:00.0 7.9431 243
65 531.6454 2022-08-09 00:00:00.0 9.1022 243
66 539.7214 2022-08-10 00:00:00.0 8.0760 243
67 547.1173 2022-08-11 00:00:00.0 7.3959 243
68 556.3230 2022-08-12 00:00:00.0 9.2057 243
69 564.8931 2022-08-13 00:00:00.0 8.5701 243
70 573.2041 2022-08-14 00:00:00.0 8.3110 243
71 582.4611 2022-08-15 00:00:00.0 9.2570 243
72 590.7238 2022-08-16 00:00:00.0 8.2627 243
73 598.9583 2022-08-17 00:00:00.0 8.2345 243
74 608.6402 2022-08-18 00:00:00.0 9.6819 243
75 618.1477 2022-08-19 00:00:00.0 9.5075 243
76 626.6125 2022-08-20 00:00:00.0 8.4648 243
77 634.5011 2022-08-21 00:00:00.0 7.8886 243
78 642.7488 2022-08-22 00:00:00.0 8.2477 243
79 652.0812 2022-08-23 00:00:00.0 9.3324 243
80 660.8191 2022-08-24 00:00:00.0 8.7379 243
81 667.5994 2022-08-25 00:00:00.0 6.7803 243
82 675.8364 2022-08-26 00:00:00.0 8.2370 243
83 684.9110 2022-08-27 00:00:00.0 9.0746 243
84 693.8653 2022-08-28 00:00:00.0 8.9543 243
85 702.3248 2022-08-29 00:00:00.0 8.4595 243
86 709.6202 2022-08-30 00:00:00.0 7.2954 243
87 717.2489 2022-08-31 00:00:00.0 7.6287 243
88 724.6474 2022-09-01 00:00:00.0 7.3985 243
89 733.1732 2022-09-02 00:00:00.0 8.5258 243
90 739.1845 2022-09-03 00:00:00.0 6.0113 243
91 747.2606 2022-09-04 00:00:00.0 8.0761 243
92 755.7984 2022-09-05 00:00:00.0 8.5378 243
93 763.7200 2022-09-06 00:00:00.0 7.9216 243
94 770.0019 2022-09-07 00:00:00.0 6.2819 243
95 777.6137 2022-09-08 00:00:00.0 7.6118 243
96 783.7000 2022-09-09 00:00:00.0 6.0863 243
97 787.8974 2022-09-10 00:00:00.0 4.1974 243
98 793.9730 2022-09-11 00:00:00.0 6.0756 243
99 800.3210 2022-09-12 00:00:00.0 6.3480 243
100 806.3237 2022-09-13 00:00:00.0 6.0027 243
101 812.4217 2022-09-14 00:00:00.0 6.0980 243
102 819.4739 2022-09-15 00:00:00.0 7.0522 243
103 825.3073 2022-09-16 00:00:00.0 5.8334 243
104 832.6713 2022-09-17 00:00:00.0 7.3640 243
105 840.4443 2022-09-18 00:00:00.0 7.7730 243
106 847.6609 2022-09-19 00:00:00.0 7.2166 243
107 855.0386 2022-09-20 00:00:00.0 7.3777 243
108 858.7821 2022-09-21 00:00:00.0 3.7435 243
109 861.2878 2022-09-22 00:00:00.0 2.5057 243
110 864.6094 2022-09-23 00:00:00.0 3.3216 243
111 870.4524 2022-09-24 00:00:00.0 5.8430 243
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '243') AND ddate BETWEEN {d '2022-06-06'} AND {d '2022-09-24'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/24/2022 6 870
9/23/2022 3 865
9/22/2022 3 861
9/21/2022 4 859
9/20/2022 7 855
9/19/2022 7 848
9/18/2022 8 840
9/17/2022 7 833
9/16/2022 6 825
9/15/2022 7 819
9/14/2022 6 812
9/13/2022 6 806
9/12/2022 6 800
9/11/2022 6 794
9/10/2022 4 788
9/9/2022 6 784
9/8/2022 8 778
9/7/2022 6 770
9/6/2022 8 764
9/5/2022 9 756
9/4/2022 8 747
9/3/2022 6 739
9/2/2022 9 733
9/1/2022 7 725
8/31/2022 8 717
8/30/2022 7 710
8/29/2022 8 702
8/28/2022 9 694
8/27/2022 9 685
8/26/2022 8 676
8/25/2022 7 668
8/24/2022 9 661
8/23/2022 9 652
8/22/2022 8 643
8/21/2022 8 635
8/20/2022 8 627
8/19/2022 10 618
8/18/2022 10 609
8/17/2022 8 599
8/16/2022 8 591
8/15/2022 9 582
8/14/2022 8 573
8/13/2022 9 565
8/12/2022 9 556
8/11/2022 7 547
8/10/2022 8 540
8/9/2022 9 532
8/8/2022 8 523
8/7/2022 6 515
8/6/2022 8 508
8/5/2022 9 501
8/4/2022 8 492
8/3/2022 9 484
8/2/2022 9 475
8/1/2022 8 466
7/31/2022 9 458
7/30/2022 8 450
7/29/2022 8 442
7/28/2022 8 434
7/27/2022 8 425
7/26/2022 9 417
7/25/2022 7 408
7/24/2022 8 401
7/23/2022 9 393
7/22/2022 9 384
7/21/2022 9 375
7/20/2022 9 366
7/19/2022 10 357
7/18/2022 7 348
7/17/2022 6 340
7/16/2022 9 334
7/15/2022 8 326
7/14/2022 10 318
7/13/2022 8 308
7/12/2022 9 300
7/11/2022 9 291
7/10/2022 9 281
7/9/2022 8 272
7/8/2022 8 265
7/7/2022 9 256
7/6/2022 9 247
7/5/2022 9 238
7/4/2022 10 228
7/3/2022 8 219
7/2/2022 8 211
7/1/2022 7 202
6/30/2022 9 196
6/29/2022 8 187
6/28/2022 9 178
6/27/2022 8 169
6/26/2022 8 162
6/25/2022 8 154
6/24/2022 9 146
6/23/2022 6 137
6/22/2022 7 131
6/21/2022 8 124
6/20/2022 6 116
6/19/2022 4 109
6/18/2022 8 106
6/17/2022 9 97
6/16/2022 9 88
6/15/2022 9 80
6/14/2022 9 71
6/13/2022 8 62
6/12/2022 9 54
6/11/2022 9 44
6/10/2022 9 36
6/9/2022 6 27
6/8/2022 7 20
6/7/2022 6 13