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.9911 2022-06-06 00:00:00.0 3.9911 201
2 9.3120 2022-06-07 00:00:00.0 5.3209 201
3 15.0998 2022-06-08 00:00:00.0 5.7878 201
4 21.7592 2022-06-09 00:00:00.0 6.6594 201
5 30.1542 2022-06-10 00:00:00.0 8.3950 201
6 39.0475 2022-06-11 00:00:00.0 8.8933 201
7 48.2519 2022-06-12 00:00:00.0 9.2044 201
8 57.0875 2022-06-13 00:00:00.0 8.8356 201
9 66.0038 2022-06-14 00:00:00.0 8.9163 201
10 74.1046 2022-06-15 00:00:00.0 8.1008 201
11 82.2189 2022-06-16 00:00:00.0 8.1143 201
12 90.5782 2022-06-17 00:00:00.0 8.3593 201
13 98.6650 2022-06-18 00:00:00.0 8.0868 201
14 101.3477 2022-06-19 00:00:00.0 2.6827 201
15 110.4001 2022-06-20 00:00:00.0 9.0524 201
16 119.0108 2022-06-21 00:00:00.0 8.6107 201
17 127.0074 2022-06-22 00:00:00.0 7.9966 201
18 134.0213 2022-06-23 00:00:00.0 7.0139 201
19 143.5667 2022-06-24 00:00:00.0 9.5454 201
20 150.3054 2022-06-25 00:00:00.0 6.7387 201
21 157.9093 2022-06-26 00:00:00.0 7.6039 201
22 166.1151 2022-06-27 00:00:00.0 8.2058 201
23 173.8135 2022-06-28 00:00:00.0 7.6984 201
24 182.3074 2022-06-29 00:00:00.0 8.4939 201
25 191.5406 2022-06-30 00:00:00.0 9.2332 201
26 199.2626 2022-07-01 00:00:00.0 7.7220 201
27 206.3277 2022-07-02 00:00:00.0 7.0651 201
28 215.2604 2022-07-03 00:00:00.0 8.9327 201
29 224.6880 2022-07-04 00:00:00.0 9.4276 201
30 234.0884 2022-07-05 00:00:00.0 9.4004 201
31 242.8421 2022-07-06 00:00:00.0 8.7537 201
32 251.2213 2022-07-07 00:00:00.0 8.3792 201
33 259.0091 2022-07-08 00:00:00.0 7.7878 201
34 266.9343 2022-07-09 00:00:00.0 7.9252 201
35 276.0420 2022-07-10 00:00:00.0 9.1077 201
36 285.3482 2022-07-11 00:00:00.0 9.3062 201
37 294.4483 2022-07-12 00:00:00.0 9.1001 201
38 302.8837 2022-07-13 00:00:00.0 8.4354 201
39 312.3947 2022-07-14 00:00:00.0 9.5110 201
40 320.9407 2022-07-15 00:00:00.0 8.5460 201
41 329.5062 2022-07-16 00:00:00.0 8.5655 201
42 335.6287 2022-07-17 00:00:00.0 6.1225 201
43 344.3199 2022-07-18 00:00:00.0 8.6912 201
44 353.8631 2022-07-19 00:00:00.0 9.5432 201
45 363.1124 2022-07-20 00:00:00.0 9.2493 201
46 372.0517 2022-07-21 00:00:00.0 8.9393 201
47 380.9245 2022-07-22 00:00:00.0 8.8728 201
48 389.5547 2022-07-23 00:00:00.0 8.6302 201
49 397.1789 2022-07-24 00:00:00.0 7.6242 201
50 405.1498 2022-07-25 00:00:00.0 7.9709 201
51 413.7323 2022-07-26 00:00:00.0 8.5825 201
52 421.4230 2022-07-27 00:00:00.0 7.6907 201
53 429.4858 2022-07-28 00:00:00.0 8.0628 201
54 437.4023 2022-07-29 00:00:00.0 7.9165 201
55 445.3040 2022-07-30 00:00:00.0 7.9017 201
56 453.6081 2022-07-31 00:00:00.0 8.3041 201
57 461.5278 2022-08-01 00:00:00.0 7.9197 201
58 469.5514 2022-08-02 00:00:00.0 8.0236 201
59 477.7913 2022-08-03 00:00:00.0 8.2399 201
60 485.8907 2022-08-04 00:00:00.0 8.0994 201
61 495.2032 2022-08-05 00:00:00.0 9.3125 201
62 502.1716 2022-08-06 00:00:00.0 6.9684 201
63 508.2733 2022-08-07 00:00:00.0 6.1017 201
64 516.4861 2022-08-08 00:00:00.0 8.2128 201
65 525.0036 2022-08-09 00:00:00.0 8.5175 201
66 532.4072 2022-08-10 00:00:00.0 7.4036 201
67 538.5486 2022-08-11 00:00:00.0 6.1414 201
68 547.6957 2022-08-12 00:00:00.0 9.1471 201
69 556.0274 2022-08-13 00:00:00.0 8.3317 201
70 563.9387 2022-08-14 00:00:00.0 7.9113 201
71 573.2259 2022-08-15 00:00:00.0 9.2872 201
72 581.6979 2022-08-16 00:00:00.0 8.4720 201
73 589.8101 2022-08-17 00:00:00.0 8.1122 201
74 599.3085 2022-08-18 00:00:00.0 9.4984 201
75 607.9246 2022-08-19 00:00:00.0 8.6161 201
76 615.0494 2022-08-20 00:00:00.0 7.1248 201
77 622.7027 2022-08-21 00:00:00.0 7.6533 201
78 631.8905 2022-08-22 00:00:00.0 9.1878 201
79 640.7559 2022-08-23 00:00:00.0 8.8654 201
80 647.4586 2022-08-24 00:00:00.0 6.7027 201
81 653.6161 2022-08-25 00:00:00.0 6.1575 201
82 662.6915 2022-08-26 00:00:00.0 9.0754 201
83 670.9669 2022-08-27 00:00:00.0 8.2754 201
84 680.1490 2022-08-28 00:00:00.0 9.1821 201
85 689.1196 2022-08-29 00:00:00.0 8.9706 201
86 697.1141 2022-08-30 00:00:00.0 7.9945 201
87 704.3301 2022-08-31 00:00:00.0 7.2160 201
88 711.4944 2022-09-01 00:00:00.0 7.1643 201
89 718.6688 2022-09-02 00:00:00.0 7.1744 201
90 725.3314 2022-09-03 00:00:00.0 6.6626 201
91 734.1022 2022-09-04 00:00:00.0 8.7708 201
92 742.3320 2022-09-05 00:00:00.0 8.2298 201
93 750.0669 2022-09-06 00:00:00.0 7.7349 201
94 756.9655 2022-09-07 00:00:00.0 6.8986 201
95 765.0509 2022-09-08 00:00:00.0 8.0854 201
96 770.9616 2022-09-09 00:00:00.0 5.9107 201
97 776.1846 2022-09-10 00:00:00.0 5.2230 201
98 782.6396 2022-09-11 00:00:00.0 6.4550 201
99 790.0434 2022-09-12 00:00:00.0 7.4038 201
100 793.0748 2022-09-13 00:00:00.0 3.0314 201
101 798.5669 2022-09-14 00:00:00.0 5.4921 201
102 805.4558 2022-09-15 00:00:00.0 6.8889 201
103 809.9810 2022-09-16 00:00:00.0 4.5252 201
104 816.3470 2022-09-17 00:00:00.0 6.3660 201
105 824.0732 2022-09-18 00:00:00.0 7.7262 201
106 830.1085 2022-09-19 00:00:00.0 6.0353 201
107 837.3015 2022-09-20 00:00:00.0 7.1930 201
108 839.8361 2022-09-21 00:00:00.0 2.5346 201
109 842.3515 2022-09-22 00:00:00.0 2.5154 201
110 847.1490 2022-09-23 00:00:00.0 4.7975 201
111 854.4653 2022-09-24 00:00:00.0 7.3163 201
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '201') 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 854
9/23/2022 5 847
9/22/2022 3 842
9/21/2022 3 840
9/20/2022 7 837
9/19/2022 6 830
9/18/2022 8 824
9/17/2022 6 816
9/16/2022 5 810
9/15/2022 7 805
9/14/2022 5 799
9/13/2022 3 793
9/12/2022 7 790
9/11/2022 6 783
9/10/2022 5 776
9/9/2022 6 771
9/8/2022 8 765
9/7/2022 7 757
9/6/2022 8 750
9/5/2022 8 742
9/4/2022 9 734
9/3/2022 7 725
9/2/2022 7 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 671
8/26/2022 9 663
8/25/2022 6 654
8/24/2022 7 647
8/23/2022 9 641
8/22/2022 9 632
8/21/2022 8 623
8/20/2022 7 615
8/19/2022 9 608
8/18/2022 9 599
8/17/2022 8 590
8/16/2022 8 582
8/15/2022 9 573
8/14/2022 8 564
8/13/2022 8 556
8/12/2022 9 548
8/11/2022 6 539
8/10/2022 7 532
8/9/2022 9 525
8/8/2022 8 516
8/7/2022 6 508
8/6/2022 7 502
8/5/2022 9 495
8/4/2022 8 486
8/3/2022 8 478
8/2/2022 8 470
8/1/2022 8 462
7/31/2022 8 454
7/30/2022 8 445
7/29/2022 8 437
7/28/2022 8 429
7/27/2022 8 421
7/26/2022 9 414
7/25/2022 8 405
7/24/2022 8 397
7/23/2022 9 390
7/22/2022 9 381
7/21/2022 9 372
7/20/2022 9 363
7/19/2022 10 354
7/18/2022 9 344
7/17/2022 6 336
7/16/2022 9 330
7/15/2022 9 321
7/14/2022 10 312
7/13/2022 8 303
7/12/2022 9 294
7/11/2022 9 285
7/10/2022 9 276
7/9/2022 8 267
7/8/2022 8 259
7/7/2022 8 251
7/6/2022 9 243
7/5/2022 9 234
7/4/2022 9 225
7/3/2022 9 215
7/2/2022 7 206
7/1/2022 8 199
6/30/2022 9 192
6/29/2022 8 182
6/28/2022 8 174
6/27/2022 8 166
6/26/2022 8 158
6/25/2022 7 150
6/24/2022 10 144
6/23/2022 7 134
6/22/2022 8 127
6/21/2022 9 119
6/20/2022 9 110
6/19/2022 3 101
6/18/2022 8 99
6/17/2022 8 91
6/16/2022 8 82
6/15/2022 8 74
6/14/2022 9 66
6/13/2022 9 57
6/12/2022 9 48
6/11/2022 9 39
6/10/2022 8 30
6/9/2022 7 22
6/8/2022 6 15
6/7/2022 5 9