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.8631 2022-06-06 00:00:00.0 5.8631 202
2 11.7619 2022-06-07 00:00:00.0 5.8988 202
3 17.9297 2022-06-08 00:00:00.0 6.1678 202
4 24.3424 2022-06-09 00:00:00.0 6.4127 202
5 32.6144 2022-06-10 00:00:00.0 8.2720 202
6 41.4166 2022-06-11 00:00:00.0 8.8022 202
7 50.3936 2022-06-12 00:00:00.0 8.9770 202
8 58.9366 2022-06-13 00:00:00.0 8.5430 202
9 68.1384 2022-06-14 00:00:00.0 9.2018 202
10 76.6514 2022-06-15 00:00:00.0 8.5130 202
11 85.1710 2022-06-16 00:00:00.0 8.5196 202
12 93.5549 2022-06-17 00:00:00.0 8.3839 202
13 101.4522 2022-06-18 00:00:00.0 7.8973 202
14 105.3810 2022-06-19 00:00:00.0 3.9288 202
15 112.8044 2022-06-20 00:00:00.0 7.4234 202
16 121.3203 2022-06-21 00:00:00.0 8.5159 202
17 128.4658 2022-06-22 00:00:00.0 7.1455 202
18 135.6176 2022-06-23 00:00:00.0 7.1518 202
19 144.1369 2022-06-24 00:00:00.0 8.5193 202
20 151.9111 2022-06-25 00:00:00.0 7.7742 202
21 160.0579 2022-06-26 00:00:00.0 8.1468 202
22 167.8290 2022-06-27 00:00:00.0 7.7711 202
23 175.6759 2022-06-28 00:00:00.0 7.8469 202
24 182.9385 2022-06-29 00:00:00.0 7.2626 202
25 190.6759 2022-06-30 00:00:00.0 7.7374 202
26 196.9092 2022-07-01 00:00:00.0 6.2333 202
27 204.9874 2022-07-02 00:00:00.0 8.0782 202
28 213.5235 2022-07-03 00:00:00.0 8.5361 202
29 222.9495 2022-07-04 00:00:00.0 9.4260 202
30 232.2830 2022-07-05 00:00:00.0 9.3335 202
31 241.3708 2022-07-06 00:00:00.0 9.0878 202
32 250.6183 2022-07-07 00:00:00.0 9.2475 202
33 259.3049 2022-07-08 00:00:00.0 8.6866 202
34 267.3195 2022-07-09 00:00:00.0 8.0146 202
35 276.4267 2022-07-10 00:00:00.0 9.1072 202
36 285.7907 2022-07-11 00:00:00.0 9.3640 202
37 294.7854 2022-07-12 00:00:00.0 8.9947 202
38 303.2659 2022-07-13 00:00:00.0 8.4805 202
39 312.8004 2022-07-14 00:00:00.0 9.5345 202
40 320.7120 2022-07-15 00:00:00.0 7.9116 202
41 329.8435 2022-07-16 00:00:00.0 9.1315 202
42 336.0579 2022-07-17 00:00:00.0 6.2144 202
43 343.5312 2022-07-18 00:00:00.0 7.4733 202
44 353.1203 2022-07-19 00:00:00.0 9.5891 202
45 361.9828 2022-07-20 00:00:00.0 8.8625 202
46 370.8077 2022-07-21 00:00:00.0 8.8249 202
47 379.9740 2022-07-22 00:00:00.0 9.1663 202
48 389.2172 2022-07-23 00:00:00.0 9.2432 202
49 397.1786 2022-07-24 00:00:00.0 7.9614 202
50 404.2642 2022-07-25 00:00:00.0 7.0856 202
51 413.0481 2022-07-26 00:00:00.0 8.7839 202
52 421.3345 2022-07-27 00:00:00.0 8.2864 202
53 429.9106 2022-07-28 00:00:00.0 8.5761 202
54 437.5730 2022-07-29 00:00:00.0 7.6624 202
55 445.3893 2022-07-30 00:00:00.0 7.8163 202
56 453.8825 2022-07-31 00:00:00.0 8.4932 202
57 461.9409 2022-08-01 00:00:00.0 8.0584 202
58 470.1482 2022-08-02 00:00:00.0 8.2073 202
59 479.0424 2022-08-03 00:00:00.0 8.8942 202
60 487.1623 2022-08-04 00:00:00.0 8.1199 202
61 495.8119 2022-08-05 00:00:00.0 8.6496 202
62 503.5018 2022-08-06 00:00:00.0 7.6899 202
63 509.2982 2022-08-07 00:00:00.0 5.7964 202
64 516.9554 2022-08-08 00:00:00.0 7.6572 202
65 526.0369 2022-08-09 00:00:00.0 9.0815 202
66 533.6572 2022-08-10 00:00:00.0 7.6203 202
67 539.8564 2022-08-11 00:00:00.0 6.1992 202
68 548.9122 2022-08-12 00:00:00.0 9.0558 202
69 556.7517 2022-08-13 00:00:00.0 7.8395 202
70 564.5636 2022-08-14 00:00:00.0 7.8119 202
71 573.7827 2022-08-15 00:00:00.0 9.2191 202
72 582.2484 2022-08-16 00:00:00.0 8.4657 202
73 590.0979 2022-08-17 00:00:00.0 7.8495 202
74 599.8916 2022-08-18 00:00:00.0 9.7937 202
75 609.0017 2022-08-19 00:00:00.0 9.1101 202
76 616.6535 2022-08-20 00:00:00.0 7.6518 202
77 624.0035 2022-08-21 00:00:00.0 7.3500 202
78 632.1186 2022-08-22 00:00:00.0 8.1151 202
79 641.2198 2022-08-23 00:00:00.0 9.1012 202
80 649.3659 2022-08-24 00:00:00.0 8.1461 202
81 655.5457 2022-08-25 00:00:00.0 6.1798 202
82 663.1486 2022-08-26 00:00:00.0 7.6029 202
83 671.5230 2022-08-27 00:00:00.0 8.3744 202
84 680.4672 2022-08-28 00:00:00.0 8.9442 202
85 689.1709 2022-08-29 00:00:00.0 8.7037 202
86 696.9754 2022-08-30 00:00:00.0 7.8045 202
87 704.1397 2022-08-31 00:00:00.0 7.1643 202
88 710.8605 2022-09-01 00:00:00.0 6.7208 202
89 718.9608 2022-09-02 00:00:00.0 8.1003 202
90 725.1357 2022-09-03 00:00:00.0 6.1749 202
91 732.8220 2022-09-04 00:00:00.0 7.6863 202
92 741.0829 2022-09-05 00:00:00.0 8.2609 202
93 749.1427 2022-09-06 00:00:00.0 8.0598 202
94 755.2404 2022-09-07 00:00:00.0 6.0977 202
95 763.7234 2022-09-08 00:00:00.0 8.4830 202
96 769.6281 2022-09-09 00:00:00.0 5.9047 202
97 774.5308 2022-09-10 00:00:00.0 4.9027 202
98 780.0766 2022-09-11 00:00:00.0 5.5458 202
99 785.9311 2022-09-12 00:00:00.0 5.8545 202
100 791.0183 2022-09-13 00:00:00.0 5.0872 202
101 797.4129 2022-09-14 00:00:00.0 6.3946 202
102 804.9297 2022-09-15 00:00:00.0 7.5168 202
103 811.0121 2022-09-16 00:00:00.0 6.0824 202
104 818.4061 2022-09-17 00:00:00.0 7.3940 202
105 825.8865 2022-09-18 00:00:00.0 7.4804 202
106 832.0794 2022-09-19 00:00:00.0 6.1929 202
107 839.5964 2022-09-20 00:00:00.0 7.5170 202
108 843.5876 2022-09-21 00:00:00.0 3.9912 202
109 846.1708 2022-09-22 00:00:00.0 2.5832 202
110 849.8654 2022-09-23 00:00:00.0 3.6946 202
111 857.1542 2022-09-24 00:00:00.0 7.2888 202
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '202') 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 857
9/23/2022 4 850
9/22/2022 3 846
9/21/2022 4 844
9/20/2022 8 840
9/19/2022 6 832
9/18/2022 7 826
9/17/2022 7 818
9/16/2022 6 811
9/15/2022 8 805
9/14/2022 6 797
9/13/2022 5 791
9/12/2022 6 786
9/11/2022 6 780
9/10/2022 5 775
9/9/2022 6 770
9/8/2022 8 764
9/7/2022 6 755
9/6/2022 8 749
9/5/2022 8 741
9/4/2022 8 733
9/3/2022 6 725
9/2/2022 8 719
9/1/2022 7 711
8/31/2022 7 704
8/30/2022 8 697
8/29/2022 9 689
8/28/2022 9 680
8/27/2022 8 672
8/26/2022 8 663
8/25/2022 6 656
8/24/2022 8 649
8/23/2022 9 641
8/22/2022 8 632
8/21/2022 7 624
8/20/2022 8 617
8/19/2022 9 609
8/18/2022 10 600
8/17/2022 8 590
8/16/2022 8 582
8/15/2022 9 574
8/14/2022 8 565
8/13/2022 8 557
8/12/2022 9 549
8/11/2022 6 540
8/10/2022 8 534
8/9/2022 9 526
8/8/2022 8 517
8/7/2022 6 509
8/6/2022 8 504
8/5/2022 9 496
8/4/2022 8 487
8/3/2022 9 479
8/2/2022 8 470
8/1/2022 8 462
7/31/2022 8 454
7/30/2022 8 445
7/29/2022 8 438
7/28/2022 9 430
7/27/2022 8 421
7/26/2022 9 413
7/25/2022 7 404
7/24/2022 8 397
7/23/2022 9 389
7/22/2022 9 380
7/21/2022 9 371
7/20/2022 9 362
7/19/2022 10 353
7/18/2022 7 344
7/17/2022 6 336
7/16/2022 9 330
7/15/2022 8 321
7/14/2022 10 313
7/13/2022 8 303
7/12/2022 9 295
7/11/2022 9 286
7/10/2022 9 276
7/9/2022 8 267
7/8/2022 9 259
7/7/2022 9 251
7/6/2022 9 241
7/5/2022 9 232
7/4/2022 9 223
7/3/2022 9 214
7/2/2022 8 205
7/1/2022 6 197
6/30/2022 8 191
6/29/2022 7 183
6/28/2022 8 176
6/27/2022 8 168
6/26/2022 8 160
6/25/2022 8 152
6/24/2022 9 144
6/23/2022 7 136
6/22/2022 7 128
6/21/2022 9 121
6/20/2022 7 113
6/19/2022 4 105
6/18/2022 8 101
6/17/2022 8 94
6/16/2022 9 85
6/15/2022 9 77
6/14/2022 9 68
6/13/2022 9 59
6/12/2022 9 50
6/11/2022 9 41
6/10/2022 8 33
6/9/2022 6 24
6/8/2022 6 18
6/7/2022 6 12