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.6918 2022-06-06 00:00:00.0 4.6918 559
2 10.6934 2022-06-07 00:00:00.0 6.0016 559
3 16.6691 2022-06-08 00:00:00.0 5.9757 559
4 23.1218 2022-06-09 00:00:00.0 6.4527 559
5 31.7730 2022-06-10 00:00:00.0 8.6512 559
6 40.6297 2022-06-11 00:00:00.0 8.8567 559
7 49.6003 2022-06-12 00:00:00.0 8.9706 559
8 58.7291 2022-06-13 00:00:00.0 9.1288 559
9 67.7138 2022-06-14 00:00:00.0 8.9847 559
10 75.6752 2022-06-15 00:00:00.0 7.9614 559
11 84.0293 2022-06-16 00:00:00.0 8.3541 559
12 92.2511 2022-06-17 00:00:00.0 8.2218 559
13 100.5298 2022-06-18 00:00:00.0 8.2787 559
14 104.1045 2022-06-19 00:00:00.0 3.5747 559
15 113.2075 2022-06-20 00:00:00.0 9.1030 559
16 122.2320 2022-06-21 00:00:00.0 9.0245 559
17 130.3850 2022-06-22 00:00:00.0 8.1530 559
18 137.8072 2022-06-23 00:00:00.0 7.4222 559
19 147.2419 2022-06-24 00:00:00.0 9.4347 559
20 154.6270 2022-06-25 00:00:00.0 7.3851 559
21 162.5183 2022-06-26 00:00:00.0 7.8913 559
22 170.5337 2022-06-27 00:00:00.0 8.0154 559
23 178.8256 2022-06-28 00:00:00.0 8.2919 559
24 186.9746 2022-06-29 00:00:00.0 8.1490 559
25 196.0478 2022-06-30 00:00:00.0 9.0732 559
26 202.8182 2022-07-01 00:00:00.0 6.7704 559
27 210.5839 2022-07-02 00:00:00.0 7.7657 559
28 219.2919 2022-07-03 00:00:00.0 8.7080 559
29 228.8671 2022-07-04 00:00:00.0 9.5752 559
30 238.2736 2022-07-05 00:00:00.0 9.4065 559
31 246.8069 2022-07-06 00:00:00.0 8.5333 559
32 256.0020 2022-07-07 00:00:00.0 9.1951 559
33 264.1962 2022-07-08 00:00:00.0 8.1942 559
34 272.1618 2022-07-09 00:00:00.0 7.9656 559
35 280.9233 2022-07-10 00:00:00.0 8.7615 559
36 290.2190 2022-07-11 00:00:00.0 9.2957 559
37 299.2023 2022-07-12 00:00:00.0 8.9833 559
38 307.5726 2022-07-13 00:00:00.0 8.3703 559
39 317.1742 2022-07-14 00:00:00.0 9.6016 559
40 325.6703 2022-07-15 00:00:00.0 8.4961 559
41 333.8367 2022-07-16 00:00:00.0 8.1664 559
42 339.5996 2022-07-17 00:00:00.0 5.7629 559
43 347.8960 2022-07-18 00:00:00.0 8.2964 559
44 357.4433 2022-07-19 00:00:00.0 9.5473 559
45 366.4719 2022-07-20 00:00:00.0 9.0286 559
46 375.1483 2022-07-21 00:00:00.0 8.6764 559
47 383.6731 2022-07-22 00:00:00.0 8.5248 559
48 392.8369 2022-07-23 00:00:00.0 9.1638 559
49 401.2330 2022-07-24 00:00:00.0 8.3961 559
50 409.2914 2022-07-25 00:00:00.0 8.0584 559
51 417.8507 2022-07-26 00:00:00.0 8.5593 559
52 426.0778 2022-07-27 00:00:00.0 8.2271 559
53 434.3909 2022-07-28 00:00:00.0 8.3131 559
54 442.3277 2022-07-29 00:00:00.0 7.9368 559
55 449.9109 2022-07-30 00:00:00.0 7.5832 559
56 458.7437 2022-07-31 00:00:00.0 8.8328 559
57 467.0471 2022-08-01 00:00:00.0 8.3034 559
58 474.8119 2022-08-02 00:00:00.0 7.7648 559
59 483.6462 2022-08-03 00:00:00.0 8.8343 559
60 491.6867 2022-08-04 00:00:00.0 8.0405 559
61 500.8923 2022-08-05 00:00:00.0 9.2056 559
62 508.3574 2022-08-06 00:00:00.0 7.4651 559
63 514.9119 2022-08-07 00:00:00.0 6.5545 559
64 522.6492 2022-08-08 00:00:00.0 7.7373 559
65 531.1990 2022-08-09 00:00:00.0 8.5498 559
66 538.5081 2022-08-10 00:00:00.0 7.3091 559
67 545.2114 2022-08-11 00:00:00.0 6.7033 559
68 554.5934 2022-08-12 00:00:00.0 9.3820 559
69 563.0944 2022-08-13 00:00:00.0 8.5010 559
70 570.8767 2022-08-14 00:00:00.0 7.7823 559
71 579.8310 2022-08-15 00:00:00.0 8.9543 559
72 588.1589 2022-08-16 00:00:00.0 8.3279 559
73 596.0792 2022-08-17 00:00:00.0 7.9203 559
74 605.7643 2022-08-18 00:00:00.0 9.6851 559
75 614.8133 2022-08-19 00:00:00.0 9.0490 559
76 621.5942 2022-08-20 00:00:00.0 6.7809 559
77 629.1494 2022-08-21 00:00:00.0 7.5552 559
78 638.0500 2022-08-22 00:00:00.0 8.9006 559
79 646.8110 2022-08-23 00:00:00.0 8.7610 559
80 654.9766 2022-08-24 00:00:00.0 8.1656 559
81 661.2275 2022-08-25 00:00:00.0 6.2509 559
82 669.1670 2022-08-26 00:00:00.0 7.9395 559
83 677.1824 2022-08-27 00:00:00.0 8.0154 559
84 686.4088 2022-08-28 00:00:00.0 9.2264 559
85 694.9310 2022-08-29 00:00:00.0 8.5222 559
86 702.1032 2022-08-30 00:00:00.0 7.1722 559
87 709.2682 2022-08-31 00:00:00.0 7.1650 559
88 716.3184 2022-09-01 00:00:00.0 7.0502 559
89 724.0368 2022-09-02 00:00:00.0 7.7184 559
90 730.3207 2022-09-03 00:00:00.0 6.2839 559
91 738.9885 2022-09-04 00:00:00.0 8.6678 559
92 748.2076 2022-09-05 00:00:00.0 9.2191 559
93 755.8875 2022-09-06 00:00:00.0 7.6799 559
94 762.2860 2022-09-07 00:00:00.0 6.3985 559
95 770.1296 2022-09-08 00:00:00.0 7.8436 559
96 775.2500 2022-09-09 00:00:00.0 5.1204 559
97 780.1100 2022-09-10 00:00:00.0 4.8600 559
98 786.4876 2022-09-11 00:00:00.0 6.3776 559
99 793.7055 2022-09-12 00:00:00.0 7.2179 559
100 797.6096 2022-09-13 00:00:00.0 3.9041 559
101 803.0142 2022-09-14 00:00:00.0 5.4046 559
102 810.1387 2022-09-15 00:00:00.0 7.1245 559
103 815.2657 2022-09-16 00:00:00.0 5.1270 559
104 821.6156 2022-09-17 00:00:00.0 6.3499 559
105 829.1815 2022-09-18 00:00:00.0 7.5659 559
106 835.0024 2022-09-19 00:00:00.0 5.8209 559
107 841.9802 2022-09-20 00:00:00.0 6.9778 559
108 844.2306 2022-09-21 00:00:00.0 2.2504 559
109 846.9841 2022-09-22 00:00:00.0 2.7535 559
110 853.1448 2022-09-23 00:00:00.0 6.1607 559
111 860.6430 2022-09-24 00:00:00.0 7.4982 559
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '559') 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 861
9/23/2022 6 853
9/22/2022 3 847
9/21/2022 2 844
9/20/2022 7 842
9/19/2022 6 835
9/18/2022 8 829
9/17/2022 6 822
9/16/2022 5 815
9/15/2022 7 810
9/14/2022 5 803
9/13/2022 4 798
9/12/2022 7 794
9/11/2022 6 786
9/10/2022 5 780
9/9/2022 5 775
9/8/2022 8 770
9/7/2022 6 762
9/6/2022 8 756
9/5/2022 9 748
9/4/2022 9 739
9/3/2022 6 730
9/2/2022 8 724
9/1/2022 7 716
8/31/2022 7 709
8/30/2022 7 702
8/29/2022 9 695
8/28/2022 9 686
8/27/2022 8 677
8/26/2022 8 669
8/25/2022 6 661
8/24/2022 8 655
8/23/2022 9 647
8/22/2022 9 638
8/21/2022 8 629
8/20/2022 7 622
8/19/2022 9 615
8/18/2022 10 606
8/17/2022 8 596
8/16/2022 8 588
8/15/2022 9 580
8/14/2022 8 571
8/13/2022 9 563
8/12/2022 9 555
8/11/2022 7 545
8/10/2022 7 539
8/9/2022 9 531
8/8/2022 8 523
8/7/2022 7 515
8/6/2022 7 508
8/5/2022 9 501
8/4/2022 8 492
8/3/2022 9 484
8/2/2022 8 475
8/1/2022 8 467
7/31/2022 9 459
7/30/2022 8 450
7/29/2022 8 442
7/28/2022 8 434
7/27/2022 8 426
7/26/2022 9 418
7/25/2022 8 409
7/24/2022 8 401
7/23/2022 9 393
7/22/2022 9 384
7/21/2022 9 375
7/20/2022 9 366
7/19/2022 10 357
7/18/2022 8 348
7/17/2022 6 340
7/16/2022 8 334
7/15/2022 8 326
7/14/2022 10 317
7/13/2022 8 308
7/12/2022 9 299
7/11/2022 9 290
7/10/2022 9 281
7/9/2022 8 272
7/8/2022 8 264
7/7/2022 9 256
7/6/2022 9 247
7/5/2022 9 238
7/4/2022 10 229
7/3/2022 9 219
7/2/2022 8 211
7/1/2022 7 203
6/30/2022 9 196
6/29/2022 8 187
6/28/2022 8 179
6/27/2022 8 171
6/26/2022 8 163
6/25/2022 7 155
6/24/2022 9 147
6/23/2022 7 138
6/22/2022 8 130
6/21/2022 9 122
6/20/2022 9 113
6/19/2022 4 104
6/18/2022 8 101
6/17/2022 8 92
6/16/2022 8 84
6/15/2022 8 76
6/14/2022 9 68
6/13/2022 9 59
6/12/2022 9 50
6/11/2022 9 41
6/10/2022 9 32
6/9/2022 6 23
6/8/2022 6 17
6/7/2022 6 11