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.9628 2022-06-06 00:00:00.0 5.9628 222
2 13.1752 2022-06-07 00:00:00.0 7.2124 222
3 20.0123 2022-06-08 00:00:00.0 6.8371 222
4 27.3570 2022-06-09 00:00:00.0 7.3447 222
5 36.4856 2022-06-10 00:00:00.0 9.1286 222
6 45.6430 2022-06-11 00:00:00.0 9.1574 222
7 55.0029 2022-06-12 00:00:00.0 9.3599 222
8 63.2714 2022-06-13 00:00:00.0 8.2685 222
9 72.6714 2022-06-14 00:00:00.0 9.4000 222
10 81.3249 2022-06-15 00:00:00.0 8.6535 222
11 89.9331 2022-06-16 00:00:00.0 8.6082 222
12 98.3482 2022-06-17 00:00:00.0 8.4151 222
13 106.8079 2022-06-18 00:00:00.0 8.4597 222
14 110.8017 2022-06-19 00:00:00.0 3.9938 222
15 117.5162 2022-06-20 00:00:00.0 6.7145 222
16 126.0903 2022-06-21 00:00:00.0 8.5741 222
17 133.4096 2022-06-22 00:00:00.0 7.3193 222
18 139.5583 2022-06-23 00:00:00.0 6.1487 222
19 147.9567 2022-06-24 00:00:00.0 8.3984 222
20 156.0131 2022-06-25 00:00:00.0 8.0564 222
21 163.8928 2022-06-26 00:00:00.0 7.8797 222
22 171.5642 2022-06-27 00:00:00.0 7.6714 222
23 179.7151 2022-06-28 00:00:00.0 8.1509 222
24 186.4250 2022-06-29 00:00:00.0 6.7099 222
25 194.3388 2022-06-30 00:00:00.0 7.9138 222
26 201.4886 2022-07-01 00:00:00.0 7.1498 222
27 209.0585 2022-07-02 00:00:00.0 7.5699 222
28 217.4742 2022-07-03 00:00:00.0 8.4157 222
29 227.2857 2022-07-04 00:00:00.0 9.8115 222
30 236.4414 2022-07-05 00:00:00.0 9.1557 222
31 244.8870 2022-07-06 00:00:00.0 8.4456 222
32 254.2946 2022-07-07 00:00:00.0 9.4076 222
33 263.0654 2022-07-08 00:00:00.0 8.7708 222
34 270.5456 2022-07-09 00:00:00.0 7.4802 222
35 279.5477 2022-07-10 00:00:00.0 9.0021 222
36 288.8977 2022-07-11 00:00:00.0 9.3500 222
37 298.1364 2022-07-12 00:00:00.0 9.2387 222
38 306.8451 2022-07-13 00:00:00.0 8.7087 222
39 316.2619 2022-07-14 00:00:00.0 9.4168 222
40 324.6929 2022-07-15 00:00:00.0 8.4310 222
41 333.7258 2022-07-16 00:00:00.0 9.0329 222
42 339.9511 2022-07-17 00:00:00.0 6.2253 222
43 346.9955 2022-07-18 00:00:00.0 7.0444 222
44 356.6655 2022-07-19 00:00:00.0 9.6700 222
45 365.7645 2022-07-20 00:00:00.0 9.0990 222
46 374.7478 2022-07-21 00:00:00.0 8.9833 222
47 383.7589 2022-07-22 00:00:00.0 9.0111 222
48 392.7226 2022-07-23 00:00:00.0 8.9637 222
49 401.1332 2022-07-24 00:00:00.0 8.4106 222
50 409.2411 2022-07-25 00:00:00.0 8.1079 222
51 418.4578 2022-07-26 00:00:00.0 9.2167 222
52 426.7908 2022-07-27 00:00:00.0 8.3330 222
53 435.2668 2022-07-28 00:00:00.0 8.4760 222
54 443.4253 2022-07-29 00:00:00.0 8.1585 222
55 450.9296 2022-07-30 00:00:00.0 7.5043 222
56 459.6713 2022-07-31 00:00:00.0 8.7417 222
57 467.7430 2022-08-01 00:00:00.0 8.0717 222
58 476.5095 2022-08-02 00:00:00.0 8.7665 222
59 485.3407 2022-08-03 00:00:00.0 8.8312 222
60 493.1394 2022-08-04 00:00:00.0 7.7987 222
61 501.7094 2022-08-05 00:00:00.0 8.5700 222
62 509.9563 2022-08-06 00:00:00.0 8.2469 222
63 516.5174 2022-08-07 00:00:00.0 6.5611 222
64 523.6662 2022-08-08 00:00:00.0 7.1488 222
65 532.9699 2022-08-09 00:00:00.0 9.3037 222
66 540.7664 2022-08-10 00:00:00.0 7.7965 222
67 547.8529 2022-08-11 00:00:00.0 7.0865 222
68 557.0514 2022-08-12 00:00:00.0 9.1985 222
69 565.2884 2022-08-13 00:00:00.0 8.2370 222
70 573.1814 2022-08-14 00:00:00.0 7.8930 222
71 582.1751 2022-08-15 00:00:00.0 8.9937 222
72 591.0043 2022-08-16 00:00:00.0 8.8292 222
73 599.0082 2022-08-17 00:00:00.0 8.0039 222
74 608.8123 2022-08-18 00:00:00.0 9.8041 222
75 618.0113 2022-08-19 00:00:00.0 9.1990 222
76 626.2132 2022-08-20 00:00:00.0 8.2019 222
77 633.4699 2022-08-21 00:00:00.0 7.2567 222
78 641.5328 2022-08-22 00:00:00.0 8.0629 222
79 650.3499 2022-08-23 00:00:00.0 8.8171 222
80 658.9967 2022-08-24 00:00:00.0 8.6468 222
81 665.5305 2022-08-25 00:00:00.0 6.5338 222
82 674.0932 2022-08-26 00:00:00.0 8.5627 222
83 683.0802 2022-08-27 00:00:00.0 8.9870 222
84 692.1253 2022-08-28 00:00:00.0 9.0451 222
85 700.8322 2022-08-29 00:00:00.0 8.7069 222
86 708.7330 2022-08-30 00:00:00.0 7.9008 222
87 715.9842 2022-08-31 00:00:00.0 7.2512 222
88 723.1447 2022-09-01 00:00:00.0 7.1605 222
89 731.6151 2022-09-02 00:00:00.0 8.4704 222
90 738.2061 2022-09-03 00:00:00.0 6.5910 222
91 745.0021 2022-09-04 00:00:00.0 6.7960 222
92 752.7810 2022-09-05 00:00:00.0 7.7789 222
93 761.5096 2022-09-06 00:00:00.0 8.7286 222
94 767.8134 2022-09-07 00:00:00.0 6.3038 222
95 776.6389 2022-09-08 00:00:00.0 8.8255 222
96 783.5006 2022-09-09 00:00:00.0 6.8617 222
97 788.5202 2022-09-10 00:00:00.0 5.0196 222
98 793.8773 2022-09-11 00:00:00.0 5.3571 222
99 799.7078 2022-09-12 00:00:00.0 5.8305 222
100 804.5111 2022-09-13 00:00:00.0 4.8033 222
101 810.3166 2022-09-14 00:00:00.0 5.8055 222
102 817.9387 2022-09-15 00:00:00.0 7.6221 222
103 824.2107 2022-09-16 00:00:00.0 6.2720 222
104 831.5063 2022-09-17 00:00:00.0 7.2956 222
105 839.3916 2022-09-18 00:00:00.0 7.8853 222
106 846.3413 2022-09-19 00:00:00.0 6.9497 222
107 853.7690 2022-09-20 00:00:00.0 7.4277 222
108 857.9539 2022-09-21 00:00:00.0 4.1849 222
109 860.1507 2022-09-22 00:00:00.0 2.1968 222
110 864.2346 2022-09-23 00:00:00.0 4.0839 222
111 871.1689 2022-09-24 00:00:00.0 6.9343 222
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '222') 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 871
9/23/2022 4 864
9/22/2022 2 860
9/21/2022 4 858
9/20/2022 7 854
9/19/2022 7 846
9/18/2022 8 839
9/17/2022 7 832
9/16/2022 6 824
9/15/2022 8 818
9/14/2022 6 810
9/13/2022 5 805
9/12/2022 6 800
9/11/2022 5 794
9/10/2022 5 789
9/9/2022 7 784
9/8/2022 9 777
9/7/2022 6 768
9/6/2022 9 762
9/5/2022 8 753
9/4/2022 7 745
9/3/2022 7 738
9/2/2022 8 732
9/1/2022 7 723
8/31/2022 7 716
8/30/2022 8 709
8/29/2022 9 701
8/28/2022 9 692
8/27/2022 9 683
8/26/2022 9 674
8/25/2022 7 666
8/24/2022 9 659
8/23/2022 9 650
8/22/2022 8 642
8/21/2022 7 633
8/20/2022 8 626
8/19/2022 9 618
8/18/2022 10 609
8/17/2022 8 599
8/16/2022 9 591
8/15/2022 9 582
8/14/2022 8 573
8/13/2022 8 565
8/12/2022 9 557
8/11/2022 7 548
8/10/2022 8 541
8/9/2022 9 533
8/8/2022 7 524
8/7/2022 7 517
8/6/2022 8 510
8/5/2022 9 502
8/4/2022 8 493
8/3/2022 9 485
8/2/2022 9 477
8/1/2022 8 468
7/31/2022 9 460
7/30/2022 8 451
7/29/2022 8 443
7/28/2022 8 435
7/27/2022 8 427
7/26/2022 9 418
7/25/2022 8 409
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 347
7/17/2022 6 340
7/16/2022 9 334
7/15/2022 8 325
7/14/2022 9 316
7/13/2022 9 307
7/12/2022 9 298
7/11/2022 9 289
7/10/2022 9 280
7/9/2022 7 271
7/8/2022 9 263
7/7/2022 9 254
7/6/2022 8 245
7/5/2022 9 236
7/4/2022 10 227
7/3/2022 8 217
7/2/2022 8 209
7/1/2022 7 201
6/30/2022 8 194
6/29/2022 7 186
6/28/2022 8 180
6/27/2022 8 172
6/26/2022 8 164
6/25/2022 8 156
6/24/2022 8 148
6/23/2022 6 140
6/22/2022 7 133
6/21/2022 9 126
6/20/2022 7 118
6/19/2022 4 111
6/18/2022 8 107
6/17/2022 8 98
6/16/2022 9 90
6/15/2022 9 81
6/14/2022 9 73
6/13/2022 8 63
6/12/2022 9 55
6/11/2022 9 46
6/10/2022 9 36
6/9/2022 7 27
6/8/2022 7 20
6/7/2022 7 13