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
109 792.4906 2025-09-17 00:00:00.0 9.1512 548
110 800.5228 2025-09-18 00:00:00.0 8.0322 548
111 806.3070 2025-09-19 00:00:00.0 5.7842 548
112 813.4542 2025-09-20 00:00:00.0 7.1472 548
113 821.6665 2025-09-21 00:00:00.0 8.2123 548
114 828.6195 2025-09-22 00:00:00.0 6.9530 548
115 834.6971 2025-09-23 00:00:00.0 6.0776 548
116 841.5381 2025-09-24 00:00:00.0 6.8410 548
117 846.8859 2025-09-25 00:00:00.0 5.3478 548
118 852.5771 2025-09-26 00:00:00.0 5.6912 548
119 858.5193 2025-09-27 00:00:00.0 5.9422 548
120 864.0498 2025-09-28 00:00:00.0 5.5305 548
121 869.6457 2025-09-29 00:00:00.0 5.5959 548
122 875.7052 2025-09-30 00:00:00.0 6.0595 548
123 882.9568 2025-10-01 00:00:00.0 7.2516 548
124 890.8513 2025-10-02 00:00:00.0 7.8945 548
125 896.4453 2025-10-03 00:00:00.0 5.5940 548
126 904.1024 2025-10-04 00:00:00.0 7.6571 548
127 911.7897 2025-10-05 00:00:00.0 7.6873 548
128 913.9525 2025-10-06 00:00:00.0 2.1628 548
129 914.6973 2025-10-07 00:00:00.0 0.7448 548
130 915.2967 2025-10-08 00:00:00.0 0.5994 548
131 920.1725 2025-10-09 00:00:00.0 4.8758 548
132 924.1779 2025-10-10 00:00:00.0 4.0054 548
133 927.3944 2025-10-11 00:00:00.0 3.2165 548
134 932.9917 2025-10-12 00:00:00.0 5.5973 548
135 935.4809 2025-10-13 00:00:00.0 2.4892 548
136 935.4809 2025-10-14 00:00:00.0 0.0000 548
137 935.7503 2025-10-15 00:00:00.0 0.2694 548
138 936.5704 2025-10-16 00:00:00.0 0.8201 548
139 939.6652 2025-10-17 00:00:00.0 3.0948 548
140 940.2381 2025-10-18 00:00:00.0 0.5729 548
141 941.2704 2025-10-19 00:00:00.0 1.0323 548
142 942.5816 2025-10-20 00:00:00.0 1.3112 548
143 942.8351 2025-10-21 00:00:00.0 0.2535 548
144 942.8351 2025-10-22 00:00:00.0 0.0000 548
145 944.1748 2025-10-23 00:00:00.0 1.3397 548
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '548') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-10-23'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
10/23/2025 1 944
10/22/2025 0 943
10/21/2025 0 943
10/20/2025 1 943
10/19/2025 1 941
10/18/2025 1 940
10/17/2025 3 940
10/16/2025 1 937
10/15/2025 0 936
10/14/2025 0 935
10/13/2025 2 935
10/12/2025 6 933
10/11/2025 3 927
10/10/2025 4 924
10/9/2025 5 920
10/8/2025 1 915
10/7/2025 1 915
10/6/2025 2 914
10/5/2025 8 912
10/4/2025 8 904
10/3/2025 6 896
10/2/2025 8 891
10/1/2025 7 883
9/30/2025 6 876
9/29/2025 6 870
9/28/2025 6 864
9/27/2025 6 859
9/26/2025 6 853
9/25/2025 5 847
9/24/2025 7 842
9/23/2025 6 835
9/22/2025 7 829
9/21/2025 8 822
9/20/2025 7 813
9/19/2025 6 806
9/18/2025 8 801
9/17/2025 9 792
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