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 4.5821 2022-06-06 00:00:00.0 4.5821 240
2 10.0904 2022-06-07 00:00:00.0 5.5083 240
3 17.1220 2022-06-08 00:00:00.0 7.0316 240
4 23.3371 2022-06-09 00:00:00.0 6.2151 240
5 30.7882 2022-06-10 00:00:00.0 7.4511 240
6 38.7463 2022-06-11 00:00:00.0 7.9581 240
7 47.8560 2022-06-12 00:00:00.0 9.1097 240
8 57.1029 2022-06-13 00:00:00.0 9.2469 240
9 66.0835 2022-06-14 00:00:00.0 8.9806 240
10 73.1272 2022-06-15 00:00:00.0 7.0437 240
11 81.2353 2022-06-16 00:00:00.0 8.1081 240
12 89.3693 2022-06-17 00:00:00.0 8.1340 240
13 96.0774 2022-06-18 00:00:00.0 6.7081 240
14 100.1909 2022-06-19 00:00:00.0 4.1135 240
15 109.6172 2022-06-20 00:00:00.0 9.4263 240
16 118.9178 2022-06-21 00:00:00.0 9.3006 240
17 127.0730 2022-06-22 00:00:00.0 8.1552 240
18 134.5623 2022-06-23 00:00:00.0 7.4893 240
19 143.8784 2022-06-24 00:00:00.0 9.3161 240
20 151.0247 2022-06-25 00:00:00.0 7.1463 240
21 158.5855 2022-06-26 00:00:00.0 7.5608 240
22 166.7744 2022-06-27 00:00:00.0 8.1889 240
23 174.9024 2022-06-28 00:00:00.0 8.1280 240
24 182.7877 2022-06-29 00:00:00.0 7.8853 240
25 191.4555 2022-06-30 00:00:00.0 8.6678 240
26 198.7525 2022-07-01 00:00:00.0 7.2970 240
27 205.7577 2022-07-02 00:00:00.0 7.0052 240
28 213.6672 2022-07-03 00:00:00.0 7.9095 240
29 222.8774 2022-07-04 00:00:00.0 9.2102 240
30 232.1914 2022-07-05 00:00:00.0 9.3140 240
31 240.5265 2022-07-06 00:00:00.0 8.3351 240
32 249.4162 2022-07-07 00:00:00.0 8.8897 240
33 257.3481 2022-07-08 00:00:00.0 7.9319 240
34 265.5342 2022-07-09 00:00:00.0 8.1861 240
35 274.2820 2022-07-10 00:00:00.0 8.7478 240
36 283.5624 2022-07-11 00:00:00.0 9.2804 240
37 292.3858 2022-07-12 00:00:00.0 8.8234 240
38 300.4569 2022-07-13 00:00:00.0 8.0711 240
39 309.5447 2022-07-14 00:00:00.0 9.0878 240
40 317.6848 2022-07-15 00:00:00.0 8.1401 240
41 325.7925 2022-07-16 00:00:00.0 8.1077 240
42 332.1988 2022-07-17 00:00:00.0 6.4063 240
43 340.2148 2022-07-18 00:00:00.0 8.0160 240
44 349.7321 2022-07-19 00:00:00.0 9.5173 240
45 358.8178 2022-07-20 00:00:00.0 9.0857 240
46 367.6172 2022-07-21 00:00:00.0 8.7994 240
47 376.0549 2022-07-22 00:00:00.0 8.4377 240
48 384.7155 2022-07-23 00:00:00.0 8.6606 240
49 392.1556 2022-07-24 00:00:00.0 7.4401 240
50 399.9130 2022-07-25 00:00:00.0 7.7574 240
51 408.5665 2022-07-26 00:00:00.0 8.6535 240
52 416.6865 2022-07-27 00:00:00.0 8.1200 240
53 424.6790 2022-07-28 00:00:00.0 7.9925 240
54 432.5836 2022-07-29 00:00:00.0 7.9046 240
55 439.6676 2022-07-30 00:00:00.0 7.0840 240
56 448.6521 2022-07-31 00:00:00.0 8.9845 240
57 457.4637 2022-08-01 00:00:00.0 8.8116 240
58 465.0912 2022-08-02 00:00:00.0 7.6275 240
59 473.9936 2022-08-03 00:00:00.0 8.9024 240
60 481.1262 2022-08-04 00:00:00.0 7.1326 240
61 490.2110 2022-08-05 00:00:00.0 9.0848 240
62 497.9019 2022-08-06 00:00:00.0 7.6909 240
63 504.1548 2022-08-07 00:00:00.0 6.2529 240
64 511.7445 2022-08-08 00:00:00.0 7.5897 240
65 520.2856 2022-08-09 00:00:00.0 8.5411 240
66 527.5941 2022-08-10 00:00:00.0 7.3085 240
67 533.9851 2022-08-11 00:00:00.0 6.3910 240
68 543.1551 2022-08-12 00:00:00.0 9.1700 240
69 551.4121 2022-08-13 00:00:00.0 8.2570 240
70 558.9582 2022-08-14 00:00:00.0 7.5461 240
71 567.8525 2022-08-15 00:00:00.0 8.8943 240
72 576.0250 2022-08-16 00:00:00.0 8.1725 240
73 584.4935 2022-08-17 00:00:00.0 8.4685 240
74 593.8974 2022-08-18 00:00:00.0 9.4039 240
75 602.9148 2022-08-19 00:00:00.0 9.0174 240
76 610.1288 2022-08-20 00:00:00.0 7.2140 240
77 617.3437 2022-08-21 00:00:00.0 7.2149 240
78 625.9257 2022-08-22 00:00:00.0 8.5820 240
79 634.3784 2022-08-23 00:00:00.0 8.4527 240
80 642.5301 2022-08-24 00:00:00.0 8.1517 240
81 649.0212 2022-08-25 00:00:00.0 6.4911 240
82 657.4233 2022-08-26 00:00:00.0 8.4021 240
83 665.1591 2022-08-27 00:00:00.0 7.7358 240
84 674.2603 2022-08-28 00:00:00.0 9.1012 240
85 682.6840 2022-08-29 00:00:00.0 8.4237 240
86 689.9407 2022-08-30 00:00:00.0 7.2567 240
87 697.1917 2022-08-31 00:00:00.0 7.2510 240
88 704.1640 2022-09-01 00:00:00.0 6.9723 240
89 712.0520 2022-09-02 00:00:00.0 7.8880 240
90 718.2596 2022-09-03 00:00:00.0 6.2076 240
91 726.2385 2022-09-04 00:00:00.0 7.9789 240
92 735.2783 2022-09-05 00:00:00.0 9.0398 240
93 743.1029 2022-09-06 00:00:00.0 7.8246 240
94 749.3890 2022-09-07 00:00:00.0 6.2861 240
95 756.6227 2022-09-08 00:00:00.0 7.2337 240
96 761.7869 2022-09-09 00:00:00.0 5.1642 240
97 766.8065 2022-09-10 00:00:00.0 5.0196 240
98 772.0035 2022-09-11 00:00:00.0 5.1970 240
99 777.7125 2022-09-12 00:00:00.0 5.7090 240
100 781.6522 2022-09-13 00:00:00.0 3.9397 240
101 786.6031 2022-09-14 00:00:00.0 4.9509 240
102 794.0034 2022-09-15 00:00:00.0 7.4003 240
103 799.8120 2022-09-16 00:00:00.0 5.8086 240
104 806.1784 2022-09-17 00:00:00.0 6.3664 240
105 813.5295 2022-09-18 00:00:00.0 7.3511 240
106 818.2274 2022-09-19 00:00:00.0 4.6979 240
107 824.7043 2022-09-20 00:00:00.0 6.4769 240
108 827.8854 2022-09-21 00:00:00.0 3.1811 240
109 830.5410 2022-09-22 00:00:00.0 2.6556 240
110 835.8764 2022-09-23 00:00:00.0 5.3354 240
111 842.8572 2022-09-24 00:00:00.0 6.9808 240
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '240') AND ddate BETWEEN {d '2022-06-06'} AND {d '2022-09-24'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/24/2022 7 843
9/23/2022 5 836
9/22/2022 3 831
9/21/2022 3 828
9/20/2022 6 825
9/19/2022 5 818
9/18/2022 7 814
9/17/2022 6 806
9/16/2022 6 800
9/15/2022 7 794
9/14/2022 5 787
9/13/2022 4 782
9/12/2022 6 778
9/11/2022 5 772
9/10/2022 5 767
9/9/2022 5 762
9/8/2022 7 757
9/7/2022 6 749
9/6/2022 8 743
9/5/2022 9 735
9/4/2022 8 726
9/3/2022 6 718
9/2/2022 8 712
9/1/2022 7 704
8/31/2022 7 697
8/30/2022 7 690
8/29/2022 8 683
8/28/2022 9 674
8/27/2022 8 665
8/26/2022 8 657
8/25/2022 6 649
8/24/2022 8 643
8/23/2022 8 634
8/22/2022 9 626
8/21/2022 7 617
8/20/2022 7 610
8/19/2022 9 603
8/18/2022 9 594
8/17/2022 8 584
8/16/2022 8 576
8/15/2022 9 568
8/14/2022 8 559
8/13/2022 8 551
8/12/2022 9 543
8/11/2022 6 534
8/10/2022 7 528
8/9/2022 9 520
8/8/2022 8 512
8/7/2022 6 504
8/6/2022 8 498
8/5/2022 9 490
8/4/2022 7 481
8/3/2022 9 474
8/2/2022 8 465
8/1/2022 9 457
7/31/2022 9 449
7/30/2022 7 440
7/29/2022 8 433
7/28/2022 8 425
7/27/2022 8 417
7/26/2022 9 409
7/25/2022 8 400
7/24/2022 7 392
7/23/2022 9 385
7/22/2022 8 376
7/21/2022 9 368
7/20/2022 9 359
7/19/2022 10 350
7/18/2022 8 340
7/17/2022 6 332
7/16/2022 8 326
7/15/2022 8 318
7/14/2022 9 310
7/13/2022 8 300
7/12/2022 9 292
7/11/2022 9 284
7/10/2022 9 274
7/9/2022 8 266
7/8/2022 8 257
7/7/2022 9 249
7/6/2022 8 241
7/5/2022 9 232
7/4/2022 9 223
7/3/2022 8 214
7/2/2022 7 206
7/1/2022 7 199
6/30/2022 9 191
6/29/2022 8 183
6/28/2022 8 175
6/27/2022 8 167
6/26/2022 8 159
6/25/2022 7 151
6/24/2022 9 144
6/23/2022 7 135
6/22/2022 8 127
6/21/2022 9 119
6/20/2022 9 110
6/19/2022 4 100
6/18/2022 7 96
6/17/2022 8 89
6/16/2022 8 81
6/15/2022 7 73
6/14/2022 9 66
6/13/2022 9 57
6/12/2022 9 48
6/11/2022 8 39
6/10/2022 7 31
6/9/2022 6 23
6/8/2022 7 17
6/7/2022 6 10