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 50.4994 2024-06-06 00:00:00.0 7.3798 230
2 57.6590 2024-06-07 00:00:00.0 7.1596 230
3 64.8744 2024-06-08 00:00:00.0 7.2154 230
4 70.1599 2024-06-09 00:00:00.0 5.2855 230
5 75.2733 2024-06-10 00:00:00.0 5.1134 230
6 84.2728 2024-06-11 00:00:00.0 8.9995 230
7 91.7246 2024-06-12 00:00:00.0 7.4518 230
8 99.7592 2024-06-13 00:00:00.0 8.0346 230
9 107.4788 2024-06-14 00:00:00.0 7.7196 230
10 115.7494 2024-06-15 00:00:00.0 8.2706 230
11 125.1830 2024-06-16 00:00:00.0 9.4336 230
12 132.4856 2024-06-17 00:00:00.0 7.3026 230
13 138.8869 2024-06-18 00:00:00.0 6.4013 230
14 146.0840 2024-06-19 00:00:00.0 7.1971 230
15 154.1281 2024-06-20 00:00:00.0 8.0441 230
16 162.5590 2024-06-21 00:00:00.0 8.4309 230
17 171.2744 2024-06-22 00:00:00.0 8.7154 230
18 179.7951 2024-06-23 00:00:00.0 8.5207 230
19 187.3717 2024-06-24 00:00:00.0 7.5766 230
20 196.5915 2024-06-25 00:00:00.0 9.2198 230
21 204.7753 2024-06-26 00:00:00.0 8.1838 230
22 211.8657 2024-06-27 00:00:00.0 7.0904 230
23 219.0640 2024-06-28 00:00:00.0 7.1983 230
24 225.6160 2024-06-29 00:00:00.0 6.5520 230
25 231.4347 2024-06-30 00:00:00.0 5.8187 230
26 239.7996 2024-07-01 00:00:00.0 8.3649 230
27 249.2381 2024-07-02 00:00:00.0 9.4385 230
28 258.4252 2024-07-03 00:00:00.0 9.1871 230
29 267.2835 2024-07-04 00:00:00.0 8.8583 230
30 276.0886 2024-07-05 00:00:00.0 8.8051 230
31 284.9944 2024-07-06 00:00:00.0 8.9058 230
32 293.2629 2024-07-07 00:00:00.0 8.2685 230
33 301.5913 2024-07-08 00:00:00.0 8.3284 230
34 308.8551 2024-07-09 00:00:00.0 7.2638 230
35 316.2825 2024-07-10 00:00:00.0 7.4274 230
36 323.8362 2024-07-11 00:00:00.0 7.5537 230
37 330.0609 2024-07-12 00:00:00.0 6.2247 230
38 337.6462 2024-07-13 00:00:00.0 7.5853 230
39 345.7966 2024-07-14 00:00:00.0 8.1504 230
40 354.9368 2024-07-15 00:00:00.0 9.1402 230
41 363.1904 2024-07-16 00:00:00.0 8.2536 230
42 370.2381 2024-07-17 00:00:00.0 7.0477 230
43 377.5650 2024-07-18 00:00:00.0 7.3269 230
44 385.1759 2024-07-19 00:00:00.0 7.6109 230
45 392.0261 2024-07-20 00:00:00.0 6.8502 230
46 399.9115 2024-07-21 00:00:00.0 7.8854 230
47 408.1006 2024-07-22 00:00:00.0 8.1891 230
48 417.2645 2024-07-23 00:00:00.0 9.1639 230
49 426.1998 2024-07-24 00:00:00.0 8.9353 230
50 434.3251 2024-07-25 00:00:00.0 8.1253 230
51 441.2193 2024-07-26 00:00:00.0 6.8942 230
52 448.7609 2024-07-27 00:00:00.0 7.5416 230
53 457.6802 2024-07-28 00:00:00.0 8.9193 230
54 465.3109 2024-07-29 00:00:00.0 7.6307 230
55 472.5357 2024-07-30 00:00:00.0 7.2248 230
56 480.3027 2024-07-31 00:00:00.0 7.7670 230
57 487.1259 2024-08-01 00:00:00.0 6.8232 230
58 494.1466 2024-08-02 00:00:00.0 7.0207 230
59 503.1680 2024-08-03 00:00:00.0 9.0214 230
60 510.2682 2024-08-04 00:00:00.0 7.1002 230
61 518.2510 2024-08-05 00:00:00.0 7.9828 230
62 524.8645 2024-08-06 00:00:00.0 6.6135 230
63 532.8735 2024-08-07 00:00:00.0 8.0090 230
64 539.4275 2024-08-08 00:00:00.0 6.5540 230
65 547.1125 2024-08-09 00:00:00.0 7.6850 230
66 553.6048 2024-08-10 00:00:00.0 6.4923 230
67 560.6294 2024-08-11 00:00:00.0 7.0246 230
68 568.0431 2024-08-12 00:00:00.0 7.4137 230
69 576.3483 2024-08-13 00:00:00.0 8.3052 230
70 585.6440 2024-08-14 00:00:00.0 9.2957 230
71 595.2983 2024-08-15 00:00:00.0 9.6543 230
72 604.9577 2024-08-16 00:00:00.0 9.6594 230
73 612.9716 2024-08-17 00:00:00.0 8.0139 230
74 620.5186 2024-08-18 00:00:00.0 7.5470 230
75 628.0837 2024-08-19 00:00:00.0 7.5651 230
76 636.4840 2024-08-20 00:00:00.0 8.4003 230
77 645.4528 2024-08-21 00:00:00.0 8.9688 230
78 653.1655 2024-08-22 00:00:00.0 7.7127 230
79 660.5183 2024-08-23 00:00:00.0 7.3528 230
80 668.1537 2024-08-24 00:00:00.0 7.6354 230
81 674.8217 2024-08-25 00:00:00.0 6.6680 230
82 683.0891 2024-08-26 00:00:00.0 8.2674 230
83 690.7666 2024-08-27 00:00:00.0 7.6775 230
84 697.2420 2024-08-28 00:00:00.0 6.4754 230
85 706.1074 2024-08-29 00:00:00.0 8.8654 230
86 714.8405 2024-08-30 00:00:00.0 8.7331 230
87 723.4163 2024-08-31 00:00:00.0 8.5758 230
88 730.5280 2024-09-01 00:00:00.0 7.1117 230
89 738.0836 2024-09-02 00:00:00.0 7.5556 230
90 745.5025 2024-09-03 00:00:00.0 7.4189 230
91 755.0370 2024-09-04 00:00:00.0 9.5345 230
92 762.9223 2024-09-05 00:00:00.0 7.8853 230
93 769.2426 2024-09-06 00:00:00.0 6.3203 230
94 775.2779 2024-09-07 00:00:00.0 6.0353 230
95 781.6896 2024-09-08 00:00:00.0 6.4117 230
96 789.4137 2024-09-09 00:00:00.0 7.7241 230
97 796.6918 2024-09-10 00:00:00.0 7.2781 230
98 804.9581 2024-09-11 00:00:00.0 8.2663 230
99 812.3406 2024-09-12 00:00:00.0 7.3825 230
100 821.9756 2024-09-13 00:00:00.0 9.6350 230
101 830.5804 2024-09-14 00:00:00.0 8.6048 230
102 837.1212 2024-09-15 00:00:00.0 6.5408 230
103 845.4289 2024-09-16 00:00:00.0 8.3077 230
104 855.0130 2024-09-17 00:00:00.0 9.5841 230
105 864.3202 2024-09-18 00:00:00.0 9.3072 230
106 874.0055 2024-09-19 00:00:00.0 9.6853 230
107 882.5993 2024-09-20 00:00:00.0 8.5938 230
108 890.1093 2024-09-21 00:00:00.0 7.5100 230
109 895.9222 2024-09-22 00:00:00.0 5.8129 230
110 903.2626 2024-09-23 00:00:00.0 7.3404 230
111 911.7278 2024-09-24 00:00:00.0 8.4652 230
112 919.1733 2024-09-25 00:00:00.0 7.4455 230
113 926.6069 2024-09-26 00:00:00.0 7.4336 230
114 934.1590 2024-09-27 00:00:00.0 7.5521 230
115 941.8453 2024-09-28 00:00:00.0 7.6863 230
116 948.1029 2024-09-29 00:00:00.0 6.2576 230
117 955.9538 2024-09-30 00:00:00.0 7.8509 230
118 960.4819 2024-10-01 00:00:00.0 4.5281 230
119 965.8258 2024-10-02 00:00:00.0 5.3439 230
120 968.1100 2024-10-03 00:00:00.0 2.2842 230
121 972.1176 2024-10-04 00:00:00.0 4.0076 230
122 977.7209 2024-10-05 00:00:00.0 5.6033 230
123 981.2619 2024-10-06 00:00:00.0 3.5410 230
124 987.0118 2024-10-07 00:00:00.0 5.7499 230
125 992.4969 2024-10-08 00:00:00.0 5.4851 230
126 998.8234 2024-10-09 00:00:00.0 6.3265 230
127 1005.6552 2024-10-10 00:00:00.0 6.8318 230
128 1009.8598 2024-10-11 00:00:00.0 4.2046 230
129 1013.4401 2024-10-12 00:00:00.0 3.5803 230
130 1014.4075 2024-10-13 00:00:00.0 0.9674 230
131 1015.0450 2024-10-14 00:00:00.0 0.6375 230
132 1015.8011 2024-10-15 00:00:00.0 0.7561 230
133 1019.2317 2024-10-16 00:00:00.0 3.4306 230
134 1024.8430 2024-10-17 00:00:00.0 5.6113 230
135 1026.8695 2024-10-18 00:00:00.0 2.0265 230
136 1029.1702 2024-10-19 00:00:00.0 2.3007 230
137 1035.7127 2024-10-20 00:00:00.0 6.5425 230
138 1040.5341 2024-10-21 00:00:00.0 4.8214 230
139 1043.9615 2024-10-22 00:00:00.0 3.4274 230
140 1046.5534 2024-10-23 00:00:00.0 2.5919 230
141 1048.3290 2024-10-24 00:00:00.0 1.7756 230
142 1048.9024 2024-10-25 00:00:00.0 0.5734 230
143 1049.5147 2024-10-26 00:00:00.0 0.6123 230
144 1050.5878 2024-10-27 00:00:00.0 1.0731 230
145 1054.5980 2024-10-28 00:00:00.0 4.0102 230
146 1056.0984 2024-10-29 00:00:00.0 1.5004 230
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '230') 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 2 1056
10/28/2024 4 1055
10/27/2024 1 1051
10/26/2024 1 1050
10/25/2024 1 1049
10/24/2024 2 1048
10/23/2024 3 1047
10/22/2024 3 1044
10/21/2024 5 1041
10/20/2024 7 1036
10/19/2024 2 1029
10/18/2024 2 1027
10/17/2024 6 1025
10/16/2024 3 1019
10/15/2024 1 1016
10/14/2024 1 1015
10/13/2024 1 1014
10/12/2024 4 1013
10/11/2024 4 1010
10/10/2024 7 1006
10/9/2024 6 999
10/8/2024 5 992
10/7/2024 6 987
10/6/2024 4 981
10/5/2024 6 978
10/4/2024 4 972
10/3/2024 2 968
10/2/2024 5 966
10/1/2024 5 960
9/30/2024 8 956
9/29/2024 6 948
9/28/2024 8 942
9/27/2024 8 934
9/26/2024 7 927
9/25/2024 7 919
9/24/2024 8 912
9/23/2024 7 903
9/22/2024 6 896
9/21/2024 8 890
9/20/2024 9 883
9/19/2024 10 874
9/18/2024 9 864
9/17/2024 10 855
9/16/2024 8 845
9/15/2024 7 837
9/14/2024 9 831
9/13/2024 10 822
9/12/2024 7 812
9/11/2024 8 805
9/10/2024 7 797
9/9/2024 8 789
9/8/2024 6 782
9/7/2024 6 775
9/6/2024 6 769
9/5/2024 8 763
9/4/2024 10 755
9/3/2024 7 746
9/2/2024 8 738
9/1/2024 7 731
8/31/2024 9 723
8/30/2024 9 715
8/29/2024 9 706
8/28/2024 6 697
8/27/2024 8 691
8/26/2024 8 683
8/25/2024 7 675
8/24/2024 8 668
8/23/2024 7 661
8/22/2024 8 653
8/21/2024 9 645
8/20/2024 8 636
8/19/2024 8 628
8/18/2024 8 621
8/17/2024 8 613
8/16/2024 10 605
8/15/2024 10 595
8/14/2024 9 586
8/13/2024 8 576
8/12/2024 7 568
8/11/2024 7 561
8/10/2024 6 554
8/9/2024 8 547
8/8/2024 7 539
8/7/2024 8 533
8/6/2024 7 525
8/5/2024 8 518
8/4/2024 7 510
8/3/2024 9 503
8/2/2024 7 494
8/1/2024 7 487
7/31/2024 8 480
7/30/2024 7 473
7/29/2024 8 465
7/28/2024 9 458
7/27/2024 8 449
7/26/2024 7 441
7/25/2024 8 434
7/24/2024 9 426
7/23/2024 9 417
7/22/2024 8 408
7/21/2024 8 400
7/20/2024 7 392
7/19/2024 8 385
7/18/2024 7 378
7/17/2024 7 370
7/16/2024 8 363
7/15/2024 9 355
7/14/2024 8 346
7/13/2024 8 338
7/12/2024 6 330
7/11/2024 8 324
7/10/2024 7 316
7/9/2024 7 309
7/8/2024 8 302
7/7/2024 8 293
7/6/2024 9 285
7/5/2024 9 276
7/4/2024 9 267
7/3/2024 9 258
7/2/2024 9 249
7/1/2024 8 240
6/30/2024 6 231
6/29/2024 7 226
6/28/2024 7 219
6/27/2024 7 212
6/26/2024 8 205
6/25/2024 9 197
6/24/2024 8 187
6/23/2024 9 180
6/22/2024 9 171
6/21/2024 8 163
6/20/2024 8 154
6/19/2024 7 146
6/18/2024 6 139
6/17/2024 7 132
6/16/2024 9 125
6/15/2024 8 116
6/14/2024 8 107
6/13/2024 8 100
6/12/2024 7 92
6/11/2024 9 84
6/10/2024 5 75
6/9/2024 5 70
6/8/2024 7 65
6/7/2024 7 58