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 5.6990 2022-06-06 00:00:00.0 5.6990 223
2 12.3115 2022-06-07 00:00:00.0 6.6125 223
3 19.0805 2022-06-08 00:00:00.0 6.7690 223
4 25.2603 2022-06-09 00:00:00.0 6.1798 223
5 33.8541 2022-06-10 00:00:00.0 8.5938 223
6 43.0598 2022-06-11 00:00:00.0 9.2057 223
7 52.1872 2022-06-12 00:00:00.0 9.1274 223
8 60.5701 2022-06-13 00:00:00.0 8.3829 223
9 69.9854 2022-06-14 00:00:00.0 9.4153 223
10 79.0041 2022-06-15 00:00:00.0 9.0187 223
11 87.6895 2022-06-16 00:00:00.0 8.6854 223
12 96.1403 2022-06-17 00:00:00.0 8.4508 223
13 104.7780 2022-06-18 00:00:00.0 8.6377 223
14 108.9255 2022-06-19 00:00:00.0 4.1475 223
15 114.1817 2022-06-20 00:00:00.0 5.2562 223
16 122.9265 2022-06-21 00:00:00.0 8.7448 223
17 130.4459 2022-06-22 00:00:00.0 7.5194 223
18 136.3861 2022-06-23 00:00:00.0 5.9402 223
19 145.4266 2022-06-24 00:00:00.0 9.0405 223
20 153.8071 2022-06-25 00:00:00.0 8.3805 223
21 161.6858 2022-06-26 00:00:00.0 7.8787 223
22 169.8634 2022-06-27 00:00:00.0 8.1776 223
23 177.8295 2022-06-28 00:00:00.0 7.9661 223
24 185.2912 2022-06-29 00:00:00.0 7.4617 223
25 194.0200 2022-06-30 00:00:00.0 8.7288 223
26 200.8715 2022-07-01 00:00:00.0 6.8515 223
27 208.6983 2022-07-02 00:00:00.0 7.8268 223
28 217.3540 2022-07-03 00:00:00.0 8.6557 223
29 227.1308 2022-07-04 00:00:00.0 9.7768 223
30 236.2971 2022-07-05 00:00:00.0 9.1663 223
31 245.0819 2022-07-06 00:00:00.0 8.7848 223
32 254.3816 2022-07-07 00:00:00.0 9.2997 223
33 262.2485 2022-07-08 00:00:00.0 7.8669 223
34 270.0043 2022-07-09 00:00:00.0 7.7558 223
35 279.1798 2022-07-10 00:00:00.0 9.1755 223
36 288.4552 2022-07-11 00:00:00.0 9.2754 223
37 297.7195 2022-07-12 00:00:00.0 9.2643 223
38 306.0343 2022-07-13 00:00:00.0 8.3148 223
39 315.7064 2022-07-14 00:00:00.0 9.6721 223
40 323.5355 2022-07-15 00:00:00.0 7.8291 223
41 332.1355 2022-07-16 00:00:00.0 8.6000 223
42 338.5901 2022-07-17 00:00:00.0 6.4546 223
43 345.3982 2022-07-18 00:00:00.0 6.8081 223
44 354.7736 2022-07-19 00:00:00.0 9.3754 223
45 363.4987 2022-07-20 00:00:00.0 8.7251 223
46 372.4111 2022-07-21 00:00:00.0 8.9124 223
47 381.6101 2022-07-22 00:00:00.0 9.1990 223
48 390.8898 2022-07-23 00:00:00.0 9.2797 223
49 399.4257 2022-07-24 00:00:00.0 8.5359 223
50 407.9266 2022-07-25 00:00:00.0 8.5009 223
51 417.4208 2022-07-26 00:00:00.0 9.4942 223
52 425.6306 2022-07-27 00:00:00.0 8.2098 223
53 434.0701 2022-07-28 00:00:00.0 8.4395 223
54 441.6881 2022-07-29 00:00:00.0 7.6180 223
55 449.5952 2022-07-30 00:00:00.0 7.9071 223
56 458.4946 2022-07-31 00:00:00.0 8.8994 223
57 466.1312 2022-08-01 00:00:00.0 7.6366 223
58 474.7170 2022-08-02 00:00:00.0 8.5858 223
59 483.3619 2022-08-03 00:00:00.0 8.6449 223
60 491.1301 2022-08-04 00:00:00.0 7.7682 223
61 499.3548 2022-08-05 00:00:00.0 8.2247 223
62 507.7757 2022-08-06 00:00:00.0 8.4209 223
63 514.4063 2022-08-07 00:00:00.0 6.6306 223
64 522.7089 2022-08-08 00:00:00.0 8.3026 223
65 531.9945 2022-08-09 00:00:00.0 9.2856 223
66 540.1650 2022-08-10 00:00:00.0 8.1705 223
67 546.5699 2022-08-11 00:00:00.0 6.4049 223
68 555.5242 2022-08-12 00:00:00.0 8.9543 223
69 563.7232 2022-08-13 00:00:00.0 8.1990 223
70 572.2459 2022-08-14 00:00:00.0 8.5227 223
71 581.1486 2022-08-15 00:00:00.0 8.9027 223
72 590.3471 2022-08-16 00:00:00.0 9.1985 223
73 598.4109 2022-08-17 00:00:00.0 8.0638 223
74 608.0971 2022-08-18 00:00:00.0 9.6862 223
75 617.3734 2022-08-19 00:00:00.0 9.2763 223
76 625.9222 2022-08-20 00:00:00.0 8.5488 223
77 633.1618 2022-08-21 00:00:00.0 7.2396 223
78 641.3939 2022-08-22 00:00:00.0 8.2321 223
79 650.5014 2022-08-23 00:00:00.0 9.1075 223
80 659.3564 2022-08-24 00:00:00.0 8.8550 223
81 666.5304 2022-08-25 00:00:00.0 7.1740 223
82 675.4454 2022-08-26 00:00:00.0 8.9150 223
83 684.3535 2022-08-27 00:00:00.0 8.9081 223
84 693.6123 2022-08-28 00:00:00.0 9.2588 223
85 702.6940 2022-08-29 00:00:00.0 9.0817 223
86 711.1466 2022-08-30 00:00:00.0 8.4526 223
87 718.7263 2022-08-31 00:00:00.0 7.5797 223
88 726.0559 2022-09-01 00:00:00.0 7.3296 223
89 734.0944 2022-09-02 00:00:00.0 8.0385 223
90 739.8074 2022-09-03 00:00:00.0 5.7130 223
91 748.0245 2022-09-04 00:00:00.0 8.2171 223
92 756.6183 2022-09-05 00:00:00.0 8.5938 223
93 764.3139 2022-09-06 00:00:00.0 7.6956 223
94 770.6140 2022-09-07 00:00:00.0 6.3001 223
95 779.6373 2022-09-08 00:00:00.0 9.0233 223
96 786.4957 2022-09-09 00:00:00.0 6.8584 223
97 791.0590 2022-09-10 00:00:00.0 4.5633 223
98 797.0068 2022-09-11 00:00:00.0 5.9478 223
99 804.4120 2022-09-12 00:00:00.0 7.4052 223
100 809.5744 2022-09-13 00:00:00.0 5.1624 223
101 815.7163 2022-09-14 00:00:00.0 6.1419 223
102 823.0617 2022-09-15 00:00:00.0 7.3454 223
103 829.4928 2022-09-16 00:00:00.0 6.4311 223
104 836.9879 2022-09-17 00:00:00.0 7.4951 223
105 845.3235 2022-09-18 00:00:00.0 8.3356 223
106 852.1812 2022-09-19 00:00:00.0 6.8577 223
107 859.9563 2022-09-20 00:00:00.0 7.7751 223
108 863.9824 2022-09-21 00:00:00.0 4.0261 223
109 866.0606 2022-09-22 00:00:00.0 2.0782 223
110 869.3651 2022-09-23 00:00:00.0 3.3045 223
111 874.5581 2022-09-24 00:00:00.0 5.1930 223
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '223') 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 5 875
9/23/2022 3 869
9/22/2022 2 866
9/21/2022 4 864
9/20/2022 8 860
9/19/2022 7 852
9/18/2022 8 845
9/17/2022 7 837
9/16/2022 6 829
9/15/2022 7 823
9/14/2022 6 816
9/13/2022 5 810
9/12/2022 7 804
9/11/2022 6 797
9/10/2022 5 791
9/9/2022 7 786
9/8/2022 9 780
9/7/2022 6 771
9/6/2022 8 764
9/5/2022 9 757
9/4/2022 8 748
9/3/2022 6 740
9/2/2022 8 734
9/1/2022 7 726
8/31/2022 8 719
8/30/2022 8 711
8/29/2022 9 703
8/28/2022 9 694
8/27/2022 9 684
8/26/2022 9 675
8/25/2022 7 667
8/24/2022 9 659
8/23/2022 9 651
8/22/2022 8 641
8/21/2022 7 633
8/20/2022 9 626
8/19/2022 9 617
8/18/2022 10 608
8/17/2022 8 598
8/16/2022 9 590
8/15/2022 9 581
8/14/2022 9 572
8/13/2022 8 564
8/12/2022 9 556
8/11/2022 6 547
8/10/2022 8 540
8/9/2022 9 532
8/8/2022 8 523
8/7/2022 7 514
8/6/2022 8 508
8/5/2022 8 499
8/4/2022 8 491
8/3/2022 9 483
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 426
7/26/2022 9 417
7/25/2022 9 408
7/24/2022 9 399
7/23/2022 9 391
7/22/2022 9 382
7/21/2022 9 372
7/20/2022 9 363
7/19/2022 9 355
7/18/2022 7 345
7/17/2022 6 339
7/16/2022 9 332
7/15/2022 8 324
7/14/2022 10 316
7/13/2022 8 306
7/12/2022 9 298
7/11/2022 9 288
7/10/2022 9 279
7/9/2022 8 270
7/8/2022 8 262
7/7/2022 9 254
7/6/2022 9 245
7/5/2022 9 236
7/4/2022 10 227
7/3/2022 9 217
7/2/2022 8 209
7/1/2022 7 201
6/30/2022 9 194
6/29/2022 7 185
6/28/2022 8 178
6/27/2022 8 170
6/26/2022 8 162
6/25/2022 8 154
6/24/2022 9 145
6/23/2022 6 136
6/22/2022 8 130
6/21/2022 9 123
6/20/2022 5 114
6/19/2022 4 109
6/18/2022 9 105
6/17/2022 8 96
6/16/2022 9 88
6/15/2022 9 79
6/14/2022 9 70
6/13/2022 8 61
6/12/2022 9 52
6/11/2022 9 43
6/10/2022 9 34
6/9/2022 6 25
6/8/2022 7 19
6/7/2022 7 12