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 45.7973 2024-06-06 00:00:00.0 7.1662 246
2 51.6044 2024-06-07 00:00:00.0 5.8071 246
3 57.8874 2024-06-08 00:00:00.0 6.2830 246
4 61.8989 2024-06-09 00:00:00.0 4.0115 246
5 66.8705 2024-06-10 00:00:00.0 4.9716 246
6 75.3020 2024-06-11 00:00:00.0 8.4315 246
7 83.8701 2024-06-12 00:00:00.0 8.5681 246
8 91.2184 2024-06-13 00:00:00.0 7.3483 246
9 98.7217 2024-06-14 00:00:00.0 7.5033 246
10 107.2021 2024-06-15 00:00:00.0 8.4804 246
11 116.3070 2024-06-16 00:00:00.0 9.1049 246
12 121.4694 2024-06-17 00:00:00.0 5.1624 246
13 126.8783 2024-06-18 00:00:00.0 5.4089 246
14 132.5901 2024-06-19 00:00:00.0 5.7118 246
15 140.4682 2024-06-20 00:00:00.0 7.8781 246
16 148.6765 2024-06-21 00:00:00.0 8.2083 246
17 157.4990 2024-06-22 00:00:00.0 8.8225 246
18 166.0686 2024-06-23 00:00:00.0 8.5696 246
19 174.4759 2024-06-24 00:00:00.0 8.4073 246
20 183.3572 2024-06-25 00:00:00.0 8.8813 246
21 187.9972 2024-06-26 00:00:00.0 4.6400 246
22 194.2747 2024-06-27 00:00:00.0 6.2775 246
23 200.2769 2024-06-28 00:00:00.0 6.0022 246
24 205.4207 2024-06-29 00:00:00.0 5.1438 246
25 210.8480 2024-06-30 00:00:00.0 5.4273 246
26 219.5313 2024-07-01 00:00:00.0 8.6833 246
27 228.5397 2024-07-02 00:00:00.0 9.0084 246
28 237.3316 2024-07-03 00:00:00.0 8.7919 246
29 245.9512 2024-07-04 00:00:00.0 8.6196 246
30 254.6407 2024-07-05 00:00:00.0 8.6895 246
31 263.4490 2024-07-06 00:00:00.0 8.8083 246
32 272.0543 2024-07-07 00:00:00.0 8.6053 246
33 280.6231 2024-07-08 00:00:00.0 8.5688 246
34 289.1678 2024-07-09 00:00:00.0 8.5447 246
35 297.5625 2024-07-10 00:00:00.0 8.3947 246
36 306.0134 2024-07-11 00:00:00.0 8.4509 246
37 313.7919 2024-07-12 00:00:00.0 7.7785 246
38 322.5147 2024-07-13 00:00:00.0 8.7228 246
39 331.2058 2024-07-14 00:00:00.0 8.6911 246
40 340.0112 2024-07-15 00:00:00.0 8.8054 246
41 347.6120 2024-07-16 00:00:00.0 7.6008 246
42 354.1465 2024-07-17 00:00:00.0 6.5345 246
43 361.6997 2024-07-18 00:00:00.0 7.5532 246
44 369.9034 2024-07-19 00:00:00.0 8.2037 246
45 378.6649 2024-07-20 00:00:00.0 8.7615 246
46 387.4285 2024-07-21 00:00:00.0 8.7636 246
47 396.6968 2024-07-22 00:00:00.0 9.2683 246
48 406.2148 2024-07-23 00:00:00.0 9.5180 246
49 415.3434 2024-07-24 00:00:00.0 9.1286 246
50 423.5937 2024-07-25 00:00:00.0 8.2503 246
51 432.8310 2024-07-26 00:00:00.0 9.2373 246
52 440.9158 2024-07-27 00:00:00.0 8.0848 246
53 449.3666 2024-07-28 00:00:00.0 8.4508 246
54 457.8942 2024-07-29 00:00:00.0 8.5276 246
55 466.2566 2024-07-30 00:00:00.0 8.3624 246
56 475.1391 2024-07-31 00:00:00.0 8.8825 246
57 482.3478 2024-08-01 00:00:00.0 7.2087 246
58 490.0283 2024-08-02 00:00:00.0 7.6805 246
59 498.2510 2024-08-03 00:00:00.0 8.2227 246
60 503.5683 2024-08-04 00:00:00.0 5.3173 246
61 511.3967 2024-08-05 00:00:00.0 7.8284 246
62 517.4125 2024-08-06 00:00:00.0 6.0158 246
63 523.7269 2024-08-07 00:00:00.0 6.3144 246
64 529.3089 2024-08-08 00:00:00.0 5.5820 246
65 535.9154 2024-08-09 00:00:00.0 6.6065 246
66 542.1580 2024-08-10 00:00:00.0 6.2426 246
67 548.5212 2024-08-11 00:00:00.0 6.3632 246
68 555.1225 2024-08-12 00:00:00.0 6.6013 246
69 563.1257 2024-08-13 00:00:00.0 8.0032 246
70 572.6602 2024-08-14 00:00:00.0 9.5345 246
71 582.1599 2024-08-15 00:00:00.0 9.4997 246
72 591.5156 2024-08-16 00:00:00.0 9.3557 246
73 599.8761 2024-08-17 00:00:00.0 8.3605 246
74 608.3203 2024-08-18 00:00:00.0 8.4442 246
75 616.6519 2024-08-19 00:00:00.0 8.3316 246
76 625.1861 2024-08-20 00:00:00.0 8.5342 246
77 634.1154 2024-08-21 00:00:00.0 8.9293 246
78 643.3211 2024-08-22 00:00:00.0 9.2057 246
79 651.5557 2024-08-23 00:00:00.0 8.2346 246
80 659.0973 2024-08-24 00:00:00.0 7.5416 246
81 667.4823 2024-08-25 00:00:00.0 8.3850 246
82 674.2133 2024-08-26 00:00:00.0 6.7310 246
83 680.2555 2024-08-27 00:00:00.0 6.0422 246
84 686.6858 2024-08-28 00:00:00.0 6.4303 246
85 694.4579 2024-08-29 00:00:00.0 7.7721 246
86 702.8531 2024-08-30 00:00:00.0 8.3952 246
87 710.7326 2024-08-31 00:00:00.0 7.8795 246
88 716.8049 2024-09-01 00:00:00.0 6.0723 246
89 724.2392 2024-09-02 00:00:00.0 7.4343 246
90 732.1278 2024-09-03 00:00:00.0 7.8886 246
91 740.7819 2024-09-04 00:00:00.0 8.6541 246
92 746.9325 2024-09-05 00:00:00.0 6.1506 246
93 752.0627 2024-09-06 00:00:00.0 5.1302 246
94 758.1824 2024-09-07 00:00:00.0 6.1197 246
95 764.9335 2024-09-08 00:00:00.0 6.7511 246
96 771.4622 2024-09-09 00:00:00.0 6.5287 246
97 779.8392 2024-09-10 00:00:00.0 8.3770 246
98 786.2108 2024-09-11 00:00:00.0 6.3716 246
99 793.7997 2024-09-12 00:00:00.0 7.5889 246
100 803.2783 2024-09-13 00:00:00.0 9.4786 246
101 811.5103 2024-09-14 00:00:00.0 8.2320 246
102 819.8387 2024-09-15 00:00:00.0 8.3284 246
103 828.1072 2024-09-16 00:00:00.0 8.2685 246
104 837.4508 2024-09-17 00:00:00.0 9.3436 246
105 846.7966 2024-09-18 00:00:00.0 9.3458 246
106 855.9406 2024-09-19 00:00:00.0 9.1440 246
107 863.6602 2024-09-20 00:00:00.0 7.7196 246
108 868.6946 2024-09-21 00:00:00.0 5.0344 246
109 872.7022 2024-09-22 00:00:00.0 4.0076 246
110 880.3047 2024-09-23 00:00:00.0 7.6025 246
111 887.7862 2024-09-24 00:00:00.0 7.4815 246
112 895.0856 2024-09-25 00:00:00.0 7.2994 246
113 902.5288 2024-09-26 00:00:00.0 7.4432 246
114 908.4301 2024-09-27 00:00:00.0 5.9013 246
115 915.3065 2024-09-28 00:00:00.0 6.8764 246
116 922.4374 2024-09-29 00:00:00.0 7.1309 246
117 929.6498 2024-09-30 00:00:00.0 7.2124 246
118 932.6392 2024-10-01 00:00:00.0 2.9894 246
119 936.5739 2024-10-02 00:00:00.0 3.9347 246
120 937.3837 2024-10-03 00:00:00.0 0.8098 246
121 940.5320 2024-10-04 00:00:00.0 3.1483 246
122 944.6999 2024-10-05 00:00:00.0 4.1679 246
123 947.1149 2024-10-06 00:00:00.0 2.4150 246
124 950.6467 2024-10-07 00:00:00.0 3.5318 246
125 956.8893 2024-10-08 00:00:00.0 6.2426 246
126 963.3089 2024-10-09 00:00:00.0 6.4196 246
127 969.7150 2024-10-10 00:00:00.0 6.4061 246
128 971.9563 2024-10-11 00:00:00.0 2.2413 246
129 975.2218 2024-10-12 00:00:00.0 3.2655 246
130 975.6575 2024-10-13 00:00:00.0 0.4357 246
131 975.7279 2024-10-14 00:00:00.0 0.0704 246
132 976.2477 2024-10-15 00:00:00.0 0.5198 246
133 980.2287 2024-10-16 00:00:00.0 3.9810 246
134 985.8067 2024-10-17 00:00:00.0 5.5780 246
135 986.7362 2024-10-18 00:00:00.0 0.9295 246
136 988.7276 2024-10-19 00:00:00.0 1.9914 246
137 993.6791 2024-10-20 00:00:00.0 4.9515 246
138 998.9416 2024-10-21 00:00:00.0 5.2625 246
139 1000.6230 2024-10-22 00:00:00.0 1.6814 246
140 1002.2530 2024-10-23 00:00:00.0 1.6300 246
141 1002.7313 2024-10-24 00:00:00.0 0.4783 246
142 1003.0164 2024-10-25 00:00:00.0 0.2851 246
143 1003.6787 2024-10-26 00:00:00.0 0.6623 246
144 1004.2121 2024-10-27 00:00:00.0 0.5334 246
145 1007.1889 2024-10-28 00:00:00.0 2.9768 246
146 1007.4740 2024-10-29 00:00:00.0 0.2851 246
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '246') 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 1007
10/28/2024 3 1007
10/27/2024 1 1004
10/26/2024 1 1004
10/25/2024 0 1003
10/24/2024 0 1003
10/23/2024 2 1002
10/22/2024 2 1001
10/21/2024 5 999
10/20/2024 5 994
10/19/2024 2 989
10/18/2024 1 987
10/17/2024 6 986
10/16/2024 4 980
10/15/2024 1 976
10/14/2024 0 976
10/13/2024 0 976
10/12/2024 3 975
10/11/2024 2 972
10/10/2024 6 970
10/9/2024 6 963
10/8/2024 6 957
10/7/2024 4 951
10/6/2024 2 947
10/5/2024 4 945
10/4/2024 3 941
10/3/2024 1 937
10/2/2024 4 937
10/1/2024 3 933
9/30/2024 7 930
9/29/2024 7 922
9/28/2024 7 915
9/27/2024 6 908
9/26/2024 7 903
9/25/2024 7 895
9/24/2024 7 888
9/23/2024 8 880
9/22/2024 4 873
9/21/2024 5 869
9/20/2024 8 864
9/19/2024 9 856
9/18/2024 9 847
9/17/2024 9 837
9/16/2024 8 828
9/15/2024 8 820
9/14/2024 8 812
9/13/2024 9 803
9/12/2024 8 794
9/11/2024 6 786
9/10/2024 8 780
9/9/2024 7 771
9/8/2024 7 765
9/7/2024 6 758
9/6/2024 5 752
9/5/2024 6 747
9/4/2024 9 741
9/3/2024 8 732
9/2/2024 7 724
9/1/2024 6 717
8/31/2024 8 711
8/30/2024 8 703
8/29/2024 8 694
8/28/2024 6 687
8/27/2024 6 680
8/26/2024 7 674
8/25/2024 8 667
8/24/2024 8 659
8/23/2024 8 652
8/22/2024 9 643
8/21/2024 9 634
8/20/2024 9 625
8/19/2024 8 617
8/18/2024 8 608
8/17/2024 8 600
8/16/2024 9 592
8/15/2024 9 582
8/14/2024 10 573
8/13/2024 8 563
8/12/2024 7 555
8/11/2024 6 549
8/10/2024 6 542
8/9/2024 7 536
8/8/2024 6 529
8/7/2024 6 524
8/6/2024 6 517
8/5/2024 8 511
8/4/2024 5 504
8/3/2024 8 498
8/2/2024 8 490
8/1/2024 7 482
7/31/2024 9 475
7/30/2024 8 466
7/29/2024 9 458
7/28/2024 8 449
7/27/2024 8 441
7/26/2024 9 433
7/25/2024 8 424
7/24/2024 9 415
7/23/2024 10 406
7/22/2024 9 397
7/21/2024 9 387
7/20/2024 9 379
7/19/2024 8 370
7/18/2024 8 362
7/17/2024 7 354
7/16/2024 8 348
7/15/2024 9 340
7/14/2024 9 331
7/13/2024 9 323
7/12/2024 8 314
7/11/2024 8 306
7/10/2024 8 298
7/9/2024 9 289
7/8/2024 9 281
7/7/2024 9 272
7/6/2024 9 263
7/5/2024 9 255
7/4/2024 9 246
7/3/2024 9 237
7/2/2024 9 229
7/1/2024 9 220
6/30/2024 5 211
6/29/2024 5 205
6/28/2024 6 200
6/27/2024 6 194
6/26/2024 5 188
6/25/2024 9 183
6/24/2024 8 174
6/23/2024 9 166
6/22/2024 9 157
6/21/2024 8 149
6/20/2024 8 140
6/19/2024 6 133
6/18/2024 5 127
6/17/2024 5 121
6/16/2024 9 116
6/15/2024 8 107
6/14/2024 8 99
6/13/2024 7 91
6/12/2024 9 84
6/11/2024 8 75
6/10/2024 5 67
6/9/2024 4 62
6/8/2024 6 58
6/7/2024 6 52