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 5.7118 2022-06-06 00:00:00.0 5.7118 235
2 12.4925 2022-06-07 00:00:00.0 6.7807 235
3 20.1211 2022-06-08 00:00:00.0 7.6286 235
4 26.6830 2022-06-09 00:00:00.0 6.5619 235
5 35.4456 2022-06-10 00:00:00.0 8.7626 235
6 44.1904 2022-06-11 00:00:00.0 8.7448 235
7 53.3987 2022-06-12 00:00:00.0 9.2083 235
8 62.2768 2022-06-13 00:00:00.0 8.8781 235
9 71.3126 2022-06-14 00:00:00.0 9.0358 235
10 79.9849 2022-06-15 00:00:00.0 8.6723 235
11 88.6024 2022-06-16 00:00:00.0 8.6175 235
12 97.5458 2022-06-17 00:00:00.0 8.9434 235
13 105.5218 2022-06-18 00:00:00.0 7.9760 235
14 109.7611 2022-06-19 00:00:00.0 4.2393 235
15 118.1751 2022-06-20 00:00:00.0 8.4140 235
16 127.0398 2022-06-21 00:00:00.0 8.8647 235
17 134.9829 2022-06-22 00:00:00.0 7.9431 235
18 141.9858 2022-06-23 00:00:00.0 7.0029 235
19 151.4737 2022-06-24 00:00:00.0 9.4879 235
20 159.5315 2022-06-25 00:00:00.0 8.0578 235
21 167.7265 2022-06-26 00:00:00.0 8.1950 235
22 175.9469 2022-06-27 00:00:00.0 8.2204 235
23 184.3714 2022-06-28 00:00:00.0 8.4245 235
24 191.9344 2022-06-29 00:00:00.0 7.5630 235
25 200.6835 2022-06-30 00:00:00.0 8.7491 235
26 208.7965 2022-07-01 00:00:00.0 8.1130 235
27 216.9709 2022-07-02 00:00:00.0 8.1744 235
28 225.4961 2022-07-03 00:00:00.0 8.5252 235
29 235.0567 2022-07-04 00:00:00.0 9.5606 235
30 244.3253 2022-07-05 00:00:00.0 9.2686 235
31 252.4694 2022-07-06 00:00:00.0 8.1441 235
32 261.9502 2022-07-07 00:00:00.0 9.4808 235
33 270.3650 2022-07-08 00:00:00.0 8.4148 235
34 277.6226 2022-07-09 00:00:00.0 7.2576 235
35 286.5656 2022-07-10 00:00:00.0 8.9430 235
36 295.6143 2022-07-11 00:00:00.0 9.0487 235
37 304.9512 2022-07-12 00:00:00.0 9.3369 235
38 313.2966 2022-07-13 00:00:00.0 8.3454 235
39 322.7146 2022-07-14 00:00:00.0 9.4180 235
40 330.3603 2022-07-15 00:00:00.0 7.6457 235
41 337.9028 2022-07-16 00:00:00.0 7.5425 235
42 342.5829 2022-07-17 00:00:00.0 4.6801 235
43 350.2829 2022-07-18 00:00:00.0 7.7000 235
44 360.0322 2022-07-19 00:00:00.0 9.7493 235
45 368.9454 2022-07-20 00:00:00.0 8.9132 235
46 377.9565 2022-07-21 00:00:00.0 9.0111 235
47 387.3552 2022-07-22 00:00:00.0 9.3987 235
48 396.6425 2022-07-23 00:00:00.0 9.2873 235
49 405.3372 2022-07-24 00:00:00.0 8.6947 235
50 413.8018 2022-07-25 00:00:00.0 8.4646 235
51 422.8932 2022-07-26 00:00:00.0 9.0914 235
52 431.4592 2022-07-27 00:00:00.0 8.5660 235
53 440.3212 2022-07-28 00:00:00.0 8.8620 235
54 447.9698 2022-07-29 00:00:00.0 7.6486 235
55 455.0421 2022-07-30 00:00:00.0 7.0723 235
56 464.1422 2022-07-31 00:00:00.0 9.1001 235
57 472.8913 2022-08-01 00:00:00.0 8.7491 235
58 480.4055 2022-08-02 00:00:00.0 7.5142 235
59 489.3358 2022-08-03 00:00:00.0 8.9303 235
60 496.7596 2022-08-04 00:00:00.0 7.4238 235
61 504.3612 2022-08-05 00:00:00.0 7.6016 235
62 512.2582 2022-08-06 00:00:00.0 7.8970 235
63 518.8007 2022-08-07 00:00:00.0 6.5425 235
64 525.9684 2022-08-08 00:00:00.0 7.1677 235
65 535.2028 2022-08-09 00:00:00.0 9.2344 235
66 543.6176 2022-08-10 00:00:00.0 8.4148 235
67 550.5650 2022-08-11 00:00:00.0 6.9474 235
68 559.6325 2022-08-12 00:00:00.0 9.0675 235
69 567.4125 2022-08-13 00:00:00.0 7.7800 235
70 575.3436 2022-08-14 00:00:00.0 7.9311 235
71 584.8848 2022-08-15 00:00:00.0 9.5412 235
72 593.1432 2022-08-16 00:00:00.0 8.2584 235
73 601.2196 2022-08-17 00:00:00.0 8.0764 235
74 611.1205 2022-08-18 00:00:00.0 9.9009 235
75 620.5013 2022-08-19 00:00:00.0 9.3808 235
76 628.6931 2022-08-20 00:00:00.0 8.1918 235
77 635.9135 2022-08-21 00:00:00.0 7.2204 235
78 645.1545 2022-08-22 00:00:00.0 9.2410 235
79 654.6025 2022-08-23 00:00:00.0 9.4480 235
80 663.0741 2022-08-24 00:00:00.0 8.4716 235
81 670.3387 2022-08-25 00:00:00.0 7.2646 235
82 678.7390 2022-08-26 00:00:00.0 8.4003 235
83 686.6552 2022-08-27 00:00:00.0 7.9162 235
84 695.7083 2022-08-28 00:00:00.0 9.0531 235
85 705.1418 2022-08-29 00:00:00.0 9.4335 235
86 713.5164 2022-08-30 00:00:00.0 8.3746 235
87 720.6625 2022-08-31 00:00:00.0 7.1461 235
88 726.9243 2022-09-01 00:00:00.0 6.2618 235
89 735.3404 2022-09-02 00:00:00.0 8.4161 235
90 742.0996 2022-09-03 00:00:00.0 6.7592 235
91 749.2227 2022-09-04 00:00:00.0 7.1231 235
92 757.2385 2022-09-05 00:00:00.0 8.0158 235
93 765.8867 2022-09-06 00:00:00.0 8.6482 235
94 772.4306 2022-09-07 00:00:00.0 6.5439 235
95 781.1347 2022-09-08 00:00:00.0 8.7041 235
96 788.2734 2022-09-09 00:00:00.0 7.1387 235
97 793.9693 2022-09-10 00:00:00.0 5.6959 235
98 800.2443 2022-09-11 00:00:00.0 6.2750 235
99 807.7291 2022-09-12 00:00:00.0 7.4848 235
100 812.8911 2022-09-13 00:00:00.0 5.1620 235
101 819.7595 2022-09-14 00:00:00.0 6.8684 235
102 827.3788 2022-09-15 00:00:00.0 7.6193 235
103 832.9492 2022-09-16 00:00:00.0 5.5704 235
104 840.0823 2022-09-17 00:00:00.0 7.1331 235
105 847.5478 2022-09-18 00:00:00.0 7.4655 235
106 854.0294 2022-09-19 00:00:00.0 6.4816 235
107 861.6487 2022-09-20 00:00:00.0 7.6193 235
108 865.7154 2022-09-21 00:00:00.0 4.0667 235
109 868.6400 2022-09-22 00:00:00.0 2.9246 235
110 872.9883 2022-09-23 00:00:00.0 4.3483 235
111 880.7203 2022-09-24 00:00:00.0 7.7320 235
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '235') 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 8 881
9/23/2022 4 873
9/22/2022 3 869
9/21/2022 4 866
9/20/2022 8 862
9/19/2022 6 854
9/18/2022 7 848
9/17/2022 7 840
9/16/2022 6 833
9/15/2022 8 827
9/14/2022 7 820
9/13/2022 5 813
9/12/2022 7 808
9/11/2022 6 800
9/10/2022 6 794
9/9/2022 7 788
9/8/2022 9 781
9/7/2022 7 772
9/6/2022 9 766
9/5/2022 8 757
9/4/2022 7 749
9/3/2022 7 742
9/2/2022 8 735
9/1/2022 6 727
8/31/2022 7 721
8/30/2022 8 714
8/29/2022 9 705
8/28/2022 9 696
8/27/2022 8 687
8/26/2022 8 679
8/25/2022 7 670
8/24/2022 8 663
8/23/2022 9 655
8/22/2022 9 645
8/21/2022 7 636
8/20/2022 8 629
8/19/2022 9 621
8/18/2022 10 611
8/17/2022 8 601
8/16/2022 8 593
8/15/2022 10 585
8/14/2022 8 575
8/13/2022 8 567
8/12/2022 9 560
8/11/2022 7 551
8/10/2022 8 544
8/9/2022 9 535
8/8/2022 7 526
8/7/2022 7 519
8/6/2022 8 512
8/5/2022 8 504
8/4/2022 7 497
8/3/2022 9 489
8/2/2022 8 480
8/1/2022 9 473
7/31/2022 9 464
7/30/2022 7 455
7/29/2022 8 448
7/28/2022 9 440
7/27/2022 9 431
7/26/2022 9 423
7/25/2022 8 414
7/24/2022 9 405
7/23/2022 9 397
7/22/2022 9 387
7/21/2022 9 378
7/20/2022 9 369
7/19/2022 10 360
7/18/2022 8 350
7/17/2022 5 343
7/16/2022 8 338
7/15/2022 8 330
7/14/2022 9 323
7/13/2022 8 313
7/12/2022 9 305
7/11/2022 9 296
7/10/2022 9 287
7/9/2022 7 278
7/8/2022 8 270
7/7/2022 9 262
7/6/2022 8 252
7/5/2022 9 244
7/4/2022 10 235
7/3/2022 9 225
7/2/2022 8 217
7/1/2022 8 209
6/30/2022 9 201
6/29/2022 8 192
6/28/2022 8 184
6/27/2022 8 176
6/26/2022 8 168
6/25/2022 8 160
6/24/2022 9 151
6/23/2022 7 142
6/22/2022 8 135
6/21/2022 9 127
6/20/2022 8 118
6/19/2022 4 110
6/18/2022 8 106
6/17/2022 9 98
6/16/2022 9 89
6/15/2022 9 80
6/14/2022 9 71
6/13/2022 9 62
6/12/2022 9 53
6/11/2022 9 44
6/10/2022 9 35
6/9/2022 7 27
6/8/2022 8 20
6/7/2022 7 12