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 41.0704 2024-06-06 00:00:00.0 6.6594 233
2 46.8069 2024-06-07 00:00:00.0 5.7365 233
3 52.1355 2024-06-08 00:00:00.0 5.3286 233
4 56.2628 2024-06-09 00:00:00.0 4.1273 233
5 60.4906 2024-06-10 00:00:00.0 4.2278 233
6 68.6374 2024-06-11 00:00:00.0 8.1468 233
7 76.4602 2024-06-12 00:00:00.0 7.8228 233
8 83.6555 2024-06-13 00:00:00.0 7.1953 233
9 91.6572 2024-06-14 00:00:00.0 8.0017 233
10 100.2417 2024-06-15 00:00:00.0 8.5845 233
11 108.2914 2024-06-16 00:00:00.0 8.0497 233
12 113.3857 2024-06-17 00:00:00.0 5.0943 233
13 118.6251 2024-06-18 00:00:00.0 5.2394 233
14 123.6163 2024-06-19 00:00:00.0 4.9912 233
15 130.6235 2024-06-20 00:00:00.0 7.0072 233
16 139.5246 2024-06-21 00:00:00.0 8.9011 233
17 147.9245 2024-06-22 00:00:00.0 8.3999 233
18 156.0042 2024-06-23 00:00:00.0 8.0797 233
19 165.1129 2024-06-24 00:00:00.0 9.1087 233
20 173.6834 2024-06-25 00:00:00.0 8.5705 233
21 182.2539 2024-06-26 00:00:00.0 8.5705 233
22 190.8244 2024-06-27 00:00:00.0 8.5705 233
23 199.3949 2024-06-28 00:00:00.0 8.5705 233
24 207.9654 2024-06-29 00:00:00.0 8.5705 233
25 216.5359 2024-06-30 00:00:00.0 8.5705 233
26 225.1064 2024-07-01 00:00:00.0 8.5705 233
27 233.6769 2024-07-02 00:00:00.0 8.5705 233
28 242.2474 2024-07-03 00:00:00.0 8.5705 233
29 250.8179 2024-07-04 00:00:00.0 8.5705 233
30 259.3884 2024-07-05 00:00:00.0 8.5705 233
31 267.9589 2024-07-06 00:00:00.0 8.5705 233
32 276.5294 2024-07-07 00:00:00.0 8.5705 233
33 285.0999 2024-07-08 00:00:00.0 8.5705 233
34 293.6704 2024-07-09 00:00:00.0 8.5705 233
35 302.2409 2024-07-10 00:00:00.0 8.5705 233
36 310.8114 2024-07-11 00:00:00.0 8.5705 233
37 319.3819 2024-07-12 00:00:00.0 8.5705 233
38 327.9524 2024-07-13 00:00:00.0 8.5705 233
39 336.5229 2024-07-14 00:00:00.0 8.5705 233
40 345.0934 2024-07-15 00:00:00.0 8.5705 233
41 353.6639 2024-07-16 00:00:00.0 8.5705 233
42 362.2344 2024-07-17 00:00:00.0 8.5705 233
43 370.8049 2024-07-18 00:00:00.0 8.5705 233
44 379.3754 2024-07-19 00:00:00.0 8.5705 233
45 387.9459 2024-07-20 00:00:00.0 8.5705 233
46 396.5164 2024-07-21 00:00:00.0 8.5705 233
47 405.0869 2024-07-22 00:00:00.0 8.5705 233
48 413.6574 2024-07-23 00:00:00.0 8.5705 233
49 422.2279 2024-07-24 00:00:00.0 8.5705 233
50 430.7984 2024-07-25 00:00:00.0 8.5705 233
51 439.3689 2024-07-26 00:00:00.0 8.5705 233
52 447.9394 2024-07-27 00:00:00.0 8.5705 233
53 456.5099 2024-07-28 00:00:00.0 8.5705 233
54 465.0804 2024-07-29 00:00:00.0 8.5705 233
55 473.6509 2024-07-30 00:00:00.0 8.5705 233
56 482.2214 2024-07-31 00:00:00.0 8.5705 233
57 490.7919 2024-08-01 00:00:00.0 8.5705 233
58 499.3624 2024-08-02 00:00:00.0 8.5705 233
59 507.9329 2024-08-03 00:00:00.0 8.5705 233
60 516.5034 2024-08-04 00:00:00.0 8.5705 233
61 525.0739 2024-08-05 00:00:00.0 8.5705 233
62 533.6444 2024-08-06 00:00:00.0 8.5705 233
63 542.2149 2024-08-07 00:00:00.0 8.5705 233
64 550.7854 2024-08-08 00:00:00.0 8.5705 233
65 559.3559 2024-08-09 00:00:00.0 8.5705 233
66 567.9264 2024-08-10 00:00:00.0 8.5705 233
67 576.4969 2024-08-11 00:00:00.0 8.5705 233
68 585.0674 2024-08-12 00:00:00.0 8.5705 233
69 593.6379 2024-08-13 00:00:00.0 8.5705 233
70 602.2084 2024-08-14 00:00:00.0 8.5705 233
71 610.7789 2024-08-15 00:00:00.0 8.5705 233
72 619.3494 2024-08-16 00:00:00.0 8.5705 233
73 627.9199 2024-08-17 00:00:00.0 8.5705 233
74 636.4904 2024-08-18 00:00:00.0 8.5705 233
75 645.0609 2024-08-19 00:00:00.0 8.5705 233
76 653.6314 2024-08-20 00:00:00.0 8.5705 233
77 662.2019 2024-08-21 00:00:00.0 8.5705 233
78 670.7724 2024-08-22 00:00:00.0 8.5705 233
79 679.3429 2024-08-23 00:00:00.0 8.5705 233
80 687.9134 2024-08-24 00:00:00.0 8.5705 233
81 696.4839 2024-08-25 00:00:00.0 8.5705 233
82 705.0544 2024-08-26 00:00:00.0 8.5705 233
83 713.6249 2024-08-27 00:00:00.0 8.5705 233
84 722.1954 2024-08-28 00:00:00.0 8.5705 233
85 730.7659 2024-08-29 00:00:00.0 8.5705 233
86 739.3364 2024-08-30 00:00:00.0 8.5705 233
87 747.9069 2024-08-31 00:00:00.0 8.5705 233
88 756.4774 2024-09-01 00:00:00.0 8.5705 233
89 765.0479 2024-09-02 00:00:00.0 8.5705 233
90 773.6184 2024-09-03 00:00:00.0 8.5705 233
91 782.1889 2024-09-04 00:00:00.0 8.5705 233
92 790.7594 2024-09-05 00:00:00.0 8.5705 233
93 799.3299 2024-09-06 00:00:00.0 8.5705 233
94 807.9004 2024-09-07 00:00:00.0 8.5705 233
95 816.4709 2024-09-08 00:00:00.0 8.5705 233
96 825.0414 2024-09-09 00:00:00.0 8.5705 233
97 833.6119 2024-09-10 00:00:00.0 8.5705 233
98 842.1824 2024-09-11 00:00:00.0 8.5705 233
99 850.7529 2024-09-12 00:00:00.0 8.5705 233
100 859.3234 2024-09-13 00:00:00.0 8.5705 233
101 867.8939 2024-09-14 00:00:00.0 8.5705 233
102 876.4644 2024-09-15 00:00:00.0 8.5705 233
103 885.0349 2024-09-16 00:00:00.0 8.5705 233
104 893.6054 2024-09-17 00:00:00.0 8.5705 233
105 902.1759 2024-09-18 00:00:00.0 8.5705 233
106 910.7464 2024-09-19 00:00:00.0 8.5705 233
107 919.3169 2024-09-20 00:00:00.0 8.5705 233
108 927.8874 2024-09-21 00:00:00.0 8.5705 233
109 936.4579 2024-09-22 00:00:00.0 8.5705 233
110 945.0284 2024-09-23 00:00:00.0 8.5705 233
111 953.5989 2024-09-24 00:00:00.0 8.5705 233
112 962.1694 2024-09-25 00:00:00.0 8.5705 233
113 970.7399 2024-09-26 00:00:00.0 8.5705 233
114 979.3104 2024-09-27 00:00:00.0 8.5705 233
115 987.8809 2024-09-28 00:00:00.0 8.5705 233
116 996.4514 2024-09-29 00:00:00.0 8.5705 233
117 1005.0219 2024-09-30 00:00:00.0 8.5705 233
118 1013.5924 2024-10-01 00:00:00.0 8.5705 233
119 1022.1629 2024-10-02 00:00:00.0 8.5705 233
120 1030.7334 2024-10-03 00:00:00.0 8.5705 233
121 1039.3039 2024-10-04 00:00:00.0 8.5705 233
122 1047.8744 2024-10-05 00:00:00.0 8.5705 233
123 1056.4449 2024-10-06 00:00:00.0 8.5705 233
124 1065.0154 2024-10-07 00:00:00.0 8.5705 233
125 1073.5859 2024-10-08 00:00:00.0 8.5705 233
126 1082.1564 2024-10-09 00:00:00.0 8.5705 233
127 1090.7269 2024-10-10 00:00:00.0 8.5705 233
128 1099.2974 2024-10-11 00:00:00.0 8.5705 233
129 1107.8679 2024-10-12 00:00:00.0 8.5705 233
130 1116.4384 2024-10-13 00:00:00.0 8.5705 233
131 1125.0089 2024-10-14 00:00:00.0 8.5705 233
132 1133.5794 2024-10-15 00:00:00.0 8.5705 233
133 1142.1499 2024-10-16 00:00:00.0 8.5705 233
134 1150.7204 2024-10-17 00:00:00.0 8.5705 233
135 1159.2909 2024-10-18 00:00:00.0 8.5705 233
136 1167.8614 2024-10-19 00:00:00.0 8.5705 233
137 1176.4319 2024-10-20 00:00:00.0 8.5705 233
138 1185.0024 2024-10-21 00:00:00.0 8.5705 233
139 1193.5729 2024-10-22 00:00:00.0 8.5705 233
140 1202.1434 2024-10-23 00:00:00.0 8.5705 233
141 1210.7139 2024-10-24 00:00:00.0 8.5705 233
142 1219.2844 2024-10-25 00:00:00.0 8.5705 233
143 1227.8549 2024-10-26 00:00:00.0 8.5705 233
144 1236.4254 2024-10-27 00:00:00.0 8.5705 233
145 1244.9959 2024-10-28 00:00:00.0 8.5705 233
146 1253.5664 2024-10-29 00:00:00.0 8.5705 233
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '233') 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 9 1254
10/28/2024 9 1245
10/27/2024 9 1236
10/26/2024 9 1228
10/25/2024 9 1219
10/24/2024 9 1211
10/23/2024 9 1202
10/22/2024 9 1194
10/21/2024 9 1185
10/20/2024 9 1176
10/19/2024 9 1168
10/18/2024 9 1159
10/17/2024 9 1151
10/16/2024 9 1142
10/15/2024 9 1134
10/14/2024 9 1125
10/13/2024 9 1116
10/12/2024 9 1108
10/11/2024 9 1099
10/10/2024 9 1091
10/9/2024 9 1082
10/8/2024 9 1074
10/7/2024 9 1065
10/6/2024 9 1056
10/5/2024 9 1048
10/4/2024 9 1039
10/3/2024 9 1031
10/2/2024 9 1022
10/1/2024 9 1014
9/30/2024 9 1005
9/29/2024 9 996
9/28/2024 9 988
9/27/2024 9 979
9/26/2024 9 971
9/25/2024 9 962
9/24/2024 9 954
9/23/2024 9 945
9/22/2024 9 936
9/21/2024 9 928
9/20/2024 9 919
9/19/2024 9 911
9/18/2024 9 902
9/17/2024 9 894
9/16/2024 9 885
9/15/2024 9 876
9/14/2024 9 868
9/13/2024 9 859
9/12/2024 9 851
9/11/2024 9 842
9/10/2024 9 834
9/9/2024 9 825
9/8/2024 9 816
9/7/2024 9 808
9/6/2024 9 799
9/5/2024 9 791
9/4/2024 9 782
9/3/2024 9 774
9/2/2024 9 765
9/1/2024 9 756
8/31/2024 9 748
8/30/2024 9 739
8/29/2024 9 731
8/28/2024 9 722
8/27/2024 9 714
8/26/2024 9 705
8/25/2024 9 696
8/24/2024 9 688
8/23/2024 9 679
8/22/2024 9 671
8/21/2024 9 662
8/20/2024 9 654
8/19/2024 9 645
8/18/2024 9 636
8/17/2024 9 628
8/16/2024 9 619
8/15/2024 9 611
8/14/2024 9 602
8/13/2024 9 594
8/12/2024 9 585
8/11/2024 9 576
8/10/2024 9 568
8/9/2024 9 559
8/8/2024 9 551
8/7/2024 9 542
8/6/2024 9 534
8/5/2024 9 525
8/4/2024 9 517
8/3/2024 9 508
8/2/2024 9 499
8/1/2024 9 491
7/31/2024 9 482
7/30/2024 9 474
7/29/2024 9 465
7/28/2024 9 457
7/27/2024 9 448
7/26/2024 9 439
7/25/2024 9 431
7/24/2024 9 422
7/23/2024 9 414
7/22/2024 9 405
7/21/2024 9 397
7/20/2024 9 388
7/19/2024 9 379
7/18/2024 9 371
7/17/2024 9 362
7/16/2024 9 354
7/15/2024 9 345
7/14/2024 9 337
7/13/2024 9 328
7/12/2024 9 319
7/11/2024 9 311
7/10/2024 9 302
7/9/2024 9 294
7/8/2024 9 285
7/7/2024 9 277
7/6/2024 9 268
7/5/2024 9 259
7/4/2024 9 251
7/3/2024 9 242
7/2/2024 9 234
7/1/2024 9 225
6/30/2024 9 217
6/29/2024 9 208
6/28/2024 9 199
6/27/2024 9 191
6/26/2024 9 182
6/25/2024 9 174
6/24/2024 9 165
6/23/2024 8 156
6/22/2024 8 148
6/21/2024 9 140
6/20/2024 7 131
6/19/2024 5 124
6/18/2024 5 119
6/17/2024 5 113
6/16/2024 8 108
6/15/2024 9 100
6/14/2024 8 92
6/13/2024 7 84
6/12/2024 8 76
6/11/2024 8 69
6/10/2024 4 60
6/9/2024 4 56
6/8/2024 5 52
6/7/2024 6 47