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 46.7680 2024-06-06 00:00:00.0 7.0142 240
2 52.5892 2024-06-07 00:00:00.0 5.8212 240
3 58.7813 2024-06-08 00:00:00.0 6.1921 240
4 63.2975 2024-06-09 00:00:00.0 4.5162 240
5 68.0213 2024-06-10 00:00:00.0 4.7238 240
6 76.7053 2024-06-11 00:00:00.0 8.6840 240
7 84.5376 2024-06-12 00:00:00.0 7.8323 240
8 92.1117 2024-06-13 00:00:00.0 7.5741 240
9 99.7858 2024-06-14 00:00:00.0 7.6741 240
10 108.0498 2024-06-15 00:00:00.0 8.2640 240
11 116.8785 2024-06-16 00:00:00.0 8.8287 240
12 122.4794 2024-06-17 00:00:00.0 5.6009 240
13 128.2086 2024-06-18 00:00:00.0 5.7292 240
14 133.8479 2024-06-19 00:00:00.0 5.6393 240
15 141.6016 2024-06-20 00:00:00.0 7.7537 240
16 149.9280 2024-06-21 00:00:00.0 8.3264 240
17 158.9213 2024-06-22 00:00:00.0 8.9933 240
18 167.1020 2024-06-23 00:00:00.0 8.1807 240
19 175.4688 2024-06-24 00:00:00.0 8.3668 240
20 184.3771 2024-06-25 00:00:00.0 8.9083 240
21 192.2205 2024-06-26 00:00:00.0 7.8434 240
22 199.2924 2024-06-27 00:00:00.0 7.0719 240
23 205.4013 2024-06-28 00:00:00.0 6.1089 240
24 211.2089 2024-06-29 00:00:00.0 5.8076 240
25 217.1416 2024-06-30 00:00:00.0 5.9327 240
26 226.3176 2024-07-01 00:00:00.0 9.1760 240
27 235.5878 2024-07-02 00:00:00.0 9.2702 240
28 244.2292 2024-07-03 00:00:00.0 8.6414 240
29 252.7350 2024-07-04 00:00:00.0 8.5058 240
30 260.6141 2024-07-05 00:00:00.0 7.8791 240
31 269.3670 2024-07-06 00:00:00.0 8.7529 240
32 278.0455 2024-07-07 00:00:00.0 8.6785 240
33 286.4578 2024-07-08 00:00:00.0 8.4123 240
34 294.6950 2024-07-09 00:00:00.0 8.2372 240
35 302.8636 2024-07-10 00:00:00.0 8.1686 240
36 309.2537 2024-07-11 00:00:00.0 6.3901 240
37 316.4255 2024-07-12 00:00:00.0 7.1718 240
38 324.9576 2024-07-13 00:00:00.0 8.5321 240
39 333.3935 2024-07-14 00:00:00.0 8.4359 240
40 342.3388 2024-07-15 00:00:00.0 8.9453 240
41 350.3174 2024-07-16 00:00:00.0 7.9786 240
42 356.7477 2024-07-17 00:00:00.0 6.4303 240
43 364.6407 2024-07-18 00:00:00.0 7.8930 240
44 372.6251 2024-07-19 00:00:00.0 7.9844 240
45 380.8782 2024-07-20 00:00:00.0 8.2531 240
46 389.4122 2024-07-21 00:00:00.0 8.5340 240
47 398.4275 2024-07-22 00:00:00.0 9.0153 240
48 407.7181 2024-07-23 00:00:00.0 9.2906 240
49 416.5165 2024-07-24 00:00:00.0 8.7984 240
50 423.6008 2024-07-25 00:00:00.0 7.0843 240
51 432.5458 2024-07-26 00:00:00.0 8.9450 240
52 439.9012 2024-07-27 00:00:00.0 7.3554 240
53 448.4870 2024-07-28 00:00:00.0 8.5858 240
54 456.3225 2024-07-29 00:00:00.0 7.8355 240
55 463.8608 2024-07-30 00:00:00.0 7.5383 240
56 472.3090 2024-07-31 00:00:00.0 8.4482 240
57 479.6429 2024-08-01 00:00:00.0 7.3339 240
58 487.2597 2024-08-02 00:00:00.0 7.6168 240
59 496.4129 2024-08-03 00:00:00.0 9.1532 240
60 502.8226 2024-08-04 00:00:00.0 6.4097 240
61 510.7877 2024-08-05 00:00:00.0 7.9651 240
62 518.4768 2024-08-06 00:00:00.0 7.6891 240
63 525.0003 2024-08-07 00:00:00.0 6.5235 240
64 531.3552 2024-08-08 00:00:00.0 6.3549 240
65 537.8695 2024-08-09 00:00:00.0 6.5143 240
66 543.9465 2024-08-10 00:00:00.0 6.0770 240
67 550.5398 2024-08-11 00:00:00.0 6.5933 240
68 556.8090 2024-08-12 00:00:00.0 6.2692 240
69 564.6917 2024-08-13 00:00:00.0 7.8827 240
70 574.1820 2024-08-14 00:00:00.0 9.4903 240
71 583.9522 2024-08-15 00:00:00.0 9.7702 240
72 593.2571 2024-08-16 00:00:00.0 9.3049 240
73 601.7550 2024-08-17 00:00:00.0 8.4979 240
74 609.3283 2024-08-18 00:00:00.0 7.5733 240
75 617.6092 2024-08-19 00:00:00.0 8.2809 240
76 625.8300 2024-08-20 00:00:00.0 8.2208 240
77 634.7680 2024-08-21 00:00:00.0 8.9380 240
78 643.7036 2024-08-22 00:00:00.0 8.9356 240
79 652.2046 2024-08-23 00:00:00.0 8.5010 240
80 659.8461 2024-08-24 00:00:00.0 7.6415 240
81 668.2384 2024-08-25 00:00:00.0 8.3923 240
82 675.6785 2024-08-26 00:00:00.0 7.4401 240
83 681.8288 2024-08-27 00:00:00.0 6.1503 240
84 687.8916 2024-08-28 00:00:00.0 6.0628 240
85 696.5069 2024-08-29 00:00:00.0 8.6153 240
86 704.8135 2024-08-30 00:00:00.0 8.3066 240
87 712.1758 2024-08-31 00:00:00.0 7.3623 240
88 718.1138 2024-09-01 00:00:00.0 5.9380 240
89 724.8524 2024-09-02 00:00:00.0 6.7386 240
90 731.8368 2024-09-03 00:00:00.0 6.9844 240
91 740.3683 2024-09-04 00:00:00.0 8.5315 240
92 746.2764 2024-09-05 00:00:00.0 5.9081 240
93 751.3180 2024-09-06 00:00:00.0 5.0416 240
94 756.7317 2024-09-07 00:00:00.0 5.4137 240
95 762.7323 2024-09-08 00:00:00.0 6.0006 240
96 768.8366 2024-09-09 00:00:00.0 6.1043 240
97 776.4500 2024-09-10 00:00:00.0 7.6134 240
98 782.0355 2024-09-11 00:00:00.0 5.5855 240
99 790.1155 2024-09-12 00:00:00.0 8.0800 240
100 799.6198 2024-09-13 00:00:00.0 9.5043 240
101 807.7728 2024-09-14 00:00:00.0 8.1530 240
102 814.9202 2024-09-15 00:00:00.0 7.1474 240
103 822.2222 2024-09-16 00:00:00.0 7.3020 240
104 830.6652 2024-09-17 00:00:00.0 8.4430 240
105 839.8617 2024-09-18 00:00:00.0 9.1965 240
106 848.5238 2024-09-19 00:00:00.0 8.6621 240
107 853.2297 2024-09-20 00:00:00.0 4.7059 240
108 858.7869 2024-09-21 00:00:00.0 5.5572 240
109 863.6164 2024-09-22 00:00:00.0 4.8295 240
110 871.8825 2024-09-23 00:00:00.0 8.2661 240
111 878.9612 2024-09-24 00:00:00.0 7.0787 240
112 886.3480 2024-09-25 00:00:00.0 7.3868 240
113 893.7875 2024-09-26 00:00:00.0 7.4395 240
114 900.1337 2024-09-27 00:00:00.0 6.3462 240
115 906.6169 2024-09-28 00:00:00.0 6.4832 240
116 912.2300 2024-09-29 00:00:00.0 5.6131 240
117 918.8319 2024-09-30 00:00:00.0 6.6019 240
118 922.5030 2024-10-01 00:00:00.0 3.6711 240
119 925.9332 2024-10-02 00:00:00.0 3.4302 240
120 927.2474 2024-10-03 00:00:00.0 1.3142 240
121 930.7772 2024-10-04 00:00:00.0 3.5298 240
122 935.1259 2024-10-05 00:00:00.0 4.3487 240
123 938.1456 2024-10-06 00:00:00.0 3.0197 240
124 941.6746 2024-10-07 00:00:00.0 3.5290 240
125 947.0395 2024-10-08 00:00:00.0 5.3649 240
126 952.3350 2024-10-09 00:00:00.0 5.2955 240
127 958.0049 2024-10-10 00:00:00.0 5.6699 240
128 960.3974 2024-10-11 00:00:00.0 2.3925 240
129 963.9907 2024-10-12 00:00:00.0 3.5933 240
130 965.1503 2024-10-13 00:00:00.0 1.1596 240
131 965.5715 2024-10-14 00:00:00.0 0.4212 240
132 966.3276 2024-10-15 00:00:00.0 0.7561 240
133 969.8814 2024-10-16 00:00:00.0 3.5538 240
134 972.9232 2024-10-17 00:00:00.0 3.0418 240
135 973.6300 2024-10-18 00:00:00.0 0.7068 240
136 975.8852 2024-10-19 00:00:00.0 2.2552 240
137 980.6499 2024-10-20 00:00:00.0 4.7647 240
138 984.6658 2024-10-21 00:00:00.0 4.0159 240
139 985.9137 2024-10-22 00:00:00.0 1.2479 240
140 988.0257 2024-10-23 00:00:00.0 2.1120 240
141 988.6506 2024-10-24 00:00:00.0 0.6249 240
142 989.1289 2024-10-25 00:00:00.0 0.4783 240
143 989.8962 2024-10-26 00:00:00.0 0.7673 240
144 990.8169 2024-10-27 00:00:00.0 0.9207 240
145 993.8218 2024-10-28 00:00:00.0 3.0049 240
146 994.2136 2024-10-29 00:00:00.0 0.3918 240
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '240') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-10-29'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/29/2024 0 994
10/28/2024 3 994
10/27/2024 1 991
10/26/2024 1 990
10/25/2024 0 989
10/24/2024 1 989
10/23/2024 2 988
10/22/2024 1 986
10/21/2024 4 985
10/20/2024 5 981
10/19/2024 2 976
10/18/2024 1 974
10/17/2024 3 973
10/16/2024 4 970
10/15/2024 1 966
10/14/2024 0 966
10/13/2024 1 965
10/12/2024 4 964
10/11/2024 2 960
10/10/2024 6 958
10/9/2024 5 952
10/8/2024 5 947
10/7/2024 4 942
10/6/2024 3 938
10/5/2024 4 935
10/4/2024 4 931
10/3/2024 1 927
10/2/2024 3 926
10/1/2024 4 923
9/30/2024 7 919
9/29/2024 6 912
9/28/2024 6 907
9/27/2024 6 900
9/26/2024 7 894
9/25/2024 7 886
9/24/2024 7 879
9/23/2024 8 872
9/22/2024 5 864
9/21/2024 6 859
9/20/2024 5 853
9/19/2024 9 849
9/18/2024 9 840
9/17/2024 8 831
9/16/2024 7 822
9/15/2024 7 815
9/14/2024 8 808
9/13/2024 10 800
9/12/2024 8 790
9/11/2024 6 782
9/10/2024 8 776
9/9/2024 6 769
9/8/2024 6 763
9/7/2024 5 757
9/6/2024 5 751
9/5/2024 6 746
9/4/2024 9 740
9/3/2024 7 732
9/2/2024 7 725
9/1/2024 6 718
8/31/2024 7 712
8/30/2024 8 705
8/29/2024 9 697
8/28/2024 6 688
8/27/2024 6 682
8/26/2024 7 676
8/25/2024 8 668
8/24/2024 8 660
8/23/2024 9 652
8/22/2024 9 644
8/21/2024 9 635
8/20/2024 8 626
8/19/2024 8 618
8/18/2024 8 609
8/17/2024 8 602
8/16/2024 9 593
8/15/2024 10 584
8/14/2024 9 574
8/13/2024 8 565
8/12/2024 6 557
8/11/2024 7 551
8/10/2024 6 544
8/9/2024 7 538
8/8/2024 6 531
8/7/2024 7 525
8/6/2024 8 518
8/5/2024 8 511
8/4/2024 6 503
8/3/2024 9 496
8/2/2024 8 487
8/1/2024 7 480
7/31/2024 8 472
7/30/2024 8 464
7/29/2024 8 456
7/28/2024 9 448
7/27/2024 7 440
7/26/2024 9 433
7/25/2024 7 424
7/24/2024 9 417
7/23/2024 9 408
7/22/2024 9 398
7/21/2024 9 389
7/20/2024 8 381
7/19/2024 8 373
7/18/2024 8 365
7/17/2024 6 357
7/16/2024 8 350
7/15/2024 9 342
7/14/2024 8 333
7/13/2024 9 325
7/12/2024 7 316
7/11/2024 6 309
7/10/2024 8 303
7/9/2024 8 295
7/8/2024 8 286
7/7/2024 9 278
7/6/2024 9 269
7/5/2024 8 261
7/4/2024 9 253
7/3/2024 9 244
7/2/2024 9 236
7/1/2024 9 226
6/30/2024 6 217
6/29/2024 6 211
6/28/2024 6 205
6/27/2024 7 199
6/26/2024 8 192
6/25/2024 9 184
6/24/2024 8 175
6/23/2024 8 167
6/22/2024 9 159
6/21/2024 8 150
6/20/2024 8 142
6/19/2024 6 134
6/18/2024 6 128
6/17/2024 6 122
6/16/2024 9 117
6/15/2024 8 108
6/14/2024 8 100
6/13/2024 8 92
6/12/2024 8 85
6/11/2024 9 77
6/10/2024 5 68
6/9/2024 5 63
6/8/2024 6 59
6/7/2024 6 53