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 7.9778 2025-06-01 00:00:00.0 7.9778 548
2 14.8140 2025-06-02 00:00:00.0 6.8362 548
3 22.4187 2025-06-03 00:00:00.0 7.6047 548
4 28.0754 2025-06-04 00:00:00.0 5.6567 548
5 33.6393 2025-06-05 00:00:00.0 5.5639 548
6 38.7854 2025-06-06 00:00:00.0 5.1461 548
7 44.4762 2025-06-07 00:00:00.0 5.6908 548
8 51.1570 2025-06-08 00:00:00.0 6.6808 548
9 54.0525 2025-06-09 00:00:00.0 2.8955 548
10 60.6320 2025-06-10 00:00:00.0 6.5795 548
11 67.2405 2025-06-11 00:00:00.0 6.6085 548
12 72.9539 2025-06-12 00:00:00.0 5.7134 548
13 78.9270 2025-06-13 00:00:00.0 5.9731 548
14 86.8638 2025-06-14 00:00:00.0 7.9368 548
15 94.0804 2025-06-15 00:00:00.0 7.2166 548
16 102.2794 2025-06-16 00:00:00.0 8.1990 548
17 111.3891 2025-06-17 00:00:00.0 9.1097 548
18 119.6425 2025-06-18 00:00:00.0 8.2534 548
19 127.7624 2025-06-19 00:00:00.0 8.1199 548
20 135.7588 2025-06-20 00:00:00.0 7.9964 548
21 144.4242 2025-06-21 00:00:00.0 8.6654 548
22 153.4505 2025-06-22 00:00:00.0 9.0263 548
23 160.6942 2025-06-23 00:00:00.0 7.2437 548
24 164.1630 2025-06-24 00:00:00.0 3.4688 548
25 170.0974 2025-06-25 00:00:00.0 5.9344 548
26 177.0255 2025-06-26 00:00:00.0 6.9281 548
27 185.3082 2025-06-27 00:00:00.0 8.2827 548
28 193.4540 2025-06-28 00:00:00.0 8.1458 548
29 201.8215 2025-06-29 00:00:00.0 8.3675 548
30 210.3270 2025-06-30 00:00:00.0 8.5055 548
31 219.0285 2025-07-01 00:00:00.0 8.7015 548
32 227.0200 2025-07-02 00:00:00.0 7.9915 548
33 235.5037 2025-07-03 00:00:00.0 8.4837 548
34 242.7437 2025-07-04 00:00:00.0 7.2400 548
35 250.8502 2025-07-05 00:00:00.0 8.1065 548
36 258.2278 2025-07-06 00:00:00.0 7.3776 548
37 265.4703 2025-07-07 00:00:00.0 7.2425 548
38 272.2310 2025-07-08 00:00:00.0 6.7607 548
39 278.7443 2025-07-09 00:00:00.0 6.5133 548
40 286.1212 2025-07-10 00:00:00.0 7.3769 548
41 294.5809 2025-07-11 00:00:00.0 8.4597 548
42 301.6808 2025-07-12 00:00:00.0 7.0999 548
43 308.9652 2025-07-13 00:00:00.0 7.2844 548
44 317.3682 2025-07-14 00:00:00.0 8.4030 548
45 325.9974 2025-07-15 00:00:00.0 8.6292 548
46 333.0009 2025-07-16 00:00:00.0 7.0035 548
47 336.5782 2025-07-17 00:00:00.0 3.5773 548
48 341.7743 2025-07-18 00:00:00.0 5.1961 548
49 348.5760 2025-07-19 00:00:00.0 6.8017 548
50 355.9383 2025-07-20 00:00:00.0 7.3623 548
51 364.9597 2025-07-21 00:00:00.0 9.0214 548
52 373.4997 2025-07-22 00:00:00.0 8.5400 548
53 382.6414 2025-07-23 00:00:00.0 9.1417 548
54 391.8445 2025-07-24 00:00:00.0 9.2031 548
55 399.2329 2025-07-25 00:00:00.0 7.3884 548
56 406.6042 2025-07-26 00:00:00.0 7.3713 548
57 414.7947 2025-07-27 00:00:00.0 8.1905 548
58 423.4905 2025-07-28 00:00:00.0 8.6958 548
59 431.8287 2025-07-29 00:00:00.0 8.3382 548
60 439.0547 2025-07-30 00:00:00.0 7.2260 548
61 446.0318 2025-07-31 00:00:00.0 6.9771 548
62 452.0780 2025-08-01 00:00:00.0 6.0462 548
63 459.9429 2025-08-02 00:00:00.0 7.8649 548
64 468.3074 2025-08-03 00:00:00.0 8.3645 548
65 476.6629 2025-08-04 00:00:00.0 8.3555 548
66 485.7103 2025-08-05 00:00:00.0 9.0474 548
67 495.1636 2025-08-06 00:00:00.0 9.4533 548
68 504.0202 2025-08-07 00:00:00.0 8.8566 548
69 512.2706 2025-08-08 00:00:00.0 8.2504 548
70 521.7008 2025-08-09 00:00:00.0 9.4302 548
71 529.4857 2025-08-10 00:00:00.0 7.7849 548
72 538.6639 2025-08-11 00:00:00.0 9.1782 548
73 547.4512 2025-08-12 00:00:00.0 8.7873 548
74 555.4849 2025-08-13 00:00:00.0 8.0337 548
75 563.3151 2025-08-14 00:00:00.0 7.8302 548
76 571.7690 2025-08-15 00:00:00.0 8.4539 548
77 577.8814 2025-08-16 00:00:00.0 6.1124 548
78 585.8586 2025-08-17 00:00:00.0 7.9772 548
79 594.8249 2025-08-18 00:00:00.0 8.9663 548
80 604.1945 2025-08-19 00:00:00.0 9.3696 548
81 612.2232 2025-08-20 00:00:00.0 8.0287 548
82 619.7170 2025-08-21 00:00:00.0 7.4938 548
83 627.7965 2025-08-22 00:00:00.0 8.0795 548
84 634.2744 2025-08-23 00:00:00.0 6.4779 548
85 640.3748 2025-08-24 00:00:00.0 6.1004 548
86 645.6273 2025-08-25 00:00:00.0 5.2525 548
87 651.2305 2025-08-26 00:00:00.0 5.6032 548
88 656.9017 2025-08-27 00:00:00.0 5.6712 548
89 663.1627 2025-08-28 00:00:00.0 6.2610 548
90 671.3796 2025-08-29 00:00:00.0 8.2169 548
91 678.3183 2025-08-30 00:00:00.0 6.9387 548
92 685.4974 2025-08-31 00:00:00.0 7.1791 548
93 692.2231 2025-09-01 00:00:00.0 6.7257 548
94 699.6255 2025-09-02 00:00:00.0 7.4024 548
95 703.8626 2025-09-03 00:00:00.0 4.2371 548
96 705.7695 2025-09-04 00:00:00.0 1.9069 548
97 707.6033 2025-09-05 00:00:00.0 1.8338 548
98 709.8320 2025-09-06 00:00:00.0 2.2287 548
99 712.0824 2025-09-07 00:00:00.0 2.2504 548
100 716.0245 2025-09-08 00:00:00.0 3.9421 548
101 721.7721 2025-09-09 00:00:00.0 5.7476 548
102 728.9830 2025-09-10 00:00:00.0 7.2109 548
103 736.3396 2025-09-11 00:00:00.0 7.3566 548
104 745.1880 2025-09-12 00:00:00.0 8.8484 548
105 754.3429 2025-09-13 00:00:00.0 9.1549 548
106 763.9980 2025-09-14 00:00:00.0 9.6551 548
107 773.7049 2025-09-15 00:00:00.0 9.7069 548
108 783.3394 2025-09-16 00:00:00.0 9.6345 548
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '548') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-16'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/16/2025 10 783
9/15/2025 10 774
9/14/2025 10 764
9/13/2025 9 754
9/12/2025 9 745
9/11/2025 7 736
9/10/2025 7 729
9/9/2025 6 722
9/8/2025 4 716
9/7/2025 2 712
9/6/2025 2 710
9/5/2025 2 708
9/4/2025 2 706
9/3/2025 4 704
9/2/2025 7 700
9/1/2025 7 692
8/31/2025 7 685
8/30/2025 7 678
8/29/2025 8 671
8/28/2025 6 663
8/27/2025 6 657
8/26/2025 6 651
8/25/2025 5 646
8/24/2025 6 640
8/23/2025 6 634
8/22/2025 8 628
8/21/2025 7 620
8/20/2025 8 612
8/19/2025 9 604
8/18/2025 9 595
8/17/2025 8 586
8/16/2025 6 578
8/15/2025 8 572
8/14/2025 8 563
8/13/2025 8 555
8/12/2025 9 547
8/11/2025 9 539
8/10/2025 8 529
8/9/2025 9 522
8/8/2025 8 512
8/7/2025 9 504
8/6/2025 9 495
8/5/2025 9 486
8/4/2025 8 477
8/3/2025 8 468
8/2/2025 8 460
8/1/2025 6 452
7/31/2025 7 446
7/30/2025 7 439
7/29/2025 8 432
7/28/2025 9 423
7/27/2025 8 415
7/26/2025 7 407
7/25/2025 7 399
7/24/2025 9 392
7/23/2025 9 383
7/22/2025 9 373
7/21/2025 9 365
7/20/2025 7 356
7/19/2025 7 349
7/18/2025 5 342
7/17/2025 4 337
7/16/2025 7 333
7/15/2025 9 326
7/14/2025 8 317
7/13/2025 7 309
7/12/2025 7 302
7/11/2025 8 295
7/10/2025 7 286
7/9/2025 7 279
7/8/2025 7 272
7/7/2025 7 265
7/6/2025 7 258
7/5/2025 8 251
7/4/2025 7 243
7/3/2025 8 236
7/2/2025 8 227
7/1/2025 9 219
6/30/2025 9 210
6/29/2025 8 202
6/28/2025 8 193
6/27/2025 8 185
6/26/2025 7 177
6/25/2025 6 170
6/24/2025 3 164
6/23/2025 7 161
6/22/2025 9 153
6/21/2025 9 144
6/20/2025 8 136
6/19/2025 8 128
6/18/2025 8 120
6/17/2025 9 111
6/16/2025 8 102
6/15/2025 7 94
6/14/2025 8 87
6/13/2025 6 79
6/12/2025 6 73
6/11/2025 7 67
6/10/2025 7 61
6/9/2025 3 54
6/8/2025 7 51
6/7/2025 6 44
6/6/2025 5 39
6/5/2025 6 34
6/4/2025 6 28
6/3/2025 8 22
6/2/2025 7 15
6/1/2025 8 8