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 3.9647 2022-06-06 00:00:00.0 3.9647 314
2 9.6228 2022-06-07 00:00:00.0 5.6581 314
3 15.2738 2022-06-08 00:00:00.0 5.6510 314
4 21.1158 2022-06-09 00:00:00.0 5.8420 314
5 29.9971 2022-06-10 00:00:00.0 8.8813 314
6 38.6551 2022-06-11 00:00:00.0 8.6580 314
7 47.8046 2022-06-12 00:00:00.0 9.1495 314
8 55.8483 2022-06-13 00:00:00.0 8.0437 314
9 64.4417 2022-06-14 00:00:00.0 8.5934 314
10 71.1268 2022-06-15 00:00:00.0 6.6851 314
11 78.8017 2022-06-16 00:00:00.0 7.6749 314
12 87.1619 2022-06-17 00:00:00.0 8.3602 314
13 95.1018 2022-06-18 00:00:00.0 7.9399 314
14 99.7201 2022-06-19 00:00:00.0 4.6183 314
15 109.1916 2022-06-20 00:00:00.0 9.4715 314
16 117.6723 2022-06-21 00:00:00.0 8.4807 314
17 125.7351 2022-06-22 00:00:00.0 8.0628 314
18 133.3552 2022-06-23 00:00:00.0 7.6201 314
19 142.6601 2022-06-24 00:00:00.0 9.3049 314
20 149.2390 2022-06-25 00:00:00.0 6.5789 314
21 156.7885 2022-06-26 00:00:00.0 7.5495 314
22 165.0365 2022-06-27 00:00:00.0 8.2480 314
23 172.8524 2022-06-28 00:00:00.0 7.8159 314
24 180.7748 2022-06-29 00:00:00.0 7.9224 314
25 189.0173 2022-06-30 00:00:00.0 8.2425 314
26 195.5073 2022-07-01 00:00:00.0 6.4900 314
27 202.6340 2022-07-02 00:00:00.0 7.1267 314
28 211.1643 2022-07-03 00:00:00.0 8.5303 314
29 220.1290 2022-07-04 00:00:00.0 8.9647 314
30 229.2099 2022-07-05 00:00:00.0 9.0809 314
31 238.2774 2022-07-06 00:00:00.0 9.0675 314
32 246.6521 2022-07-07 00:00:00.0 8.3747 314
33 254.4216 2022-07-08 00:00:00.0 7.7695 314
34 263.0983 2022-07-09 00:00:00.0 8.6767 314
35 272.3292 2022-07-10 00:00:00.0 9.2309 314
36 281.7175 2022-07-11 00:00:00.0 9.3883 314
37 290.6860 2022-07-12 00:00:00.0 8.9685 314
38 298.8318 2022-07-13 00:00:00.0 8.1458 314
39 308.3244 2022-07-14 00:00:00.0 9.4926 314
40 316.3672 2022-07-15 00:00:00.0 8.0428 314
41 324.9418 2022-07-16 00:00:00.0 8.5746 314
42 331.8208 2022-07-17 00:00:00.0 6.8790 314
43 340.9018 2022-07-18 00:00:00.0 9.0810 314
44 350.5478 2022-07-19 00:00:00.0 9.6460 314
45 359.7863 2022-07-20 00:00:00.0 9.2385 314
46 368.4653 2022-07-21 00:00:00.0 8.6790 314
47 377.2507 2022-07-22 00:00:00.0 8.7854 314
48 385.3404 2022-07-23 00:00:00.0 8.0897 314
49 392.8942 2022-07-24 00:00:00.0 7.5538 314
50 400.3337 2022-07-25 00:00:00.0 7.4395 314
51 408.7168 2022-07-26 00:00:00.0 8.3831 314
52 415.9723 2022-07-27 00:00:00.0 7.2555 314
53 423.1817 2022-07-28 00:00:00.0 7.2094 314
54 430.8238 2022-07-29 00:00:00.0 7.6421 314
55 438.1137 2022-07-30 00:00:00.0 7.2899 314
56 446.4889 2022-07-31 00:00:00.0 8.3752 314
57 454.2421 2022-08-01 00:00:00.0 7.7532 314
58 462.4629 2022-08-02 00:00:00.0 8.2208 314
59 470.9375 2022-08-03 00:00:00.0 8.4746 314
60 478.7220 2022-08-04 00:00:00.0 7.7845 314
61 487.7927 2022-08-05 00:00:00.0 9.0707 314
62 494.7475 2022-08-06 00:00:00.0 6.9548 314
63 500.7222 2022-08-07 00:00:00.0 5.9747 314
64 508.3576 2022-08-08 00:00:00.0 7.6354 314
65 517.2439 2022-08-09 00:00:00.0 8.8863 314
66 524.5751 2022-08-10 00:00:00.0 7.3312 314
67 530.5488 2022-08-11 00:00:00.0 5.9737 314
68 539.5842 2022-08-12 00:00:00.0 9.0354 314
69 547.7844 2022-08-13 00:00:00.0 8.2002 314
70 556.1705 2022-08-14 00:00:00.0 8.3861 314
71 565.6685 2022-08-15 00:00:00.0 9.4980 314
72 573.5882 2022-08-16 00:00:00.0 7.9197 314
73 582.0530 2022-08-17 00:00:00.0 8.4648 314
74 591.4519 2022-08-18 00:00:00.0 9.3989 314
75 600.2824 2022-08-19 00:00:00.0 8.8305 314
76 607.2723 2022-08-20 00:00:00.0 6.9899 314
77 614.5672 2022-08-21 00:00:00.0 7.2949 314
78 623.1884 2022-08-22 00:00:00.0 8.6212 314
79 632.3716 2022-08-23 00:00:00.0 9.1832 314
80 639.2546 2022-08-24 00:00:00.0 6.8830 314
81 645.3049 2022-08-25 00:00:00.0 6.0503 314
82 653.8797 2022-08-26 00:00:00.0 8.5748 314
83 661.5982 2022-08-27 00:00:00.0 7.7185 314
84 670.6398 2022-08-28 00:00:00.0 9.0416 314
85 678.7793 2022-08-29 00:00:00.0 8.1395 314
86 686.1248 2022-08-30 00:00:00.0 7.3455 314
87 692.9937 2022-08-31 00:00:00.0 6.8689 314
88 700.0405 2022-09-01 00:00:00.0 7.0468 314
89 707.3188 2022-09-02 00:00:00.0 7.2783 314
90 713.2575 2022-09-03 00:00:00.0 5.9387 314
91 721.4475 2022-09-04 00:00:00.0 8.1900 314
92 729.7611 2022-09-05 00:00:00.0 8.3136 314
93 736.9300 2022-09-06 00:00:00.0 7.1689 314
94 742.9516 2022-09-07 00:00:00.0 6.0216 314
95 750.0181 2022-09-08 00:00:00.0 7.0665 314
96 754.5495 2022-09-09 00:00:00.0 4.5314 314
97 758.7821 2022-09-10 00:00:00.0 4.2326 314
98 764.4507 2022-09-11 00:00:00.0 5.6686 314
99 770.4447 2022-09-12 00:00:00.0 5.9940 314
100 774.2717 2022-09-13 00:00:00.0 3.8270 314
101 779.3695 2022-09-14 00:00:00.0 5.0978 314
102 786.1008 2022-09-15 00:00:00.0 6.7313 314
103 790.9272 2022-09-16 00:00:00.0 4.8264 314
104 797.0329 2022-09-17 00:00:00.0 6.1057 314
105 803.3968 2022-09-18 00:00:00.0 6.3639 314
106 807.7086 2022-09-19 00:00:00.0 4.3118 314
107 813.0667 2022-09-20 00:00:00.0 5.3581 314
108 815.3884 2022-09-21 00:00:00.0 2.3217 314
109 817.5856 2022-09-22 00:00:00.0 2.1972 314
110 821.8759 2022-09-23 00:00:00.0 4.2903 314
111 829.0440 2022-09-24 00:00:00.0 7.1681 314
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '314') 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 7 829
9/23/2022 4 822
9/22/2022 2 818
9/21/2022 2 815
9/20/2022 5 813
9/19/2022 4 808
9/18/2022 6 803
9/17/2022 6 797
9/16/2022 5 791
9/15/2022 7 786
9/14/2022 5 779
9/13/2022 4 774
9/12/2022 6 770
9/11/2022 6 764
9/10/2022 4 759
9/9/2022 5 755
9/8/2022 7 750
9/7/2022 6 743
9/6/2022 7 737
9/5/2022 8 730
9/4/2022 8 721
9/3/2022 6 713
9/2/2022 7 707
9/1/2022 7 700
8/31/2022 7 693
8/30/2022 7 686
8/29/2022 8 679
8/28/2022 9 671
8/27/2022 8 662
8/26/2022 9 654
8/25/2022 6 645
8/24/2022 7 639
8/23/2022 9 632
8/22/2022 9 623
8/21/2022 7 615
8/20/2022 7 607
8/19/2022 9 600
8/18/2022 9 591
8/17/2022 8 582
8/16/2022 8 574
8/15/2022 9 566
8/14/2022 8 556
8/13/2022 8 548
8/12/2022 9 540
8/11/2022 6 531
8/10/2022 7 525
8/9/2022 9 517
8/8/2022 8 508
8/7/2022 6 501
8/6/2022 7 495
8/5/2022 9 488
8/4/2022 8 479
8/3/2022 8 471
8/2/2022 8 462
8/1/2022 8 454
7/31/2022 8 446
7/30/2022 7 438
7/29/2022 8 431
7/28/2022 7 423
7/27/2022 7 416
7/26/2022 8 409
7/25/2022 7 400
7/24/2022 8 393
7/23/2022 8 385
7/22/2022 9 377
7/21/2022 9 368
7/20/2022 9 360
7/19/2022 10 351
7/18/2022 9 341
7/17/2022 7 332
7/16/2022 9 325
7/15/2022 8 316
7/14/2022 9 308
7/13/2022 8 299
7/12/2022 9 291
7/11/2022 9 282
7/10/2022 9 272
7/9/2022 9 263
7/8/2022 8 254
7/7/2022 8 247
7/6/2022 9 238
7/5/2022 9 229
7/4/2022 9 220
7/3/2022 9 211
7/2/2022 7 203
7/1/2022 6 196
6/30/2022 8 189
6/29/2022 8 181
6/28/2022 8 173
6/27/2022 8 165
6/26/2022 8 157
6/25/2022 7 149
6/24/2022 9 143
6/23/2022 8 133
6/22/2022 8 126
6/21/2022 8 118
6/20/2022 9 109
6/19/2022 5 100
6/18/2022 8 95
6/17/2022 8 87
6/16/2022 8 79
6/15/2022 7 71
6/14/2022 9 64
6/13/2022 8 56
6/12/2022 9 48
6/11/2022 9 39
6/10/2022 9 30
6/9/2022 6 21
6/8/2022 6 15
6/7/2022 6 10