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 48.0330 2024-06-06 00:00:00.0 6.9737 524
2 55.2589 2024-06-07 00:00:00.0 7.2259 524
3 62.3852 2024-06-08 00:00:00.0 7.1263 524
4 67.3489 2024-06-09 00:00:00.0 4.9637 524
5 72.3126 2024-06-10 00:00:00.0 4.9637 524
6 81.1695 2024-06-11 00:00:00.0 8.8569 524
7 89.6797 2024-06-12 00:00:00.0 8.5102 524
8 97.9295 2024-06-13 00:00:00.0 8.2498 524
9 105.5789 2024-06-14 00:00:00.0 7.6494 524
10 113.7917 2024-06-15 00:00:00.0 8.2128 524
11 123.1386 2024-06-16 00:00:00.0 9.3469 524
12 129.8424 2024-06-17 00:00:00.0 6.7038 524
13 136.3274 2024-06-18 00:00:00.0 6.4850 524
14 143.1726 2024-06-19 00:00:00.0 6.8452 524
15 150.7792 2024-06-20 00:00:00.0 7.6066 524
16 159.0004 2024-06-21 00:00:00.0 8.2212 524
17 167.7404 2024-06-22 00:00:00.0 8.7400 524
18 176.4046 2024-06-23 00:00:00.0 8.6642 524
19 184.0102 2024-06-24 00:00:00.0 7.6056 524
20 193.2677 2024-06-25 00:00:00.0 9.2575 524
21 201.6759 2024-06-26 00:00:00.0 8.4082 524
22 208.0025 2024-06-27 00:00:00.0 6.3266 524
23 215.0004 2024-06-28 00:00:00.0 6.9979 524
24 221.5790 2024-06-29 00:00:00.0 6.5786 524
25 227.7606 2024-06-30 00:00:00.0 6.1816 524
26 236.2375 2024-07-01 00:00:00.0 8.4769 524
27 245.7523 2024-07-02 00:00:00.0 9.5148 524
28 254.8338 2024-07-03 00:00:00.0 9.0815 524
29 263.9512 2024-07-04 00:00:00.0 9.1174 524
30 272.9761 2024-07-05 00:00:00.0 9.0249 524
31 281.8344 2024-07-06 00:00:00.0 8.8583 524
32 290.3001 2024-07-07 00:00:00.0 8.4657 524
33 298.9463 2024-07-08 00:00:00.0 8.6462 524
34 307.3693 2024-07-09 00:00:00.0 8.4230 524
35 315.6833 2024-07-10 00:00:00.0 8.3140 524
36 323.3175 2024-07-11 00:00:00.0 7.6342 524
37 330.6297 2024-07-12 00:00:00.0 7.3122 524
38 337.9631 2024-07-13 00:00:00.0 7.3334 524
39 346.5286 2024-07-14 00:00:00.0 8.5655 524
40 355.6566 2024-07-15 00:00:00.0 9.1280 524
41 363.4948 2024-07-16 00:00:00.0 7.8382 524
42 370.3239 2024-07-17 00:00:00.0 6.8291 524
43 377.6851 2024-07-18 00:00:00.0 7.3612 524
44 385.5546 2024-07-19 00:00:00.0 7.8695 524
45 393.5523 2024-07-20 00:00:00.0 7.9977 524
46 402.0331 2024-07-21 00:00:00.0 8.4808 524
47 411.2736 2024-07-22 00:00:00.0 9.2405 524
48 420.7367 2024-07-23 00:00:00.0 9.4631 524
49 429.3118 2024-07-24 00:00:00.0 8.5751 524
50 437.6667 2024-07-25 00:00:00.0 8.3549 524
51 445.0103 2024-07-26 00:00:00.0 7.3436 524
52 452.6344 2024-07-27 00:00:00.0 7.6241 524
53 461.3061 2024-07-28 00:00:00.0 8.6717 524
54 469.4894 2024-07-29 00:00:00.0 8.1833 524
55 476.8844 2024-07-30 00:00:00.0 7.3950 524
56 485.0762 2024-07-31 00:00:00.0 8.1918 524
57 491.6870 2024-08-01 00:00:00.0 6.6108 524
58 499.6019 2024-08-02 00:00:00.0 7.9149 524
59 507.9574 2024-08-03 00:00:00.0 8.3555 524
60 514.6098 2024-08-04 00:00:00.0 6.6524 524
61 522.6339 2024-08-05 00:00:00.0 8.0241 524
62 528.9628 2024-08-06 00:00:00.0 6.3289 524
63 537.0898 2024-08-07 00:00:00.0 8.1270 524
64 543.8762 2024-08-08 00:00:00.0 6.7864 524
65 551.1569 2024-08-09 00:00:00.0 7.2807 524
66 557.6037 2024-08-10 00:00:00.0 6.4468 524
67 565.3701 2024-08-11 00:00:00.0 7.7664 524
68 573.0187 2024-08-12 00:00:00.0 7.6486 524
69 580.4519 2024-08-13 00:00:00.0 7.4332 524
70 589.3875 2024-08-14 00:00:00.0 8.9356 524
71 599.1173 2024-08-15 00:00:00.0 9.7298 524
72 608.7101 2024-08-16 00:00:00.0 9.5928 524
73 617.3716 2024-08-17 00:00:00.0 8.6615 524
74 625.5122 2024-08-18 00:00:00.0 8.1406 524
75 633.2682 2024-08-19 00:00:00.0 7.7560 524
76 641.0273 2024-08-20 00:00:00.0 7.7591 524
77 649.6484 2024-08-21 00:00:00.0 8.6211 524
78 658.6694 2024-08-22 00:00:00.0 9.0210 524
79 666.9510 2024-08-23 00:00:00.0 8.2816 524
80 674.2308 2024-08-24 00:00:00.0 7.2798 524
81 681.2707 2024-08-25 00:00:00.0 7.0399 524
82 688.9756 2024-08-26 00:00:00.0 7.7049 524
83 695.1125 2024-08-27 00:00:00.0 6.1369 524
84 701.4537 2024-08-28 00:00:00.0 6.3412 524
85 710.2687 2024-08-29 00:00:00.0 8.8150 524
86 719.0097 2024-08-30 00:00:00.0 8.7410 524
87 727.2302 2024-08-31 00:00:00.0 8.2205 524
88 734.4351 2024-09-01 00:00:00.0 7.2049 524
89 741.2563 2024-09-02 00:00:00.0 6.8212 524
90 748.8147 2024-09-03 00:00:00.0 7.5584 524
91 758.0642 2024-09-04 00:00:00.0 9.2495 524
92 765.5685 2024-09-05 00:00:00.0 7.5043 524
93 771.3126 2024-09-06 00:00:00.0 5.7441 524
94 777.1993 2024-09-07 00:00:00.0 5.8867 524
95 784.5155 2024-09-08 00:00:00.0 7.3162 524
96 790.9021 2024-09-09 00:00:00.0 6.3866 524
97 799.3706 2024-09-10 00:00:00.0 8.4685 524
98 806.7652 2024-09-11 00:00:00.0 7.3946 524
99 813.9014 2024-09-12 00:00:00.0 7.1362 524
100 823.5229 2024-09-13 00:00:00.0 9.6215 524
101 831.4381 2024-09-14 00:00:00.0 7.9152 524
102 839.4827 2024-09-15 00:00:00.0 8.0446 524
103 847.5042 2024-09-16 00:00:00.0 8.0215 524
104 856.7620 2024-09-17 00:00:00.0 9.2578 524
105 866.1043 2024-09-18 00:00:00.0 9.3423 524
106 875.8793 2024-09-19 00:00:00.0 9.7750 524
107 884.3358 2024-09-20 00:00:00.0 8.4565 524
108 890.8661 2024-09-21 00:00:00.0 6.5303 524
109 896.1605 2024-09-22 00:00:00.0 5.2944 524
110 903.5199 2024-09-23 00:00:00.0 7.3594 524
111 911.4303 2024-09-24 00:00:00.0 7.9104 524
112 919.1187 2024-09-25 00:00:00.0 7.6884 524
113 926.5069 2024-09-26 00:00:00.0 7.3882 524
114 933.4745 2024-09-27 00:00:00.0 6.9676 524
115 940.8614 2024-09-28 00:00:00.0 7.3869 524
116 946.8713 2024-09-29 00:00:00.0 6.0099 524
117 954.2873 2024-09-30 00:00:00.0 7.4160 524
118 958.0763 2024-10-01 00:00:00.0 3.7890 524
119 963.7796 2024-10-02 00:00:00.0 5.7033 524
120 965.5123 2024-10-03 00:00:00.0 1.7327 524
121 969.0781 2024-10-04 00:00:00.0 3.5658 524
122 975.0628 2024-10-05 00:00:00.0 5.9847 524
123 978.2780 2024-10-06 00:00:00.0 3.2152 524
124 982.2043 2024-10-07 00:00:00.0 3.9263 524
125 987.4956 2024-10-08 00:00:00.0 5.2913 524
126 994.0310 2024-10-09 00:00:00.0 6.5354 524
127 1000.4236 2024-10-10 00:00:00.0 6.3926 524
128 1003.5954 2024-10-11 00:00:00.0 3.1718 524
129 1006.1525 2024-10-12 00:00:00.0 2.5571 524
130 1007.4603 2024-10-13 00:00:00.0 1.3078 524
131 1007.7919 2024-10-14 00:00:00.0 0.3316 524
132 1008.4168 2024-10-15 00:00:00.0 0.6249 524
133 1011.5624 2024-10-16 00:00:00.0 3.1456 524
134 1016.9454 2024-10-17 00:00:00.0 5.3830 524
135 1019.0023 2024-10-18 00:00:00.0 2.0569 524
136 1020.9447 2024-10-19 00:00:00.0 1.9424 524
137 1026.5420 2024-10-20 00:00:00.0 5.5973 524
138 1030.6371 2024-10-21 00:00:00.0 4.0951 524
139 1032.8780 2024-10-22 00:00:00.0 2.2409 524
140 1035.1128 2024-10-23 00:00:00.0 2.2348 524
141 1035.7872 2024-10-24 00:00:00.0 0.6744 524
142 1036.4526 2024-10-25 00:00:00.0 0.6654 524
143 1036.8592 2024-10-26 00:00:00.0 0.4066 524
144 1038.0311 2024-10-27 00:00:00.0 1.1719 524
145 1040.7526 2024-10-28 00:00:00.0 2.7215 524
146 1041.5791 2024-10-29 00:00:00.0 0.8265 524
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '524') 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 1 1042
10/28/2024 3 1041
10/27/2024 1 1038
10/26/2024 0 1037
10/25/2024 1 1036
10/24/2024 1 1036
10/23/2024 2 1035
10/22/2024 2 1033
10/21/2024 4 1031
10/20/2024 6 1027
10/19/2024 2 1021
10/18/2024 2 1019
10/17/2024 5 1017
10/16/2024 3 1012
10/15/2024 1 1008
10/14/2024 0 1008
10/13/2024 1 1007
10/12/2024 3 1006
10/11/2024 3 1004
10/10/2024 6 1000
10/9/2024 7 994
10/8/2024 5 987
10/7/2024 4 982
10/6/2024 3 978
10/5/2024 6 975
10/4/2024 4 969
10/3/2024 2 966
10/2/2024 6 964
10/1/2024 4 958
9/30/2024 7 954
9/29/2024 6 947
9/28/2024 7 941
9/27/2024 7 933
9/26/2024 7 927
9/25/2024 8 919
9/24/2024 8 911
9/23/2024 7 904
9/22/2024 5 896
9/21/2024 7 891
9/20/2024 8 884
9/19/2024 10 876
9/18/2024 9 866
9/17/2024 9 857
9/16/2024 8 848
9/15/2024 8 839
9/14/2024 8 831
9/13/2024 10 824
9/12/2024 7 814
9/11/2024 7 807
9/10/2024 8 799
9/9/2024 6 791
9/8/2024 7 785
9/7/2024 6 777
9/6/2024 6 771
9/5/2024 8 766
9/4/2024 9 758
9/3/2024 8 749
9/2/2024 7 741
9/1/2024 7 734
8/31/2024 8 727
8/30/2024 9 719
8/29/2024 9 710
8/28/2024 6 701
8/27/2024 6 695
8/26/2024 8 689
8/25/2024 7 681
8/24/2024 7 674
8/23/2024 8 667
8/22/2024 9 659
8/21/2024 9 650
8/20/2024 8 641
8/19/2024 8 633
8/18/2024 8 626
8/17/2024 9 617
8/16/2024 10 609
8/15/2024 10 599
8/14/2024 9 589
8/13/2024 7 580
8/12/2024 8 573
8/11/2024 8 565
8/10/2024 6 558
8/9/2024 7 551
8/8/2024 7 544
8/7/2024 8 537
8/6/2024 6 529
8/5/2024 8 523
8/4/2024 7 515
8/3/2024 8 508
8/2/2024 8 500
8/1/2024 7 492
7/31/2024 8 485
7/30/2024 7 477
7/29/2024 8 469
7/28/2024 9 461
7/27/2024 8 453
7/26/2024 7 445
7/25/2024 8 438
7/24/2024 9 429
7/23/2024 9 421
7/22/2024 9 411
7/21/2024 8 402
7/20/2024 8 394
7/19/2024 8 386
7/18/2024 7 378
7/17/2024 7 370
7/16/2024 8 363
7/15/2024 9 356
7/14/2024 9 347
7/13/2024 7 338
7/12/2024 7 331
7/11/2024 8 323
7/10/2024 8 316
7/9/2024 8 307
7/8/2024 9 299
7/7/2024 8 290
7/6/2024 9 282
7/5/2024 9 273
7/4/2024 9 264
7/3/2024 9 255
7/2/2024 10 246
7/1/2024 8 236
6/30/2024 6 228
6/29/2024 7 222
6/28/2024 7 215
6/27/2024 6 208
6/26/2024 8 202
6/25/2024 9 193
6/24/2024 8 184
6/23/2024 9 176
6/22/2024 9 168
6/21/2024 8 159
6/20/2024 8 151
6/19/2024 7 143
6/18/2024 6 136
6/17/2024 7 130
6/16/2024 9 123
6/15/2024 8 114
6/14/2024 8 106
6/13/2024 8 98
6/12/2024 9 90
6/11/2024 9 81
6/10/2024 5 72
6/9/2024 5 67
6/8/2024 7 62
6/7/2024 7 55