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 6.4172 2022-06-06 00:00:00.0 6.4172 210
2 12.7240 2022-06-07 00:00:00.0 6.3068 210
3 19.0902 2022-06-08 00:00:00.0 6.3662 210
4 25.3222 2022-06-09 00:00:00.0 6.2320 210
5 33.3607 2022-06-10 00:00:00.0 8.0385 210
6 42.2550 2022-06-11 00:00:00.0 8.8943 210
7 51.1061 2022-06-12 00:00:00.0 8.8511 210
8 59.7300 2022-06-13 00:00:00.0 8.6239 210
9 69.0542 2022-06-14 00:00:00.0 9.3242 210
10 77.7149 2022-06-15 00:00:00.0 8.6607 210
11 86.4527 2022-06-16 00:00:00.0 8.7378 210
12 95.1950 2022-06-17 00:00:00.0 8.7423 210
13 104.4000 2022-06-18 00:00:00.0 9.2050 210
14 108.8218 2022-06-19 00:00:00.0 4.4218 210
15 115.6097 2022-06-20 00:00:00.0 6.7879 210
16 124.3684 2022-06-21 00:00:00.0 8.7587 210
17 132.1730 2022-06-22 00:00:00.0 7.8046 210
18 138.5384 2022-06-23 00:00:00.0 6.3654 210
19 147.7300 2022-06-24 00:00:00.0 9.1916 210
20 155.9648 2022-06-25 00:00:00.0 8.2348 210
21 163.5621 2022-06-26 00:00:00.0 7.5973 210
22 171.5863 2022-06-27 00:00:00.0 8.0242 210
23 179.6008 2022-06-28 00:00:00.0 8.0145 210
24 187.1426 2022-06-29 00:00:00.0 7.5418 210
25 196.0557 2022-06-30 00:00:00.0 8.9131 210
26 204.0225 2022-07-01 00:00:00.0 7.9668 210
27 210.9025 2022-07-02 00:00:00.0 6.8800 210
28 219.4456 2022-07-03 00:00:00.0 8.5431 210
29 228.8864 2022-07-04 00:00:00.0 9.4408 210
30 238.1160 2022-07-05 00:00:00.0 9.2296 210
31 246.9975 2022-07-06 00:00:00.0 8.8815 210
32 256.4399 2022-07-07 00:00:00.0 9.4424 210
33 264.4581 2022-07-08 00:00:00.0 8.0182 210
34 272.8111 2022-07-09 00:00:00.0 8.3530 210
35 282.2973 2022-07-10 00:00:00.0 9.4862 210
36 291.4485 2022-07-11 00:00:00.0 9.1512 210
37 300.8916 2022-07-12 00:00:00.0 9.4431 210
38 309.2591 2022-07-13 00:00:00.0 8.3675 210
39 318.8112 2022-07-14 00:00:00.0 9.5521 210
40 326.5157 2022-07-15 00:00:00.0 7.7045 210
41 335.2258 2022-07-16 00:00:00.0 8.7101 210
42 341.8556 2022-07-17 00:00:00.0 6.6298 210
43 349.5006 2022-07-18 00:00:00.0 7.6450 210
44 358.6170 2022-07-19 00:00:00.0 9.1164 210
45 367.2729 2022-07-20 00:00:00.0 8.6559 210
46 376.2323 2022-07-21 00:00:00.0 8.9594 210
47 385.4587 2022-07-22 00:00:00.0 9.2264 210
48 394.5500 2022-07-23 00:00:00.0 9.0913 210
49 402.7760 2022-07-24 00:00:00.0 8.2260 210
50 410.6244 2022-07-25 00:00:00.0 7.8484 210
51 419.7010 2022-07-26 00:00:00.0 9.0766 210
52 428.2455 2022-07-27 00:00:00.0 8.5445 210
53 436.5374 2022-07-28 00:00:00.0 8.2919 210
54 444.0707 2022-07-29 00:00:00.0 7.5333 210
55 451.9917 2022-07-30 00:00:00.0 7.9210 210
56 460.4272 2022-07-31 00:00:00.0 8.4355 210
57 468.4082 2022-08-01 00:00:00.0 7.9810 210
58 476.3642 2022-08-02 00:00:00.0 7.9560 210
59 484.4391 2022-08-03 00:00:00.0 8.0749 210
60 492.3150 2022-08-04 00:00:00.0 7.8759 210
61 500.9847 2022-08-05 00:00:00.0 8.6697 210
62 508.5017 2022-08-06 00:00:00.0 7.5170 210
63 514.5552 2022-08-07 00:00:00.0 6.0535 210
64 522.3761 2022-08-08 00:00:00.0 7.8209 210
65 531.3335 2022-08-09 00:00:00.0 8.9574 210
66 538.8787 2022-08-10 00:00:00.0 7.5452 210
67 545.3508 2022-08-11 00:00:00.0 6.4721 210
68 553.9300 2022-08-12 00:00:00.0 8.5792 210
69 562.2150 2022-08-13 00:00:00.0 8.2850 210
70 570.6835 2022-08-14 00:00:00.0 8.4685 210
71 580.1487 2022-08-15 00:00:00.0 9.4652 210
72 589.4589 2022-08-16 00:00:00.0 9.3102 210
73 597.4589 2022-08-17 00:00:00.0 8.0000 210
74 607.2533 2022-08-18 00:00:00.0 9.7944 210
75 616.8786 2022-08-19 00:00:00.0 9.6253 210
76 624.5470 2022-08-20 00:00:00.0 7.6684 210
77 632.2275 2022-08-21 00:00:00.0 7.6805 210
78 641.3988 2022-08-22 00:00:00.0 9.1713 210
79 650.3429 2022-08-23 00:00:00.0 8.9441 210
80 658.0500 2022-08-24 00:00:00.0 7.7071 210
81 664.4019 2022-08-25 00:00:00.0 6.3519 210
82 672.9364 2022-08-26 00:00:00.0 8.5345 210
83 681.7693 2022-08-27 00:00:00.0 8.8329 210
84 690.5630 2022-08-28 00:00:00.0 8.7937 210
85 699.6176 2022-08-29 00:00:00.0 9.0546 210
86 707.9922 2022-08-30 00:00:00.0 8.3746 210
87 715.9325 2022-08-31 00:00:00.0 7.9403 210
88 723.3840 2022-09-01 00:00:00.0 7.4515 210
89 731.0731 2022-09-02 00:00:00.0 7.6891 210
90 736.6618 2022-09-03 00:00:00.0 5.5887 210
91 744.5490 2022-09-04 00:00:00.0 7.8872 210
92 752.6948 2022-09-05 00:00:00.0 8.1458 210
93 760.8089 2022-09-06 00:00:00.0 8.1141 210
94 766.8842 2022-09-07 00:00:00.0 6.0753 210
95 775.4597 2022-09-08 00:00:00.0 8.5755 210
96 781.6991 2022-09-09 00:00:00.0 6.2394 210
97 785.6663 2022-09-10 00:00:00.0 3.9672 210
98 791.3832 2022-09-11 00:00:00.0 5.7169 210
99 797.6016 2022-09-12 00:00:00.0 6.2184 210
100 802.0216 2022-09-13 00:00:00.0 4.4200 210
101 807.1450 2022-09-14 00:00:00.0 5.1234 210
102 814.3879 2022-09-15 00:00:00.0 7.2429 210
103 820.4141 2022-09-16 00:00:00.0 6.0262 210
104 828.1152 2022-09-17 00:00:00.0 7.7011 210
105 835.8372 2022-09-18 00:00:00.0 7.7220 210
106 842.4602 2022-09-19 00:00:00.0 6.6230 210
107 850.2619 2022-09-20 00:00:00.0 7.8017 210
108 853.9627 2022-09-21 00:00:00.0 3.7008 210
109 856.1958 2022-09-22 00:00:00.0 2.2331 210
110 859.7290 2022-09-23 00:00:00.0 3.5332 210
111 864.5636 2022-09-24 00:00:00.0 4.8346 210
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '210') 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 5 865
9/23/2022 4 860
9/22/2022 2 856
9/21/2022 4 854
9/20/2022 8 850
9/19/2022 7 842
9/18/2022 8 836
9/17/2022 8 828
9/16/2022 6 820
9/15/2022 7 814
9/14/2022 5 807
9/13/2022 4 802
9/12/2022 6 798
9/11/2022 6 791
9/10/2022 4 786
9/9/2022 6 782
9/8/2022 9 775
9/7/2022 6 767
9/6/2022 8 761
9/5/2022 8 753
9/4/2022 8 745
9/3/2022 6 737
9/2/2022 8 731
9/1/2022 7 723
8/31/2022 8 716
8/30/2022 8 708
8/29/2022 9 700
8/28/2022 9 691
8/27/2022 9 682
8/26/2022 9 673
8/25/2022 6 664
8/24/2022 8 658
8/23/2022 9 650
8/22/2022 9 641
8/21/2022 8 632
8/20/2022 8 625
8/19/2022 10 617
8/18/2022 10 607
8/17/2022 8 597
8/16/2022 9 589
8/15/2022 9 580
8/14/2022 8 571
8/13/2022 8 562
8/12/2022 9 554
8/11/2022 6 545
8/10/2022 8 539
8/9/2022 9 531
8/8/2022 8 522
8/7/2022 6 515
8/6/2022 8 509
8/5/2022 9 501
8/4/2022 8 492
8/3/2022 8 484
8/2/2022 8 476
8/1/2022 8 468
7/31/2022 8 460
7/30/2022 8 452
7/29/2022 8 444
7/28/2022 8 437
7/27/2022 9 428
7/26/2022 9 420
7/25/2022 8 411
7/24/2022 8 403
7/23/2022 9 395
7/22/2022 9 385
7/21/2022 9 376
7/20/2022 9 367
7/19/2022 9 359
7/18/2022 8 350
7/17/2022 7 342
7/16/2022 9 335
7/15/2022 8 327
7/14/2022 10 319
7/13/2022 8 309
7/12/2022 9 301
7/11/2022 9 291
7/10/2022 9 282
7/9/2022 8 273
7/8/2022 8 264
7/7/2022 9 256
7/6/2022 9 247
7/5/2022 9 238
7/4/2022 9 229
7/3/2022 9 219
7/2/2022 7 211
7/1/2022 8 204
6/30/2022 9 196
6/29/2022 8 187
6/28/2022 8 180
6/27/2022 8 172
6/26/2022 8 164
6/25/2022 8 156
6/24/2022 9 148
6/23/2022 6 139
6/22/2022 8 132
6/21/2022 9 124
6/20/2022 7 116
6/19/2022 4 109
6/18/2022 9 104
6/17/2022 9 95
6/16/2022 9 86
6/15/2022 9 78
6/14/2022 9 69
6/13/2022 9 60
6/12/2022 9 51
6/11/2022 9 42
6/10/2022 8 33
6/9/2022 6 25
6/8/2022 6 19
6/7/2022 6 13