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.0304 2022-06-06 00:00:00.0 5.0304 548
2 10.3872 2022-06-07 00:00:00.0 5.3568 548
3 16.3773 2022-06-08 00:00:00.0 5.9901 548
4 22.9104 2022-06-09 00:00:00.0 6.5331 548
5 30.6706 2022-06-10 00:00:00.0 7.7602 548
6 38.7337 2022-06-11 00:00:00.0 8.0631 548
7 47.8624 2022-06-12 00:00:00.0 9.1287 548
8 56.7411 2022-06-13 00:00:00.0 8.8787 548
9 63.9631 2022-06-14 00:00:00.0 7.2220 548
10 69.2206 2022-06-15 00:00:00.0 5.2575 548
11 77.0389 2022-06-16 00:00:00.0 7.8183 548
12 85.1879 2022-06-17 00:00:00.0 8.1490 548
13 92.3507 2022-06-18 00:00:00.0 7.1628 548
14 98.4371 2022-06-19 00:00:00.0 6.0864 548
15 108.0102 2022-06-20 00:00:00.0 9.5731 548
16 117.0330 2022-06-21 00:00:00.0 9.0228 548
17 124.9761 2022-06-22 00:00:00.0 7.9431 548
18 132.3580 2022-06-23 00:00:00.0 7.3819 548
19 141.0997 2022-06-24 00:00:00.0 8.7417 548
20 147.4039 2022-06-25 00:00:00.0 6.3042 548
21 154.6360 2022-06-26 00:00:00.0 7.2321 548
22 162.7661 2022-06-27 00:00:00.0 8.1301 548
23 170.5555 2022-06-28 00:00:00.0 7.7894 548
24 178.4520 2022-06-29 00:00:00.0 7.8965 548
25 186.5384 2022-06-30 00:00:00.0 8.0864 548
26 193.5565 2022-07-01 00:00:00.0 7.0181 548
27 200.4245 2022-07-02 00:00:00.0 6.8680 548
28 209.0213 2022-07-03 00:00:00.0 8.5968 548
29 218.4830 2022-07-04 00:00:00.0 9.4617 548
30 227.5334 2022-07-05 00:00:00.0 9.0504 548
31 236.2602 2022-07-06 00:00:00.0 8.7268 548
32 244.7761 2022-07-07 00:00:00.0 8.5159 548
33 252.6369 2022-07-08 00:00:00.0 7.8608 548
34 260.7353 2022-07-09 00:00:00.0 8.0984 548
35 269.6524 2022-07-10 00:00:00.0 8.9171 548
36 278.7755 2022-07-11 00:00:00.0 9.1231 548
37 287.7240 2022-07-12 00:00:00.0 8.9485 548
38 296.1094 2022-07-13 00:00:00.0 8.3854 548
39 305.1769 2022-07-14 00:00:00.0 9.0675 548
40 313.4793 2022-07-15 00:00:00.0 8.3024 548
41 321.7955 2022-07-16 00:00:00.0 8.3162 548
42 328.5768 2022-07-17 00:00:00.0 6.7813 548
43 336.9049 2022-07-18 00:00:00.0 8.3281 548
44 346.4373 2022-07-19 00:00:00.0 9.5324 548
45 355.4659 2022-07-20 00:00:00.0 9.0286 548
46 363.8810 2022-07-21 00:00:00.0 8.4151 548
47 372.6092 2022-07-22 00:00:00.0 8.7282 548
48 381.0301 2022-07-23 00:00:00.0 8.4209 548
49 387.6937 2022-07-24 00:00:00.0 6.6636 548
50 394.9258 2022-07-25 00:00:00.0 7.2321 548
51 403.6083 2022-07-26 00:00:00.0 8.6825 548
52 411.0548 2022-07-27 00:00:00.0 7.4465 548
53 419.1691 2022-07-28 00:00:00.0 8.1143 548
54 426.1830 2022-07-29 00:00:00.0 7.0139 548
55 433.4945 2022-07-30 00:00:00.0 7.3115 548
56 441.8737 2022-07-31 00:00:00.0 8.3792 548
57 450.1235 2022-08-01 00:00:00.0 8.2498 548
58 458.2791 2022-08-02 00:00:00.0 8.1556 548
59 466.5579 2022-08-03 00:00:00.0 8.2788 548
60 474.2212 2022-08-04 00:00:00.0 7.6633 548
61 483.5169 2022-08-05 00:00:00.0 9.2957 548
62 489.5339 2022-08-06 00:00:00.0 6.0170 548
63 495.1935 2022-08-07 00:00:00.0 5.6596 548
64 502.3704 2022-08-08 00:00:00.0 7.1769 548
65 510.3713 2022-08-09 00:00:00.0 8.0009 548
66 517.3596 2022-08-10 00:00:00.0 6.9883 548
67 524.6220 2022-08-11 00:00:00.0 7.2624 548
68 533.7542 2022-08-12 00:00:00.0 9.1322 548
69 541.9140 2022-08-13 00:00:00.0 8.1598 548
70 550.2589 2022-08-14 00:00:00.0 8.3449 548
71 558.8335 2022-08-15 00:00:00.0 8.5746 548
72 566.9183 2022-08-16 00:00:00.0 8.0848 548
73 575.7417 2022-08-17 00:00:00.0 8.8234 548
74 584.7712 2022-08-18 00:00:00.0 9.0295 548
75 593.8799 2022-08-19 00:00:00.0 9.1087 548
76 601.3313 2022-08-20 00:00:00.0 7.4514 548
77 608.5969 2022-08-21 00:00:00.0 7.2656 548
78 617.4016 2022-08-22 00:00:00.0 8.8047 548
79 626.8567 2022-08-23 00:00:00.0 9.4551 548
80 635.1802 2022-08-24 00:00:00.0 8.3235 548
81 641.6339 2022-08-25 00:00:00.0 6.4537 548
82 649.1271 2022-08-26 00:00:00.0 7.4932 548
83 657.0892 2022-08-27 00:00:00.0 7.9621 548
84 665.8270 2022-08-28 00:00:00.0 8.7378 548
85 674.1626 2022-08-29 00:00:00.0 8.3356 548
86 681.1814 2022-08-30 00:00:00.0 7.0188 548
87 688.3158 2022-08-31 00:00:00.0 7.1344 548
88 695.2630 2022-09-01 00:00:00.0 6.9472 548
89 701.4812 2022-09-02 00:00:00.0 6.2182 548
90 707.9717 2022-09-03 00:00:00.0 6.4905 548
91 715.5241 2022-09-04 00:00:00.0 7.5524 548
92 723.8434 2022-09-05 00:00:00.0 8.3193 548
93 731.0197 2022-09-06 00:00:00.0 7.1763 548
94 736.9476 2022-09-07 00:00:00.0 5.9279 548
95 744.2546 2022-09-08 00:00:00.0 7.3070 548
96 748.7439 2022-09-09 00:00:00.0 4.4893 548
97 752.8898 2022-09-10 00:00:00.0 4.1459 548
98 758.0559 2022-09-11 00:00:00.0 5.1661 548
99 763.9680 2022-09-12 00:00:00.0 5.9121 548
100 767.6000 2022-09-13 00:00:00.0 3.6320 548
101 773.2365 2022-09-14 00:00:00.0 5.6365 548
102 780.2195 2022-09-15 00:00:00.0 6.9830 548
103 784.8089 2022-09-16 00:00:00.0 4.5894 548
104 789.8347 2022-09-17 00:00:00.0 5.0258 548
105 796.7535 2022-09-18 00:00:00.0 6.9188 548
106 801.6522 2022-09-19 00:00:00.0 4.8987 548
107 805.9049 2022-09-20 00:00:00.0 4.2527 548
108 807.7456 2022-09-21 00:00:00.0 1.8407 548
109 810.1798 2022-09-22 00:00:00.0 2.4342 548
110 813.3576 2022-09-23 00:00:00.0 3.1778 548
111 819.1549 2022-09-24 00:00:00.0 5.7973 548
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '548') 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 6 819
9/23/2022 3 813
9/22/2022 2 810
9/21/2022 2 808
9/20/2022 4 806
9/19/2022 5 802
9/18/2022 7 797
9/17/2022 5 790
9/16/2022 5 785
9/15/2022 7 780
9/14/2022 6 773
9/13/2022 4 768
9/12/2022 6 764
9/11/2022 5 758
9/10/2022 4 753
9/9/2022 4 749
9/8/2022 7 744
9/7/2022 6 737
9/6/2022 7 731
9/5/2022 8 724
9/4/2022 8 716
9/3/2022 6 708
9/2/2022 6 701
9/1/2022 7 695
8/31/2022 7 688
8/30/2022 7 681
8/29/2022 8 674
8/28/2022 9 666
8/27/2022 8 657
8/26/2022 7 649
8/25/2022 6 642
8/24/2022 8 635
8/23/2022 9 627
8/22/2022 9 617
8/21/2022 7 609
8/20/2022 7 601
8/19/2022 9 594
8/18/2022 9 585
8/17/2022 9 576
8/16/2022 8 567
8/15/2022 9 559
8/14/2022 8 550
8/13/2022 8 542
8/12/2022 9 534
8/11/2022 7 525
8/10/2022 7 517
8/9/2022 8 510
8/8/2022 7 502
8/7/2022 6 495
8/6/2022 6 490
8/5/2022 9 484
8/4/2022 8 474
8/3/2022 8 467
8/2/2022 8 458
8/1/2022 8 450
7/31/2022 8 442
7/30/2022 7 433
7/29/2022 7 426
7/28/2022 8 419
7/27/2022 7 411
7/26/2022 9 404
7/25/2022 7 395
7/24/2022 7 388
7/23/2022 8 381
7/22/2022 9 373
7/21/2022 8 364
7/20/2022 9 355
7/19/2022 10 346
7/18/2022 8 337
7/17/2022 7 329
7/16/2022 8 322
7/15/2022 8 313
7/14/2022 9 305
7/13/2022 8 296
7/12/2022 9 288
7/11/2022 9 279
7/10/2022 9 270
7/9/2022 8 261
7/8/2022 8 253
7/7/2022 9 245
7/6/2022 9 236
7/5/2022 9 228
7/4/2022 9 218
7/3/2022 9 209
7/2/2022 7 200
7/1/2022 7 194
6/30/2022 8 187
6/29/2022 8 178
6/28/2022 8 171
6/27/2022 8 163
6/26/2022 7 155
6/25/2022 6 147
6/24/2022 9 141
6/23/2022 7 132
6/22/2022 8 125
6/21/2022 9 117
6/20/2022 10 108
6/19/2022 6 98
6/18/2022 7 92
6/17/2022 8 85
6/16/2022 8 77
6/15/2022 5 69
6/14/2022 7 64
6/13/2022 9 57
6/12/2022 9 48
6/11/2022 8 39
6/10/2022 8 31
6/9/2022 7 23
6/8/2022 6 16
6/7/2022 5 10