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 47.0640 2024-06-06 00:00:00.0 5.1038 243
2 53.2713 2024-06-07 00:00:00.0 6.2073 243
3 59.5961 2024-06-08 00:00:00.0 6.3248 243
4 65.5952 2024-06-09 00:00:00.0 5.9991 243
5 71.6591 2024-06-10 00:00:00.0 6.0639 243
6 80.4061 2024-06-11 00:00:00.0 8.7470 243
7 88.9630 2024-06-12 00:00:00.0 8.5569 243
8 96.5500 2024-06-13 00:00:00.0 7.5870 243
9 104.0029 2024-06-14 00:00:00.0 7.4529 243
10 112.1383 2024-06-15 00:00:00.0 8.1354 243
11 120.9999 2024-06-16 00:00:00.0 8.8616 243
12 127.7095 2024-06-17 00:00:00.0 6.7096 243
13 134.2748 2024-06-18 00:00:00.0 6.5653 243
14 141.8030 2024-06-19 00:00:00.0 7.5282 243
15 150.6267 2024-06-20 00:00:00.0 8.8237 243
16 159.2267 2024-06-21 00:00:00.0 8.6000 243
17 167.9765 2024-06-22 00:00:00.0 8.7498 243
18 176.7168 2024-06-23 00:00:00.0 8.7403 243
19 184.2287 2024-06-24 00:00:00.0 7.5119 243
20 193.3067 2024-06-25 00:00:00.0 9.0780 243
21 201.2776 2024-06-26 00:00:00.0 7.9709 243
22 208.5802 2024-06-27 00:00:00.0 7.3026 243
23 215.1645 2024-06-28 00:00:00.0 6.5843 243
24 222.3634 2024-06-29 00:00:00.0 7.1989 243
25 228.6309 2024-06-30 00:00:00.0 6.2675 243
26 237.2917 2024-07-01 00:00:00.0 8.6608 243
27 246.5997 2024-07-02 00:00:00.0 9.3080 243
28 255.6510 2024-07-03 00:00:00.0 9.0513 243
29 264.3910 2024-07-04 00:00:00.0 8.7400 243
30 273.3648 2024-07-05 00:00:00.0 8.9738 243
31 281.8925 2024-07-06 00:00:00.0 8.5277 243
32 290.5191 2024-07-07 00:00:00.0 8.6266 243
33 299.1563 2024-07-08 00:00:00.0 8.6372 243
34 307.4303 2024-07-09 00:00:00.0 8.2740 243
35 315.5954 2024-07-10 00:00:00.0 8.1651 243
36 322.9232 2024-07-11 00:00:00.0 7.3278 243
37 329.9922 2024-07-12 00:00:00.0 7.0690 243
38 338.4939 2024-07-13 00:00:00.0 8.5017 243
39 347.2837 2024-07-14 00:00:00.0 8.7898 243
40 356.5780 2024-07-15 00:00:00.0 9.2943 243
41 365.0587 2024-07-16 00:00:00.0 8.4807 243
42 372.4530 2024-07-17 00:00:00.0 7.3943 243
43 380.5657 2024-07-18 00:00:00.0 8.1127 243
44 389.0941 2024-07-19 00:00:00.0 8.5284 243
45 396.7967 2024-07-20 00:00:00.0 7.7026 243
46 405.5790 2024-07-21 00:00:00.0 8.7823 243
47 414.8908 2024-07-22 00:00:00.0 9.3118 243
48 424.4985 2024-07-23 00:00:00.0 9.6077 243
49 433.4470 2024-07-24 00:00:00.0 8.9485 243
50 442.0948 2024-07-25 00:00:00.0 8.6478 243
51 449.7792 2024-07-26 00:00:00.0 7.6844 243
52 458.2290 2024-07-27 00:00:00.0 8.4498 243
53 467.5253 2024-07-28 00:00:00.0 9.2963 243
54 476.0119 2024-07-29 00:00:00.0 8.4866 243
55 483.9231 2024-07-30 00:00:00.0 7.9112 243
56 492.4032 2024-07-31 00:00:00.0 8.4801 243
57 499.7043 2024-08-01 00:00:00.0 7.3011 243
58 508.0976 2024-08-02 00:00:00.0 8.3933 243
59 517.4563 2024-08-03 00:00:00.0 9.3587 243
60 524.5378 2024-08-04 00:00:00.0 7.0815 243
61 533.1607 2024-08-05 00:00:00.0 8.6229 243
62 540.2472 2024-08-06 00:00:00.0 7.0865 243
63 548.2170 2024-08-07 00:00:00.0 7.9698 243
64 554.9245 2024-08-08 00:00:00.0 6.7075 243
65 561.6559 2024-08-09 00:00:00.0 6.7314 243
66 568.3993 2024-08-10 00:00:00.0 6.7434 243
67 575.6755 2024-08-11 00:00:00.0 7.2762 243
68 583.3346 2024-08-12 00:00:00.0 7.6591 243
69 591.6811 2024-08-13 00:00:00.0 8.3465 243
70 601.0099 2024-08-14 00:00:00.0 9.3288 243
71 610.8026 2024-08-15 00:00:00.0 9.7927 243
72 620.1666 2024-08-16 00:00:00.0 9.3640 243
73 629.2252 2024-08-17 00:00:00.0 9.0586 243
74 637.0253 2024-08-18 00:00:00.0 7.8001 243
75 645.2036 2024-08-19 00:00:00.0 8.1783 243
76 653.3894 2024-08-20 00:00:00.0 8.1858 243
77 662.3094 2024-08-21 00:00:00.0 8.9200 243
78 671.3892 2024-08-22 00:00:00.0 9.0798 243
79 679.7054 2024-08-23 00:00:00.0 8.3162 243
80 687.3216 2024-08-24 00:00:00.0 7.6162 243
81 694.4120 2024-08-25 00:00:00.0 7.0904 243
82 702.6070 2024-08-26 00:00:00.0 8.1950 243
83 709.5848 2024-08-27 00:00:00.0 6.9778 243
84 717.4701 2024-08-28 00:00:00.0 7.8853 243
85 725.9287 2024-08-29 00:00:00.0 8.4586 243
86 734.3438 2024-08-30 00:00:00.0 8.4151 243
87 741.9721 2024-08-31 00:00:00.0 7.6283 243
88 748.1413 2024-09-01 00:00:00.0 6.1692 243
89 756.0099 2024-09-02 00:00:00.0 7.8686 243
90 763.9590 2024-09-03 00:00:00.0 7.9491 243
91 773.4388 2024-09-04 00:00:00.0 9.4798 243
92 780.5999 2024-09-05 00:00:00.0 7.1611 243
93 786.2988 2024-09-06 00:00:00.0 5.6989 243
94 792.4219 2024-09-07 00:00:00.0 6.1231 243
95 799.3839 2024-09-08 00:00:00.0 6.9620 243
96 806.8454 2024-09-09 00:00:00.0 7.4615 243
97 815.6394 2024-09-10 00:00:00.0 8.7940 243
98 823.1006 2024-09-11 00:00:00.0 7.4612 243
99 830.7014 2024-09-12 00:00:00.0 7.6008 243
100 840.1532 2024-09-13 00:00:00.0 9.4518 243
101 848.6047 2024-09-14 00:00:00.0 8.4515 243
102 856.5126 2024-09-15 00:00:00.0 7.9079 243
103 865.5614 2024-09-16 00:00:00.0 9.0488 243
104 874.9336 2024-09-17 00:00:00.0 9.3722 243
105 883.8907 2024-09-18 00:00:00.0 8.9571 243
106 892.8478 2024-09-19 00:00:00.0 8.9571 243
107 901.8049 2024-09-20 00:00:00.0 8.9571 243
108 910.7620 2024-09-21 00:00:00.0 8.9571 243
109 919.7191 2024-09-22 00:00:00.0 8.9571 243
110 928.6762 2024-09-23 00:00:00.0 8.9571 243
111 937.6333 2024-09-24 00:00:00.0 8.9571 243
112 946.5904 2024-09-25 00:00:00.0 8.9571 243
113 955.5475 2024-09-26 00:00:00.0 8.9571 243
114 964.5046 2024-09-27 00:00:00.0 8.9571 243
115 973.4617 2024-09-28 00:00:00.0 8.9571 243
116 982.4188 2024-09-29 00:00:00.0 8.9571 243
117 991.3759 2024-09-30 00:00:00.0 8.9571 243
118 1000.3330 2024-10-01 00:00:00.0 8.9571 243
119 1009.2901 2024-10-02 00:00:00.0 8.9571 243
120 1018.2472 2024-10-03 00:00:00.0 8.9571 243
121 1021.3216 2024-10-04 00:00:00.0 3.0744 243
122 1024.6768 2024-10-05 00:00:00.0 3.3552 243
123 1027.8622 2024-10-06 00:00:00.0 3.1854 243
124 1031.4912 2024-10-07 00:00:00.0 3.6290 243
125 1036.1188 2024-10-08 00:00:00.0 4.6276 243
126 1043.3511 2024-10-09 00:00:00.0 7.2323 243
127 1050.5444 2024-10-10 00:00:00.0 7.1933 243
128 1053.4944 2024-10-11 00:00:00.0 2.9500 243
129 1055.9176 2024-10-12 00:00:00.0 2.4232 243
130 1056.9376 2024-10-13 00:00:00.0 1.0200 243
131 1056.9376 2024-10-14 00:00:00.0 0.0000 243
132 1057.4159 2024-10-15 00:00:00.0 0.4783 243
133 1060.3405 2024-10-16 00:00:00.0 2.9246 243
134 1065.5805 2024-10-17 00:00:00.0 5.2400 243
135 1067.6247 2024-10-18 00:00:00.0 2.0442 243
136 1069.4370 2024-10-19 00:00:00.0 1.8123 243
137 1075.2021 2024-10-20 00:00:00.0 5.7651 243
138 1080.4167 2024-10-21 00:00:00.0 5.2146 243
139 1083.0393 2024-10-22 00:00:00.0 2.6226 243
140 1084.7038 2024-10-23 00:00:00.0 1.6645 243
141 1085.2640 2024-10-24 00:00:00.0 0.5602 243
142 1085.6852 2024-10-25 00:00:00.0 0.4212 243
143 1086.1494 2024-10-26 00:00:00.0 0.4642 243
144 1087.8002 2024-10-27 00:00:00.0 1.6508 243
145 1090.3013 2024-10-28 00:00:00.0 2.5011 243
146 1090.6482 2024-10-29 00:00:00.0 0.3469 243
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '243') 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 1091
10/28/2024 3 1090
10/27/2024 2 1088
10/26/2024 0 1086
10/25/2024 0 1086
10/24/2024 1 1085
10/23/2024 2 1085
10/22/2024 3 1083
10/21/2024 5 1080
10/20/2024 6 1075
10/19/2024 2 1069
10/18/2024 2 1068
10/17/2024 5 1066
10/16/2024 3 1060
10/15/2024 0 1057
10/14/2024 0 1057
10/13/2024 1 1057
10/12/2024 2 1056
10/11/2024 3 1053
10/10/2024 7 1051
10/9/2024 7 1043
10/8/2024 5 1036
10/7/2024 4 1031
10/6/2024 3 1028
10/5/2024 3 1025
10/4/2024 3 1021
10/3/2024 9 1018
10/2/2024 9 1009
10/1/2024 9 1000
9/30/2024 9 991
9/29/2024 9 982
9/28/2024 9 973
9/27/2024 9 965
9/26/2024 9 956
9/25/2024 9 947
9/24/2024 9 938
9/23/2024 9 929
9/22/2024 9 920
9/21/2024 9 911
9/20/2024 9 902
9/19/2024 9 893
9/18/2024 9 884
9/17/2024 9 875
9/16/2024 9 866
9/15/2024 8 857
9/14/2024 8 849
9/13/2024 9 840
9/12/2024 8 831
9/11/2024 7 823
9/10/2024 9 816
9/9/2024 7 807
9/8/2024 7 799
9/7/2024 6 792
9/6/2024 6 786
9/5/2024 7 781
9/4/2024 9 773
9/3/2024 8 764
9/2/2024 8 756
9/1/2024 6 748
8/31/2024 8 742
8/30/2024 8 734
8/29/2024 8 726
8/28/2024 8 717
8/27/2024 7 710
8/26/2024 8 703
8/25/2024 7 694
8/24/2024 8 687
8/23/2024 8 680
8/22/2024 9 671
8/21/2024 9 662
8/20/2024 8 653
8/19/2024 8 645
8/18/2024 8 637
8/17/2024 9 629
8/16/2024 9 620
8/15/2024 10 611
8/14/2024 9 601
8/13/2024 8 592
8/12/2024 8 583
8/11/2024 7 576
8/10/2024 7 568
8/9/2024 7 562
8/8/2024 7 555
8/7/2024 8 548
8/6/2024 7 540
8/5/2024 9 533
8/4/2024 7 525
8/3/2024 9 517
8/2/2024 8 508
8/1/2024 7 500
7/31/2024 8 492
7/30/2024 8 484
7/29/2024 8 476
7/28/2024 9 468
7/27/2024 8 458
7/26/2024 8 450
7/25/2024 9 442
7/24/2024 9 433
7/23/2024 10 424
7/22/2024 9 415
7/21/2024 9 406
7/20/2024 8 397
7/19/2024 9 389
7/18/2024 8 381
7/17/2024 7 372
7/16/2024 8 365
7/15/2024 9 357
7/14/2024 9 347
7/13/2024 9 338
7/12/2024 7 330
7/11/2024 7 323
7/10/2024 8 316
7/9/2024 8 307
7/8/2024 9 299
7/7/2024 9 291
7/6/2024 9 282
7/5/2024 9 273
7/4/2024 9 264
7/3/2024 9 256
7/2/2024 9 247
7/1/2024 9 237
6/30/2024 6 229
6/29/2024 7 222
6/28/2024 7 215
6/27/2024 7 209
6/26/2024 8 201
6/25/2024 9 193
6/24/2024 8 184
6/23/2024 9 177
6/22/2024 9 168
6/21/2024 9 159
6/20/2024 9 151
6/19/2024 8 142
6/18/2024 7 134
6/17/2024 7 128
6/16/2024 9 121
6/15/2024 8 112
6/14/2024 7 104
6/13/2024 8 97
6/12/2024 9 89
6/11/2024 9 80
6/10/2024 6 72
6/9/2024 6 66
6/8/2024 6 60
6/7/2024 6 53