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.4785 2024-06-06 00:00:00.0 5.1213 203
2 53.8969 2024-06-07 00:00:00.0 6.4184 203
3 60.4037 2024-06-08 00:00:00.0 6.5068 203
4 65.7750 2024-06-09 00:00:00.0 5.3713 203
5 71.2710 2024-06-10 00:00:00.0 5.4960 203
6 80.0721 2024-06-11 00:00:00.0 8.8011 203
7 87.9191 2024-06-12 00:00:00.0 7.8470 203
8 95.8736 2024-06-13 00:00:00.0 7.9545 203
9 103.3881 2024-06-14 00:00:00.0 7.5145 203
10 111.0711 2024-06-15 00:00:00.0 7.6830 203
11 119.9054 2024-06-16 00:00:00.0 8.8343 203
12 127.1550 2024-06-17 00:00:00.0 7.2496 203
13 134.0872 2024-06-18 00:00:00.0 6.9322 203
14 141.5515 2024-06-19 00:00:00.0 7.4643 203
15 149.7504 2024-06-20 00:00:00.0 8.1989 203
16 158.2491 2024-06-21 00:00:00.0 8.4987 203
17 166.9276 2024-06-22 00:00:00.0 8.6785 203
18 175.5451 2024-06-23 00:00:00.0 8.6175 203
19 184.1626 2024-06-24 00:00:00.0 8.6175 203
20 193.3644 2024-06-25 00:00:00.0 9.2018 203
21 200.8532 2024-06-26 00:00:00.0 7.4888 203
22 207.4466 2024-06-27 00:00:00.0 6.5934 203
23 214.5481 2024-06-28 00:00:00.0 7.1015 203
24 221.4078 2024-06-29 00:00:00.0 6.8597 203
25 227.4709 2024-06-30 00:00:00.0 6.0631 203
26 236.1993 2024-07-01 00:00:00.0 8.7284 203
27 245.4924 2024-07-02 00:00:00.0 9.2931 203
28 254.6436 2024-07-03 00:00:00.0 9.1512 203
29 263.0895 2024-07-04 00:00:00.0 8.4459 203
30 271.7790 2024-07-05 00:00:00.0 8.6895 203
31 280.5439 2024-07-06 00:00:00.0 8.7649 203
32 289.2454 2024-07-07 00:00:00.0 8.7015 203
33 297.6306 2024-07-08 00:00:00.0 8.3852 203
34 305.5228 2024-07-09 00:00:00.0 7.8922 203
35 313.3149 2024-07-10 00:00:00.0 7.7921 203
36 320.8700 2024-07-11 00:00:00.0 7.5551 203
37 328.0403 2024-07-12 00:00:00.0 7.1703 203
38 335.9144 2024-07-13 00:00:00.0 7.8741 203
39 344.6346 2024-07-14 00:00:00.0 8.7202 203
40 353.7331 2024-07-15 00:00:00.0 9.0985 203
41 361.1067 2024-07-16 00:00:00.0 7.3736 203
42 367.7831 2024-07-17 00:00:00.0 6.6764 203
43 375.8947 2024-07-18 00:00:00.0 8.1116 203
44 384.4252 2024-07-19 00:00:00.0 8.5305 203
45 392.6143 2024-07-20 00:00:00.0 8.1891 203
46 401.0599 2024-07-21 00:00:00.0 8.4456 203
47 410.2608 2024-07-22 00:00:00.0 9.2009 203
48 419.6966 2024-07-23 00:00:00.0 9.4358 203
49 428.6656 2024-07-24 00:00:00.0 8.9690 203
50 437.0919 2024-07-25 00:00:00.0 8.4263 203
51 444.1609 2024-07-26 00:00:00.0 7.0690 203
52 452.6061 2024-07-27 00:00:00.0 8.4452 203
53 461.7830 2024-07-28 00:00:00.0 9.1769 203
54 470.1528 2024-07-29 00:00:00.0 8.3698 203
55 477.6486 2024-07-30 00:00:00.0 7.4958 203
56 485.8378 2024-07-31 00:00:00.0 8.1892 203
57 492.8660 2024-08-01 00:00:00.0 7.0282 203
58 500.7718 2024-08-02 00:00:00.0 7.9058 203
59 508.7330 2024-08-03 00:00:00.0 7.9612 203
60 514.7059 2024-08-04 00:00:00.0 5.9729 203
61 522.6477 2024-08-05 00:00:00.0 7.9418 203
62 529.0806 2024-08-06 00:00:00.0 6.4329 203
63 537.1272 2024-08-07 00:00:00.0 8.0466 203
64 543.2179 2024-08-08 00:00:00.0 6.0907 203
65 549.8797 2024-08-09 00:00:00.0 6.6618 203
66 556.2803 2024-08-10 00:00:00.0 6.4006 203
67 563.3606 2024-08-11 00:00:00.0 7.0803 203
68 570.3926 2024-08-12 00:00:00.0 7.0320 203
69 577.9017 2024-08-13 00:00:00.0 7.5091 203
70 586.9174 2024-08-14 00:00:00.0 9.0157 203
71 596.6889 2024-08-15 00:00:00.0 9.7715 203
72 606.0902 2024-08-16 00:00:00.0 9.4013 203
73 614.6012 2024-08-17 00:00:00.0 8.5110 203
74 622.1786 2024-08-18 00:00:00.0 7.5774 203
75 630.2196 2024-08-19 00:00:00.0 8.0410 203
76 638.1679 2024-08-20 00:00:00.0 7.9483 203
77 646.9919 2024-08-21 00:00:00.0 8.8240 203
78 656.3583 2024-08-22 00:00:00.0 9.3664 203
79 664.0239 2024-08-23 00:00:00.0 7.6656 203
80 671.3853 2024-08-24 00:00:00.0 7.3614 203
81 678.1086 2024-08-25 00:00:00.0 6.7233 203
82 686.2286 2024-08-26 00:00:00.0 8.1200 203
83 691.7045 2024-08-27 00:00:00.0 5.4759 203
84 698.3172 2024-08-28 00:00:00.0 6.6127 203
85 707.2837 2024-08-29 00:00:00.0 8.9665 203
86 715.5970 2024-08-30 00:00:00.0 8.3133 203
87 722.9915 2024-08-31 00:00:00.0 7.3945 203
88 729.0028 2024-09-01 00:00:00.0 6.0113 203
89 736.8819 2024-09-02 00:00:00.0 7.8791 203
90 744.5171 2024-09-03 00:00:00.0 7.6352 203
91 753.9585 2024-09-04 00:00:00.0 9.4414 203
92 760.2770 2024-09-05 00:00:00.0 6.3185 203
93 765.1142 2024-09-06 00:00:00.0 4.8372 203
94 771.3772 2024-09-07 00:00:00.0 6.2630 203
95 778.5768 2024-09-08 00:00:00.0 7.1996 203
96 785.9788 2024-09-09 00:00:00.0 7.4020 203
97 794.8349 2024-09-10 00:00:00.0 8.8561 203
98 801.9253 2024-09-11 00:00:00.0 7.0904 203
99 809.4423 2024-09-12 00:00:00.0 7.5170 203
100 818.2080 2024-09-13 00:00:00.0 8.7657 203
101 826.9523 2024-09-14 00:00:00.0 8.7443 203
102 834.6203 2024-09-15 00:00:00.0 7.6680 203
103 843.5705 2024-09-16 00:00:00.0 8.9502 203
104 852.9965 2024-09-17 00:00:00.0 9.4260 203
105 862.1843 2024-09-18 00:00:00.0 9.1878 203
106 871.9700 2024-09-19 00:00:00.0 9.7857 203
107 880.9630 2024-09-20 00:00:00.0 8.9930 203
108 888.2086 2024-09-21 00:00:00.0 7.2456 203
109 893.2584 2024-09-22 00:00:00.0 5.0498 203
110 901.4878 2024-09-23 00:00:00.0 8.2294 203
111 908.8879 2024-09-24 00:00:00.0 7.4001 203
112 916.5113 2024-09-25 00:00:00.0 7.6234 203
113 924.3072 2024-09-26 00:00:00.0 7.7959 203
114 931.5121 2024-09-27 00:00:00.0 7.2049 203
115 939.1920 2024-09-28 00:00:00.0 7.6799 203
116 946.1441 2024-09-29 00:00:00.0 6.9521 203
117 953.5147 2024-09-30 00:00:00.0 7.3706 203
118 957.0632 2024-10-01 00:00:00.0 3.5485 203
119 961.7647 2024-10-02 00:00:00.0 4.7015 203
120 962.9573 2024-10-03 00:00:00.0 1.1926 203
121 966.0407 2024-10-04 00:00:00.0 3.0834 203
122 971.5525 2024-10-05 00:00:00.0 5.5118 203
123 974.0068 2024-10-06 00:00:00.0 2.4543 203
124 977.1205 2024-10-07 00:00:00.0 3.1137 203
125 981.6534 2024-10-08 00:00:00.0 4.5329 203
126 989.0924 2024-10-09 00:00:00.0 7.4390 203
127 996.7207 2024-10-10 00:00:00.0 7.6283 203
128 999.5412 2024-10-11 00:00:00.0 2.8205 203
129 1001.9283 2024-10-12 00:00:00.0 2.3871 203
130 1002.7283 2024-10-13 00:00:00.0 0.8000 203
131 1002.8839 2024-10-14 00:00:00.0 0.1556 203
132 1003.4037 2024-10-15 00:00:00.0 0.5198 203
133 1007.0715 2024-10-16 00:00:00.0 3.6678 203
134 1012.5104 2024-10-17 00:00:00.0 5.4389 203
135 1014.1084 2024-10-18 00:00:00.0 1.5980 203
136 1015.7624 2024-10-19 00:00:00.0 1.6540 203
137 1021.3107 2024-10-20 00:00:00.0 5.5483 203
138 1026.2076 2024-10-21 00:00:00.0 4.8969 203
139 1029.0827 2024-10-22 00:00:00.0 2.8751 203
140 1030.8154 2024-10-23 00:00:00.0 1.7327 203
141 1031.3623 2024-10-24 00:00:00.0 0.5469 203
142 1031.8123 2024-10-25 00:00:00.0 0.4500 203
143 1032.3184 2024-10-26 00:00:00.0 0.5061 203
144 1034.0856 2024-10-27 00:00:00.0 1.7672 203
145 1037.0313 2024-10-28 00:00:00.0 2.9457 203
146 1037.5236 2024-10-29 00:00:00.0 0.4923 203
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '203') 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 1038
10/28/2024 3 1037
10/27/2024 2 1034
10/26/2024 1 1032
10/25/2024 0 1032
10/24/2024 1 1031
10/23/2024 2 1031
10/22/2024 3 1029
10/21/2024 5 1026
10/20/2024 6 1021
10/19/2024 2 1016
10/18/2024 2 1014
10/17/2024 5 1013
10/16/2024 4 1007
10/15/2024 1 1003
10/14/2024 0 1003
10/13/2024 1 1003
10/12/2024 2 1002
10/11/2024 3 1000
10/10/2024 8 997
10/9/2024 7 989
10/8/2024 5 982
10/7/2024 3 977
10/6/2024 2 974
10/5/2024 6 972
10/4/2024 3 966
10/3/2024 1 963
10/2/2024 5 962
10/1/2024 4 957
9/30/2024 7 954
9/29/2024 7 946
9/28/2024 8 939
9/27/2024 7 932
9/26/2024 8 924
9/25/2024 8 917
9/24/2024 7 909
9/23/2024 8 901
9/22/2024 5 893
9/21/2024 7 888
9/20/2024 9 881
9/19/2024 10 872
9/18/2024 9 862
9/17/2024 9 853
9/16/2024 9 844
9/15/2024 8 835
9/14/2024 9 827
9/13/2024 9 818
9/12/2024 8 809
9/11/2024 7 802
9/10/2024 9 795
9/9/2024 7 786
9/8/2024 7 779
9/7/2024 6 771
9/6/2024 5 765
9/5/2024 6 760
9/4/2024 9 754
9/3/2024 8 745
9/2/2024 8 737
9/1/2024 6 729
8/31/2024 7 723
8/30/2024 8 716
8/29/2024 9 707
8/28/2024 7 698
8/27/2024 5 692
8/26/2024 8 686
8/25/2024 7 678
8/24/2024 7 671
8/23/2024 8 664
8/22/2024 9 656
8/21/2024 9 647
8/20/2024 8 638
8/19/2024 8 630
8/18/2024 8 622
8/17/2024 9 615
8/16/2024 9 606
8/15/2024 10 597
8/14/2024 9 587
8/13/2024 8 578
8/12/2024 7 570
8/11/2024 7 563
8/10/2024 6 556
8/9/2024 7 550
8/8/2024 6 543
8/7/2024 8 537
8/6/2024 6 529
8/5/2024 8 523
8/4/2024 6 515
8/3/2024 8 509
8/2/2024 8 501
8/1/2024 7 493
7/31/2024 8 486
7/30/2024 7 478
7/29/2024 8 470
7/28/2024 9 462
7/27/2024 8 453
7/26/2024 7 444
7/25/2024 8 437
7/24/2024 9 429
7/23/2024 9 420
7/22/2024 9 410
7/21/2024 8 401
7/20/2024 8 393
7/19/2024 9 384
7/18/2024 8 376
7/17/2024 7 368
7/16/2024 7 361
7/15/2024 9 354
7/14/2024 9 345
7/13/2024 8 336
7/12/2024 7 328
7/11/2024 8 321
7/10/2024 8 313
7/9/2024 8 306
7/8/2024 8 298
7/7/2024 9 289
7/6/2024 9 281
7/5/2024 9 272
7/4/2024 8 263
7/3/2024 9 255
7/2/2024 9 245
7/1/2024 9 236
6/30/2024 6 227
6/29/2024 7 221
6/28/2024 7 215
6/27/2024 7 207
6/26/2024 7 201
6/25/2024 9 193
6/24/2024 9 184
6/23/2024 9 176
6/22/2024 9 167
6/21/2024 8 158
6/20/2024 8 150
6/19/2024 7 142
6/18/2024 7 134
6/17/2024 7 127
6/16/2024 9 120
6/15/2024 8 111
6/14/2024 8 103
6/13/2024 8 96
6/12/2024 8 88
6/11/2024 9 80
6/10/2024 5 71
6/9/2024 5 66
6/8/2024 7 60
6/7/2024 6 54