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.5194 2024-06-06 00:00:00.0 7.8542 533
2 55.3304 2024-06-07 00:00:00.0 6.8110 533
3 61.4027 2024-06-08 00:00:00.0 6.0723 533
4 65.8204 2024-06-09 00:00:00.0 4.4177 533
5 71.3355 2024-06-10 00:00:00.0 5.5151 533
6 80.1535 2024-06-11 00:00:00.0 8.8180 533
7 87.8862 2024-06-12 00:00:00.0 7.7327 533
8 95.9431 2024-06-13 00:00:00.0 8.0569 533
9 104.1936 2024-06-14 00:00:00.0 8.2505 533
10 112.6313 2024-06-15 00:00:00.0 8.4377 533
11 121.6616 2024-06-16 00:00:00.0 9.0303 533
12 127.7906 2024-06-17 00:00:00.0 6.1290 533
13 134.1341 2024-06-18 00:00:00.0 6.3435 533
14 140.7624 2024-06-19 00:00:00.0 6.6283 533
15 149.3832 2024-06-20 00:00:00.0 8.6208 533
16 157.8658 2024-06-21 00:00:00.0 8.4826 533
17 166.8872 2024-06-22 00:00:00.0 9.0214 533
18 175.6745 2024-06-23 00:00:00.0 8.7873 533
19 184.0936 2024-06-24 00:00:00.0 8.4191 533
20 192.9641 2024-06-25 00:00:00.0 8.8705 533
21 200.3067 2024-06-26 00:00:00.0 7.3426 533
22 208.0181 2024-06-27 00:00:00.0 7.7114 533
23 214.4526 2024-06-28 00:00:00.0 6.4345 533
24 220.4111 2024-06-29 00:00:00.0 5.9585 533
25 227.4580 2024-06-30 00:00:00.0 7.0469 533
26 236.4050 2024-07-01 00:00:00.0 8.9470 533
27 245.7733 2024-07-02 00:00:00.0 9.3683 533
28 254.6566 2024-07-03 00:00:00.0 8.8833 533
29 263.8330 2024-07-04 00:00:00.0 9.1764 533
30 272.2496 2024-07-05 00:00:00.0 8.4166 533
31 281.0047 2024-07-06 00:00:00.0 8.7551 533
32 289.8630 2024-07-07 00:00:00.0 8.8583 533
33 298.7404 2024-07-08 00:00:00.0 8.8774 533
34 307.0888 2024-07-09 00:00:00.0 8.3484 533
35 315.0938 2024-07-10 00:00:00.0 8.0050 533
36 321.2694 2024-07-11 00:00:00.0 6.1756 533
37 328.1307 2024-07-12 00:00:00.0 6.8613 533
38 337.1761 2024-07-13 00:00:00.0 9.0454 533
39 345.8546 2024-07-14 00:00:00.0 8.6785 533
40 354.7494 2024-07-15 00:00:00.0 8.8948 533
41 362.8448 2024-07-16 00:00:00.0 8.0954 533
42 369.9464 2024-07-17 00:00:00.0 7.1016 533
43 378.3546 2024-07-18 00:00:00.0 8.4082 533
44 385.9863 2024-07-19 00:00:00.0 7.6317 533
45 394.4065 2024-07-20 00:00:00.0 8.4202 533
46 402.8128 2024-07-21 00:00:00.0 8.4063 533
47 412.1185 2024-07-22 00:00:00.0 9.3057 533
48 421.7724 2024-07-23 00:00:00.0 9.6539 533
49 430.7372 2024-07-24 00:00:00.0 8.9648 533
50 438.3100 2024-07-25 00:00:00.0 7.5728 533
51 446.5857 2024-07-26 00:00:00.0 8.2757 533
52 454.1987 2024-07-27 00:00:00.0 7.6130 533
53 463.2236 2024-07-28 00:00:00.0 9.0249 533
54 471.4127 2024-07-29 00:00:00.0 8.1891 533
55 478.3579 2024-07-30 00:00:00.0 6.9452 533
56 486.7088 2024-07-31 00:00:00.0 8.3509 533
57 493.6712 2024-08-01 00:00:00.0 6.9624 533
58 501.9014 2024-08-02 00:00:00.0 8.2302 533
59 510.7827 2024-08-03 00:00:00.0 8.8813 533
60 517.9109 2024-08-04 00:00:00.0 7.1282 533
61 526.1560 2024-08-05 00:00:00.0 8.2451 533
62 534.2108 2024-08-06 00:00:00.0 8.0548 533
63 541.1698 2024-08-07 00:00:00.0 6.9590 533
64 547.8543 2024-08-08 00:00:00.0 6.6845 533
65 555.5284 2024-08-09 00:00:00.0 7.6741 533
66 562.4048 2024-08-10 00:00:00.0 6.8764 533
67 570.1397 2024-08-11 00:00:00.0 7.7349 533
68 578.2106 2024-08-12 00:00:00.0 8.0709 533
69 586.9556 2024-08-13 00:00:00.0 8.7450 533
70 596.3724 2024-08-14 00:00:00.0 9.4168 533
71 606.1778 2024-08-15 00:00:00.0 9.8054 533
72 615.5332 2024-08-16 00:00:00.0 9.3554 533
73 624.1821 2024-08-17 00:00:00.0 8.6489 533
74 632.3618 2024-08-18 00:00:00.0 8.1797 533
75 640.6245 2024-08-19 00:00:00.0 8.2627 533
76 648.6650 2024-08-20 00:00:00.0 8.0405 533
77 657.5069 2024-08-21 00:00:00.0 8.8419 533
78 666.8811 2024-08-22 00:00:00.0 9.3742 533
79 676.2194 2024-08-23 00:00:00.0 9.3383 533
80 683.8202 2024-08-24 00:00:00.0 7.6008 533
81 691.9704 2024-08-25 00:00:00.0 8.1502 533
82 699.6908 2024-08-26 00:00:00.0 7.7204 533
83 706.2869 2024-08-27 00:00:00.0 6.5961 533
84 712.3154 2024-08-28 00:00:00.0 6.0285 533
85 721.0272 2024-08-29 00:00:00.0 8.7118 533
86 729.8158 2024-08-30 00:00:00.0 8.7886 533
87 738.2099 2024-08-31 00:00:00.0 8.3941 533
88 744.8696 2024-09-01 00:00:00.0 6.6597 533
89 752.8127 2024-09-02 00:00:00.0 7.9431 533
90 760.8715 2024-09-03 00:00:00.0 8.0588 533
91 769.6970 2024-09-04 00:00:00.0 8.8255 533
92 776.3395 2024-09-05 00:00:00.0 6.6425 533
93 781.6524 2024-09-06 00:00:00.0 5.3129 533
94 788.2769 2024-09-07 00:00:00.0 6.6245 533
95 795.5168 2024-09-08 00:00:00.0 7.2399 533
96 802.9298 2024-09-09 00:00:00.0 7.4130 533
97 810.4361 2024-09-10 00:00:00.0 7.5063 533
98 817.2100 2024-09-11 00:00:00.0 6.7739 533
99 825.4785 2024-09-12 00:00:00.0 8.2685 533
100 835.0771 2024-09-13 00:00:00.0 9.5986 533
101 843.4600 2024-09-14 00:00:00.0 8.3829 533
102 851.6032 2024-09-15 00:00:00.0 8.1432 533
103 859.8066 2024-09-16 00:00:00.0 8.2034 533
104 868.8540 2024-09-17 00:00:00.0 9.0474 533
105 877.9951 2024-09-18 00:00:00.0 9.1411 533
106 887.2734 2024-09-19 00:00:00.0 9.2783 533
107 895.3866 2024-09-20 00:00:00.0 8.1132 533
108 901.3451 2024-09-21 00:00:00.0 5.9585 533
109 905.9997 2024-09-22 00:00:00.0 4.6546 533
110 913.7224 2024-09-23 00:00:00.0 7.7227 533
111 922.0826 2024-09-24 00:00:00.0 8.3602 533
112 930.0616 2024-09-25 00:00:00.0 7.9790 533
113 937.1896 2024-09-26 00:00:00.0 7.1280 533
114 943.9934 2024-09-27 00:00:00.0 6.8038 533
115 951.2827 2024-09-28 00:00:00.0 7.2893 533
116 957.2658 2024-09-29 00:00:00.0 5.9831 533
117 964.9449 2024-09-30 00:00:00.0 7.6791 533
118 968.9257 2024-10-01 00:00:00.0 3.9808 533
119 973.2734 2024-10-02 00:00:00.0 4.3477 533
120 974.2019 2024-10-03 00:00:00.0 0.9285 533
121 977.1039 2024-10-04 00:00:00.0 2.9020 533
122 981.5148 2024-10-05 00:00:00.0 4.4109 533
123 984.2607 2024-10-06 00:00:00.0 2.7459 533
124 988.4122 2024-10-07 00:00:00.0 4.1515 533
125 993.8706 2024-10-08 00:00:00.0 5.4584 533
126 999.7487 2024-10-09 00:00:00.0 5.8781 533
127 1007.1043 2024-10-10 00:00:00.0 7.3556 533
128 1010.4458 2024-10-11 00:00:00.0 3.3415 533
129 1012.5027 2024-10-12 00:00:00.0 2.0569 533
130 1013.6361 2024-10-13 00:00:00.0 1.1334 533
131 1013.7410 2024-10-14 00:00:00.0 0.1049 533
132 1014.4275 2024-10-15 00:00:00.0 0.6865 533
133 1019.0213 2024-10-16 00:00:00.0 4.5938 533
134 1022.9355 2024-10-17 00:00:00.0 3.9142 533
135 1024.7323 2024-10-18 00:00:00.0 1.7968 533
136 1027.4284 2024-10-19 00:00:00.0 2.6961 533
137 1033.5545 2024-10-20 00:00:00.0 6.1261 533
138 1038.1109 2024-10-21 00:00:00.0 4.5564 533
139 1040.1145 2024-10-22 00:00:00.0 2.0036 533
140 1042.2175 2024-10-23 00:00:00.0 2.1030 533
141 1042.8919 2024-10-24 00:00:00.0 0.6744 533
142 1043.3702 2024-10-25 00:00:00.0 0.4783 533
143 1043.9171 2024-10-26 00:00:00.0 0.5469 533
144 1044.4505 2024-10-27 00:00:00.0 0.5334 533
145 1047.5577 2024-10-28 00:00:00.0 3.1072 533
146 1047.6965 2024-10-29 00:00:00.0 0.1388 533
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '533') 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 1048
10/28/2024 3 1048
10/27/2024 1 1044
10/26/2024 1 1044
10/25/2024 0 1043
10/24/2024 1 1043
10/23/2024 2 1042
10/22/2024 2 1040
10/21/2024 5 1038
10/20/2024 6 1034
10/19/2024 3 1027
10/18/2024 2 1025
10/17/2024 4 1023
10/16/2024 5 1019
10/15/2024 1 1014
10/14/2024 0 1014
10/13/2024 1 1014
10/12/2024 2 1013
10/11/2024 3 1010
10/10/2024 7 1007
10/9/2024 6 1000
10/8/2024 5 994
10/7/2024 4 988
10/6/2024 3 984
10/5/2024 4 982
10/4/2024 3 977
10/3/2024 1 974
10/2/2024 4 973
10/1/2024 4 969
9/30/2024 8 965
9/29/2024 6 957
9/28/2024 7 951
9/27/2024 7 944
9/26/2024 7 937
9/25/2024 8 930
9/24/2024 8 922
9/23/2024 8 914
9/22/2024 5 906
9/21/2024 6 901
9/20/2024 8 895
9/19/2024 9 887
9/18/2024 9 878
9/17/2024 9 869
9/16/2024 8 860
9/15/2024 8 852
9/14/2024 8 843
9/13/2024 10 835
9/12/2024 8 825
9/11/2024 7 817
9/10/2024 8 810
9/9/2024 7 803
9/8/2024 7 796
9/7/2024 7 788
9/6/2024 5 782
9/5/2024 7 776
9/4/2024 9 770
9/3/2024 8 761
9/2/2024 8 753
9/1/2024 7 745
8/31/2024 8 738
8/30/2024 9 730
8/29/2024 9 721
8/28/2024 6 712
8/27/2024 7 706
8/26/2024 8 700
8/25/2024 8 692
8/24/2024 8 684
8/23/2024 9 676
8/22/2024 9 667
8/21/2024 9 658
8/20/2024 8 649
8/19/2024 8 641
8/18/2024 8 632
8/17/2024 9 624
8/16/2024 9 616
8/15/2024 10 606
8/14/2024 9 596
8/13/2024 9 587
8/12/2024 8 578
8/11/2024 8 570
8/10/2024 7 562
8/9/2024 8 556
8/8/2024 7 548
8/7/2024 7 541
8/6/2024 8 534
8/5/2024 8 526
8/4/2024 7 518
8/3/2024 9 511
8/2/2024 8 502
8/1/2024 7 494
7/31/2024 8 487
7/30/2024 7 478
7/29/2024 8 471
7/28/2024 9 463
7/27/2024 8 454
7/26/2024 8 447
7/25/2024 8 438
7/24/2024 9 431
7/23/2024 10 422
7/22/2024 9 412
7/21/2024 8 403
7/20/2024 8 394
7/19/2024 8 386
7/18/2024 8 378
7/17/2024 7 370
7/16/2024 8 363
7/15/2024 9 355
7/14/2024 9 346
7/13/2024 9 337
7/12/2024 7 328
7/11/2024 6 321
7/10/2024 8 315
7/9/2024 8 307
7/8/2024 9 299
7/7/2024 9 290
7/6/2024 9 281
7/5/2024 8 272
7/4/2024 9 264
7/3/2024 9 255
7/2/2024 9 246
7/1/2024 9 236
6/30/2024 7 227
6/29/2024 6 220
6/28/2024 6 214
6/27/2024 8 208
6/26/2024 7 200
6/25/2024 9 193
6/24/2024 8 184
6/23/2024 9 176
6/22/2024 9 167
6/21/2024 8 158
6/20/2024 9 149
6/19/2024 7 141
6/18/2024 6 134
6/17/2024 6 128
6/16/2024 9 122
6/15/2024 8 113
6/14/2024 8 104
6/13/2024 8 96
6/12/2024 8 88
6/11/2024 9 80
6/10/2024 6 71
6/9/2024 4 66
6/8/2024 6 61
6/7/2024 7 55