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.5427 2025-06-01 00:00:00.0 7.5427 533
2 14.6776 2025-06-02 00:00:00.0 7.1349 533
3 23.2755 2025-06-03 00:00:00.0 8.5979 533
4 30.9014 2025-06-04 00:00:00.0 7.6259 533
5 37.5487 2025-06-05 00:00:00.0 6.6473 533
6 43.4049 2025-06-06 00:00:00.0 5.8562 533
7 51.1325 2025-06-07 00:00:00.0 7.7276 533
8 59.3371 2025-06-08 00:00:00.0 8.2046 533
9 63.6540 2025-06-09 00:00:00.0 4.3169 533
10 69.7531 2025-06-10 00:00:00.0 6.0991 533
11 77.7317 2025-06-11 00:00:00.0 7.9786 533
12 84.3299 2025-06-12 00:00:00.0 6.5982 533
13 91.8008 2025-06-13 00:00:00.0 7.4709 533
14 98.9752 2025-06-14 00:00:00.0 7.1744 533
15 106.3925 2025-06-15 00:00:00.0 7.4173 533
16 114.3428 2025-06-16 00:00:00.0 7.9503 533
17 123.8409 2025-06-17 00:00:00.0 9.4981 533
18 132.3973 2025-06-18 00:00:00.0 8.5564 533
19 141.3133 2025-06-19 00:00:00.0 8.9160 533
20 149.6505 2025-06-20 00:00:00.0 8.3372 533
21 157.9199 2025-06-21 00:00:00.0 8.2694 533
22 167.5374 2025-06-22 00:00:00.0 9.6175 533
23 174.8317 2025-06-23 00:00:00.0 7.2943 533
24 179.5903 2025-06-24 00:00:00.0 4.7586 533
25 185.6493 2025-06-25 00:00:00.0 6.0590 533
26 192.0745 2025-06-26 00:00:00.0 6.4252 533
27 200.3559 2025-06-27 00:00:00.0 8.2814 533
28 208.8907 2025-06-28 00:00:00.0 8.5348 533
29 216.3511 2025-06-29 00:00:00.0 7.4604 533
30 225.6173 2025-06-30 00:00:00.0 9.2662 533
31 234.1906 2025-07-01 00:00:00.0 8.5733 533
32 242.3782 2025-07-02 00:00:00.0 8.1876 533
33 250.8549 2025-07-03 00:00:00.0 8.4767 533
34 257.9902 2025-07-04 00:00:00.0 7.1353 533
35 265.4320 2025-07-05 00:00:00.0 7.4418 533
36 274.2326 2025-07-06 00:00:00.0 8.8006 533
37 280.9125 2025-07-07 00:00:00.0 6.6799 533
38 287.2259 2025-07-08 00:00:00.0 6.3134 533
39 295.1513 2025-07-09 00:00:00.0 7.9254 533
40 303.3517 2025-07-10 00:00:00.0 8.2004 533
41 311.3574 2025-07-11 00:00:00.0 8.0057 533
42 320.2782 2025-07-12 00:00:00.0 8.9208 533
43 328.7055 2025-07-13 00:00:00.0 8.4273 533
44 337.7613 2025-07-14 00:00:00.0 9.0558 533
45 346.4641 2025-07-15 00:00:00.0 8.7028 533
46 354.2999 2025-07-16 00:00:00.0 7.8358 533
47 360.5546 2025-07-17 00:00:00.0 6.2547 533
48 367.4974 2025-07-18 00:00:00.0 6.9428 533
49 374.8922 2025-07-19 00:00:00.0 7.3948 533
50 382.7891 2025-07-20 00:00:00.0 7.8969 533
51 391.7612 2025-07-21 00:00:00.0 8.9721 533
52 400.3670 2025-07-22 00:00:00.0 8.6058 533
53 409.6663 2025-07-23 00:00:00.0 9.2993 533
54 418.9996 2025-07-24 00:00:00.0 9.3333 533
55 428.3371 2025-07-25 00:00:00.0 9.3375 533
56 435.7942 2025-07-26 00:00:00.0 7.4571 533
57 444.0821 2025-07-27 00:00:00.0 8.2879 533
58 453.3196 2025-07-28 00:00:00.0 9.2375 533
59 462.2866 2025-07-29 00:00:00.0 8.9670 533
60 470.7608 2025-07-30 00:00:00.0 8.4742 533
61 478.0838 2025-07-31 00:00:00.0 7.3230 533
62 486.1223 2025-08-01 00:00:00.0 8.0385 533
63 493.6703 2025-08-02 00:00:00.0 7.5480 533
64 502.4719 2025-08-03 00:00:00.0 8.8016 533
65 511.0357 2025-08-04 00:00:00.0 8.5638 533
66 519.8970 2025-08-05 00:00:00.0 8.8613 533
67 529.0493 2025-08-06 00:00:00.0 9.1523 533
68 537.8529 2025-08-07 00:00:00.0 8.8036 533
69 546.3303 2025-08-08 00:00:00.0 8.4774 533
70 556.0314 2025-08-09 00:00:00.0 9.7011 533
71 564.9611 2025-08-10 00:00:00.0 8.9297 533
72 574.1863 2025-08-11 00:00:00.0 9.2252 533
73 583.4874 2025-08-12 00:00:00.0 9.3011 533
74 584.9375 2025-08-13 00:00:00.0 1.4501 533
75 592.6085 2025-08-14 00:00:00.0 7.6710 533
76 601.3730 2025-08-15 00:00:00.0 8.7645 533
77 609.3146 2025-08-16 00:00:00.0 7.9416 533
78 616.3037 2025-08-17 00:00:00.0 6.9891 533
79 623.7081 2025-08-18 00:00:00.0 7.4044 533
80 633.2521 2025-08-19 00:00:00.0 9.5440 533
81 642.3741 2025-08-20 00:00:00.0 9.1220 533
82 650.2215 2025-08-21 00:00:00.0 7.8474 533
83 658.9663 2025-08-22 00:00:00.0 8.7448 533
84 666.8209 2025-08-23 00:00:00.0 7.8546 533
85 673.8234 2025-08-24 00:00:00.0 7.0025 533
86 680.0753 2025-08-25 00:00:00.0 6.2519 533
87 686.5219 2025-08-26 00:00:00.0 6.4466 533
88 694.5455 2025-08-27 00:00:00.0 8.0236 533
89 703.1593 2025-08-28 00:00:00.0 8.6138 533
90 711.1283 2025-08-29 00:00:00.0 7.9690 533
91 718.6745 2025-08-30 00:00:00.0 7.5462 533
92 725.9543 2025-08-31 00:00:00.0 7.2798 533
93 733.6672 2025-09-01 00:00:00.0 7.7129 533
94 742.0319 2025-09-02 00:00:00.0 8.3647 533
95 748.4571 2025-09-03 00:00:00.0 6.4252 533
96 751.2857 2025-09-04 00:00:00.0 2.8286 533
97 751.5071 2025-09-05 00:00:00.0 0.2214 533
98 754.9759 2025-09-06 00:00:00.0 3.4688 533
99 757.9286 2025-09-07 00:00:00.0 2.9527 533
100 762.1785 2025-09-08 00:00:00.0 4.2499 533
101 770.1422 2025-09-09 00:00:00.0 7.9637 533
102 777.6218 2025-09-10 00:00:00.0 7.4796 533
103 784.2570 2025-09-11 00:00:00.0 6.6352 533
104 793.3778 2025-09-12 00:00:00.0 9.1208 533
105 802.6715 2025-09-13 00:00:00.0 9.2937 533
106 811.7215 2025-09-14 00:00:00.0 9.0500 533
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '533') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-14'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/14/2025 9 812
9/13/2025 9 803
9/12/2025 9 793
9/11/2025 7 784
9/10/2025 7 778
9/9/2025 8 770
9/8/2025 4 762
9/7/2025 3 758
9/6/2025 3 755
9/5/2025 0 752
9/4/2025 3 751
9/3/2025 6 748
9/2/2025 8 742
9/1/2025 8 734
8/31/2025 7 726
8/30/2025 8 719
8/29/2025 8 711
8/28/2025 9 703
8/27/2025 8 695
8/26/2025 6 687
8/25/2025 6 680
8/24/2025 7 674
8/23/2025 8 667
8/22/2025 9 659
8/21/2025 8 650
8/20/2025 9 642
8/19/2025 10 633
8/18/2025 7 624
8/17/2025 7 616
8/16/2025 8 609
8/15/2025 9 601
8/14/2025 8 593
8/13/2025 1 585
8/12/2025 9 583
8/11/2025 9 574
8/10/2025 9 565
8/9/2025 10 556
8/8/2025 8 546
8/7/2025 9 538
8/6/2025 9 529
8/5/2025 9 520
8/4/2025 9 511
8/3/2025 9 502
8/2/2025 8 494
8/1/2025 8 486
7/31/2025 7 478
7/30/2025 8 471
7/29/2025 9 462
7/28/2025 9 453
7/27/2025 8 444
7/26/2025 7 436
7/25/2025 9 428
7/24/2025 9 419
7/23/2025 9 410
7/22/2025 9 400
7/21/2025 9 392
7/20/2025 8 383
7/19/2025 7 375
7/18/2025 7 367
7/17/2025 6 361
7/16/2025 8 354
7/15/2025 9 346
7/14/2025 9 338
7/13/2025 8 329
7/12/2025 9 320
7/11/2025 8 311
7/10/2025 8 303
7/9/2025 8 295
7/8/2025 6 287
7/7/2025 7 281
7/6/2025 9 274
7/5/2025 7 265
7/4/2025 7 258
7/3/2025 8 251
7/2/2025 8 242
7/1/2025 9 234
6/30/2025 9 226
6/29/2025 7 216
6/28/2025 9 209
6/27/2025 8 200
6/26/2025 6 192
6/25/2025 6 186
6/24/2025 5 180
6/23/2025 7 175
6/22/2025 10 168
6/21/2025 8 158
6/20/2025 8 150
6/19/2025 9 141
6/18/2025 9 132
6/17/2025 9 124
6/16/2025 8 114
6/15/2025 7 106
6/14/2025 7 99
6/13/2025 7 92
6/12/2025 7 84
6/11/2025 8 78
6/10/2025 6 70
6/9/2025 4 64
6/8/2025 8 59
6/7/2025 8 51
6/6/2025 6 43
6/5/2025 7 38
6/4/2025 8 31
6/3/2025 9 23
6/2/2025 7 15
6/1/2025 8 8