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.0770 2022-06-06 00:00:00.0 6.0770 230
2 13.1414 2022-06-07 00:00:00.0 7.0644 230
3 19.5340 2022-06-08 00:00:00.0 6.3926 230
4 25.8314 2022-06-09 00:00:00.0 6.2974 230
5 34.8672 2022-06-10 00:00:00.0 9.0358 230
6 43.1770 2022-06-11 00:00:00.0 8.3098 230
7 52.0877 2022-06-12 00:00:00.0 8.9107 230
8 59.7137 2022-06-13 00:00:00.0 7.6260 230
9 69.1279 2022-06-14 00:00:00.0 9.4142 230
10 77.9607 2022-06-15 00:00:00.0 8.8328 230
11 86.7119 2022-06-16 00:00:00.0 8.7512 230
12 94.9621 2022-06-17 00:00:00.0 8.2502 230
13 103.1536 2022-06-18 00:00:00.0 8.1915 230
14 106.5006 2022-06-19 00:00:00.0 3.3470 230
15 113.6186 2022-06-20 00:00:00.0 7.1180 230
16 122.6225 2022-06-21 00:00:00.0 9.0039 230
17 130.3333 2022-06-22 00:00:00.0 7.7108 230
18 136.6303 2022-06-23 00:00:00.0 6.2970 230
19 145.1487 2022-06-24 00:00:00.0 8.5184 230
20 153.0879 2022-06-25 00:00:00.0 7.9392 230
21 161.2808 2022-06-26 00:00:00.0 8.1929 230
22 169.6137 2022-06-27 00:00:00.0 8.3329 230
23 178.0088 2022-06-28 00:00:00.0 8.3951 230
24 185.2145 2022-06-29 00:00:00.0 7.2057 230
25 194.3380 2022-06-30 00:00:00.0 9.1235 230
26 202.4720 2022-07-01 00:00:00.0 8.1340 230
27 209.1778 2022-07-02 00:00:00.0 6.7058 230
28 217.4463 2022-07-03 00:00:00.0 8.2685 230
29 227.2578 2022-07-04 00:00:00.0 9.8115 230
30 236.0205 2022-07-05 00:00:00.0 8.7627 230
31 244.2978 2022-07-06 00:00:00.0 8.2773 230
32 253.5964 2022-07-07 00:00:00.0 9.2986 230
33 261.6881 2022-07-08 00:00:00.0 8.0917 230
34 269.0963 2022-07-09 00:00:00.0 7.4082 230
35 276.3698 2022-07-10 00:00:00.0 7.2735 230
36 285.5983 2022-07-11 00:00:00.0 9.2285 230
37 294.5504 2022-07-12 00:00:00.0 8.9521 230
38 302.7054 2022-07-13 00:00:00.0 8.1550 230
39 312.1543 2022-07-14 00:00:00.0 9.4489 230
40 319.8406 2022-07-15 00:00:00.0 7.6863 230
41 328.0162 2022-07-16 00:00:00.0 8.1756 230
42 333.1751 2022-07-17 00:00:00.0 5.1589 230
43 339.1419 2022-07-18 00:00:00.0 5.9668 230
44 348.5952 2022-07-19 00:00:00.0 9.4533 230
45 357.5007 2022-07-20 00:00:00.0 8.9055 230
46 366.4699 2022-07-21 00:00:00.0 8.9692 230
47 373.4102 2022-07-22 00:00:00.0 6.9403 230
48 382.7412 2022-07-23 00:00:00.0 9.3310 230
49 390.9412 2022-07-24 00:00:00.0 8.2000 230
50 398.4313 2022-07-25 00:00:00.0 7.4901 230
51 407.6269 2022-07-26 00:00:00.0 9.1956 230
52 416.3289 2022-07-27 00:00:00.0 8.7020 230
53 424.9485 2022-07-28 00:00:00.0 8.6196 230
54 432.4400 2022-07-29 00:00:00.0 7.4915 230
55 439.7471 2022-07-30 00:00:00.0 7.3071 230
56 448.2178 2022-07-31 00:00:00.0 8.4707 230
57 456.3259 2022-08-01 00:00:00.0 8.1081 230
58 464.1329 2022-08-02 00:00:00.0 7.8070 230
59 472.9078 2022-08-03 00:00:00.0 8.7749 230
60 480.6864 2022-08-04 00:00:00.0 7.7786 230
61 488.7024 2022-08-05 00:00:00.0 8.0160 230
62 496.9104 2022-08-06 00:00:00.0 8.2080 230
63 503.5604 2022-08-07 00:00:00.0 6.6500 230
64 511.4621 2022-08-08 00:00:00.0 7.9017 230
65 519.3313 2022-08-09 00:00:00.0 7.8692 230
66 527.5864 2022-08-10 00:00:00.0 8.2551 230
67 533.9041 2022-08-11 00:00:00.0 6.3177 230
68 542.2254 2022-08-12 00:00:00.0 8.3213 230
69 550.4956 2022-08-13 00:00:00.0 8.2702 230
70 557.9284 2022-08-14 00:00:00.0 7.4328 230
71 567.3297 2022-08-15 00:00:00.0 9.4013 230
72 574.8208 2022-08-16 00:00:00.0 7.4911 230
73 582.2193 2022-08-17 00:00:00.0 7.3985 230
74 591.6711 2022-08-18 00:00:00.0 9.4518 230
75 600.4731 2022-08-19 00:00:00.0 8.8020 230
76 608.0785 2022-08-20 00:00:00.0 7.6054 230
77 614.9797 2022-08-21 00:00:00.0 6.9012 230
78 621.3240 2022-08-22 00:00:00.0 6.3443 230
79 628.9573 2022-08-23 00:00:00.0 7.6333 230
80 637.7606 2022-08-24 00:00:00.0 8.8033 230
81 644.7933 2022-08-25 00:00:00.0 7.0327 230
82 653.5624 2022-08-26 00:00:00.0 8.7691 230
83 662.2042 2022-08-27 00:00:00.0 8.6418 230
84 671.3984 2022-08-28 00:00:00.0 9.1942 230
85 680.7176 2022-08-29 00:00:00.0 9.3192 230
86 688.2642 2022-08-30 00:00:00.0 7.5466 230
87 695.2365 2022-08-31 00:00:00.0 6.9723 230
88 702.4328 2022-09-01 00:00:00.0 7.1963 230
89 709.9716 2022-09-02 00:00:00.0 7.5388 230
90 716.1274 2022-09-03 00:00:00.0 6.1558 230
91 723.0740 2022-09-04 00:00:00.0 6.9466 230
92 730.9678 2022-09-05 00:00:00.0 7.8938 230
93 738.2974 2022-09-06 00:00:00.0 7.3296 230
94 744.7364 2022-09-07 00:00:00.0 6.4390 230
95 753.0066 2022-09-08 00:00:00.0 8.2702 230
96 760.0498 2022-09-09 00:00:00.0 7.0432 230
97 765.4478 2022-09-10 00:00:00.0 5.3980 230
98 771.4981 2022-09-11 00:00:00.0 6.0503 230
99 778.4368 2022-09-12 00:00:00.0 6.9387 230
100 785.4800 2022-09-13 00:00:00.0 7.0432 230
101 790.4829 2022-09-14 00:00:00.0 5.0029 230
102 797.5669 2022-09-15 00:00:00.0 7.0840 230
103 803.3294 2022-09-16 00:00:00.0 5.7625 230
104 810.7551 2022-09-17 00:00:00.0 7.4257 230
105 817.8253 2022-09-18 00:00:00.0 7.0702 230
106 824.3143 2022-09-19 00:00:00.0 6.4890 230
107 832.1283 2022-09-20 00:00:00.0 7.8140 230
108 835.8040 2022-09-21 00:00:00.0 3.6757 230
109 838.4204 2022-09-22 00:00:00.0 2.6164 230
110 843.5824 2022-09-23 00:00:00.0 5.1620 230
111 851.3283 2022-09-24 00:00:00.0 7.7459 230
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '230') 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 851
9/23/2022 5 844
9/22/2022 3 838
9/21/2022 4 836
9/20/2022 8 832
9/19/2022 6 824
9/18/2022 7 818
9/17/2022 7 811
9/16/2022 6 803
9/15/2022 7 798
9/14/2022 5 790
9/13/2022 7 785
9/12/2022 7 778
9/11/2022 6 771
9/10/2022 5 765
9/9/2022 7 760
9/8/2022 8 753
9/7/2022 6 745
9/6/2022 7 738
9/5/2022 8 731
9/4/2022 7 723
9/3/2022 6 716
9/2/2022 8 710
9/1/2022 7 702
8/31/2022 7 695
8/30/2022 8 688
8/29/2022 9 681
8/28/2022 9 671
8/27/2022 9 662
8/26/2022 9 654
8/25/2022 7 645
8/24/2022 9 638
8/23/2022 8 629
8/22/2022 6 621
8/21/2022 7 615
8/20/2022 8 608
8/19/2022 9 600
8/18/2022 9 592
8/17/2022 7 582
8/16/2022 7 575
8/15/2022 9 567
8/14/2022 7 558
8/13/2022 8 550
8/12/2022 8 542
8/11/2022 6 534
8/10/2022 8 528
8/9/2022 8 519
8/8/2022 8 511
8/7/2022 7 504
8/6/2022 8 497
8/5/2022 8 489
8/4/2022 8 481
8/3/2022 9 473
8/2/2022 8 464
8/1/2022 8 456
7/31/2022 8 448
7/30/2022 7 440
7/29/2022 7 432
7/28/2022 9 425
7/27/2022 9 416
7/26/2022 9 408
7/25/2022 7 398
7/24/2022 8 391
7/23/2022 9 383
7/22/2022 7 373
7/21/2022 9 366
7/20/2022 9 358
7/19/2022 9 349
7/18/2022 6 339
7/17/2022 5 333
7/16/2022 8 328
7/15/2022 8 320
7/14/2022 9 312
7/13/2022 8 303
7/12/2022 9 295
7/11/2022 9 286
7/10/2022 7 276
7/9/2022 7 269
7/8/2022 8 262
7/7/2022 9 254
7/6/2022 8 244
7/5/2022 9 236
7/4/2022 10 227
7/3/2022 8 217
7/2/2022 7 209
7/1/2022 8 202
6/30/2022 9 194
6/29/2022 7 185
6/28/2022 8 178
6/27/2022 8 170
6/26/2022 8 161
6/25/2022 8 153
6/24/2022 9 145
6/23/2022 6 137
6/22/2022 8 130
6/21/2022 9 123
6/20/2022 7 114
6/19/2022 3 107
6/18/2022 8 103
6/17/2022 8 95
6/16/2022 9 87
6/15/2022 9 78
6/14/2022 9 69
6/13/2022 8 60
6/12/2022 9 52
6/11/2022 8 43
6/10/2022 9 35
6/9/2022 6 26
6/8/2022 6 20
6/7/2022 7 13