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.4848 2025-06-01 00:00:00.0 7.4848 534
2 14.3620 2025-06-02 00:00:00.0 6.8772 534
3 22.8286 2025-06-03 00:00:00.0 8.4666 534
4 30.3885 2025-06-04 00:00:00.0 7.5599 534
5 37.2530 2025-06-05 00:00:00.0 6.8645 534
6 42.8701 2025-06-06 00:00:00.0 5.6171 534
7 49.7167 2025-06-07 00:00:00.0 6.8466 534
8 58.0737 2025-06-08 00:00:00.0 8.3570 534
9 62.0642 2025-06-09 00:00:00.0 3.9905 534
10 67.8144 2025-06-10 00:00:00.0 5.7502 534
11 75.4281 2025-06-11 00:00:00.0 7.6137 534
12 82.0809 2025-06-12 00:00:00.0 6.6528 534
13 88.8886 2025-06-13 00:00:00.0 6.8077 534
14 95.3354 2025-06-14 00:00:00.0 6.4468 534
15 102.8552 2025-06-15 00:00:00.0 7.5198 534
16 110.5343 2025-06-16 00:00:00.0 7.6791 534
17 119.9332 2025-06-17 00:00:00.0 9.3989 534
18 128.1903 2025-06-18 00:00:00.0 8.2571 534
19 136.8904 2025-06-19 00:00:00.0 8.7001 534
20 144.9767 2025-06-20 00:00:00.0 8.0863 534
21 153.0003 2025-06-21 00:00:00.0 8.0236 534
22 162.6642 2025-06-22 00:00:00.0 9.6639 534
23 170.3635 2025-06-23 00:00:00.0 7.6993 534
24 174.7444 2025-06-24 00:00:00.0 4.3809 534
25 180.6851 2025-06-25 00:00:00.0 5.9407 534
26 186.7569 2025-06-26 00:00:00.0 6.0718 534
27 195.1264 2025-06-27 00:00:00.0 8.3695 534
28 203.2098 2025-06-28 00:00:00.0 8.0834 534
29 210.5094 2025-06-29 00:00:00.0 7.2996 534
30 219.7288 2025-06-30 00:00:00.0 9.2194 534
31 228.3184 2025-07-01 00:00:00.0 8.5896 534
32 236.4129 2025-07-02 00:00:00.0 8.0945 534
33 244.4324 2025-07-03 00:00:00.0 8.0195 534
34 251.5483 2025-07-04 00:00:00.0 7.1159 534
35 258.5645 2025-07-05 00:00:00.0 7.0162 534
36 267.5631 2025-07-06 00:00:00.0 8.9986 534
37 273.9803 2025-07-07 00:00:00.0 6.4172 534
38 280.1772 2025-07-08 00:00:00.0 6.1969 534
39 287.7952 2025-07-09 00:00:00.0 7.6180 534
40 295.5337 2025-07-10 00:00:00.0 7.7385 534
41 302.9418 2025-07-11 00:00:00.0 7.4081 534
42 311.5078 2025-07-12 00:00:00.0 8.5660 534
43 320.0277 2025-07-13 00:00:00.0 8.5199 534
44 329.0914 2025-07-14 00:00:00.0 9.0637 534
45 337.9495 2025-07-15 00:00:00.0 8.8581 534
46 344.4737 2025-07-16 00:00:00.0 6.5242 534
47 350.2992 2025-07-17 00:00:00.0 5.8255 534
48 356.5905 2025-07-18 00:00:00.0 6.2913 534
49 363.7674 2025-07-19 00:00:00.0 7.1769 534
50 371.5209 2025-07-20 00:00:00.0 7.7535 534
51 380.1744 2025-07-21 00:00:00.0 8.6535 534
52 388.7358 2025-07-22 00:00:00.0 8.5614 534
53 397.7626 2025-07-23 00:00:00.0 9.0268 534
54 407.0337 2025-07-24 00:00:00.0 9.2711 534
55 416.2063 2025-07-25 00:00:00.0 9.1726 534
56 423.6837 2025-07-26 00:00:00.0 7.4774 534
57 432.3734 2025-07-27 00:00:00.0 8.6897 534
58 441.4931 2025-07-28 00:00:00.0 9.1197 534
59 450.2379 2025-07-29 00:00:00.0 8.7448 534
60 458.5013 2025-07-30 00:00:00.0 8.2634 534
61 465.4823 2025-07-31 00:00:00.0 6.9810 534
62 472.9577 2025-08-01 00:00:00.0 7.4754 534
63 479.8197 2025-08-02 00:00:00.0 6.8620 534
64 488.5066 2025-08-03 00:00:00.0 8.6869 534
65 496.9371 2025-08-04 00:00:00.0 8.4305 534
66 505.7529 2025-08-05 00:00:00.0 8.8158 534
67 514.8668 2025-08-06 00:00:00.0 9.1139 534
68 523.8056 2025-08-07 00:00:00.0 8.9388 534
69 532.1931 2025-08-08 00:00:00.0 8.3875 534
70 541.9179 2025-08-09 00:00:00.0 9.7248 534
71 550.9094 2025-08-10 00:00:00.0 8.9915 534
72 560.0101 2025-08-11 00:00:00.0 9.1007 534
73 569.2720 2025-08-12 00:00:00.0 9.2619 534
74 570.4911 2025-08-13 00:00:00.0 1.2191 534
75 577.4498 2025-08-14 00:00:00.0 6.9587 534
76 585.9146 2025-08-15 00:00:00.0 8.4648 534
77 593.3506 2025-08-16 00:00:00.0 7.4360 534
78 600.5269 2025-08-17 00:00:00.0 7.1763 534
79 608.1717 2025-08-18 00:00:00.0 7.6448 534
80 617.4960 2025-08-19 00:00:00.0 9.3243 534
81 625.9640 2025-08-20 00:00:00.0 8.4680 534
82 633.9138 2025-08-21 00:00:00.0 7.9498 534
83 642.7953 2025-08-22 00:00:00.0 8.8815 534
84 650.0181 2025-08-23 00:00:00.0 7.2228 534
85 657.1554 2025-08-24 00:00:00.0 7.1373 534
86 662.6996 2025-08-25 00:00:00.0 5.5442 534
87 668.5208 2025-08-26 00:00:00.0 5.8212 534
88 676.2337 2025-08-27 00:00:00.0 7.7129 534
89 684.4839 2025-08-28 00:00:00.0 8.2502 534
90 691.6934 2025-08-29 00:00:00.0 7.2095 534
91 698.7891 2025-08-30 00:00:00.0 7.0957 534
92 706.0827 2025-08-31 00:00:00.0 7.2936 534
93 713.8795 2025-09-01 00:00:00.0 7.7968 534
94 721.3338 2025-09-02 00:00:00.0 7.4543 534
95 726.8013 2025-09-03 00:00:00.0 5.4675 534
96 728.8406 2025-09-04 00:00:00.0 2.0393 534
97 729.0128 2025-09-05 00:00:00.0 0.1722 534
98 732.3984 2025-09-06 00:00:00.0 3.3856 534
99 734.6149 2025-09-07 00:00:00.0 2.2165 534
100 738.2914 2025-09-08 00:00:00.0 3.6765 534
101 744.7790 2025-09-09 00:00:00.0 6.4876 534
102 751.4388 2025-09-10 00:00:00.0 6.6598 534
103 757.8837 2025-09-11 00:00:00.0 6.4449 534
104 765.8044 2025-09-12 00:00:00.0 7.9207 534
105 775.1415 2025-09-13 00:00:00.0 9.3371 534
106 783.6362 2025-09-14 00:00:00.0 8.4947 534
107 793.3480 2025-09-15 00:00:00.0 9.7118 534
108 802.8694 2025-09-16 00:00:00.0 9.5214 534
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '534') 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 803
9/15/2025 10 793
9/14/2025 8 784
9/13/2025 9 775
9/12/2025 8 766
9/11/2025 6 758
9/10/2025 7 751
9/9/2025 6 745
9/8/2025 4 738
9/7/2025 2 735
9/6/2025 3 732
9/5/2025 0 729
9/4/2025 2 729
9/3/2025 5 727
9/2/2025 7 721
9/1/2025 8 714
8/31/2025 7 706
8/30/2025 7 699
8/29/2025 7 692
8/28/2025 8 684
8/27/2025 8 676
8/26/2025 6 669
8/25/2025 6 663
8/24/2025 7 657
8/23/2025 7 650
8/22/2025 9 643
8/21/2025 8 634
8/20/2025 8 626
8/19/2025 9 617
8/18/2025 8 608
8/17/2025 7 601
8/16/2025 7 593
8/15/2025 8 586
8/14/2025 7 577
8/13/2025 1 570
8/12/2025 9 569
8/11/2025 9 560
8/10/2025 9 551
8/9/2025 10 542
8/8/2025 8 532
8/7/2025 9 524
8/6/2025 9 515
8/5/2025 9 506
8/4/2025 8 497
8/3/2025 9 489
8/2/2025 7 480
8/1/2025 7 473
7/31/2025 7 465
7/30/2025 8 459
7/29/2025 9 450
7/28/2025 9 441
7/27/2025 9 432
7/26/2025 7 424
7/25/2025 9 416
7/24/2025 9 407
7/23/2025 9 398
7/22/2025 9 389
7/21/2025 9 380
7/20/2025 8 372
7/19/2025 7 364
7/18/2025 6 357
7/17/2025 6 350
7/16/2025 7 344
7/15/2025 9 338
7/14/2025 9 329
7/13/2025 9 320
7/12/2025 9 312
7/11/2025 7 303
7/10/2025 8 296
7/9/2025 8 288
7/8/2025 6 280
7/7/2025 6 274
7/6/2025 9 268
7/5/2025 7 259
7/4/2025 7 252
7/3/2025 8 244
7/2/2025 8 236
7/1/2025 9 228
6/30/2025 9 220
6/29/2025 7 211
6/28/2025 8 203
6/27/2025 8 195
6/26/2025 6 187
6/25/2025 6 181
6/24/2025 4 175
6/23/2025 8 170
6/22/2025 10 163
6/21/2025 8 153
6/20/2025 8 145
6/19/2025 9 137
6/18/2025 8 128
6/17/2025 9 120
6/16/2025 8 111
6/15/2025 8 103
6/14/2025 6 95
6/13/2025 7 89
6/12/2025 7 82
6/11/2025 8 75
6/10/2025 6 68
6/9/2025 4 62
6/8/2025 8 58
6/7/2025 7 50
6/6/2025 6 43
6/5/2025 7 37
6/4/2025 8 30
6/3/2025 8 23
6/2/2025 7 14
6/1/2025 7 7