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.4602 2025-06-01 00:00:00.0 7.4602 212
2 14.0871 2025-06-02 00:00:00.0 6.6269 212
3 22.7142 2025-06-03 00:00:00.0 8.6271 212
4 30.6452 2025-06-04 00:00:00.0 7.9310 212
5 37.7356 2025-06-05 00:00:00.0 7.0904 212
6 43.8165 2025-06-06 00:00:00.0 6.0809 212
7 51.0078 2025-06-07 00:00:00.0 7.1913 212
8 59.5437 2025-06-08 00:00:00.0 8.5359 212
9 64.2808 2025-06-09 00:00:00.0 4.7371 212
10 69.1543 2025-06-10 00:00:00.0 4.8735 212
11 76.7096 2025-06-11 00:00:00.0 7.5553 212
12 83.4899 2025-06-12 00:00:00.0 6.7803 212
13 90.2333 2025-06-13 00:00:00.0 6.7434 212
14 97.4048 2025-06-14 00:00:00.0 7.1715 212
15 104.5773 2025-06-15 00:00:00.0 7.1725 212
16 112.3777 2025-06-16 00:00:00.0 7.8004 212
17 121.6003 2025-06-17 00:00:00.0 9.2226 212
18 126.2447 2025-06-18 00:00:00.0 4.6444 212
19 133.7652 2025-06-19 00:00:00.0 7.5205 212
20 142.1122 2025-06-20 00:00:00.0 8.3470 212
21 150.2174 2025-06-21 00:00:00.0 8.1052 212
22 159.0874 2025-06-22 00:00:00.0 8.8700 212
23 167.8473 2025-06-23 00:00:00.0 8.7599 212
24 173.9353 2025-06-24 00:00:00.0 6.0880 212
25 179.6740 2025-06-25 00:00:00.0 5.7387 212
26 187.8849 2025-06-26 00:00:00.0 8.2109 212
27 196.9648 2025-06-27 00:00:00.0 9.0799 212
28 204.5572 2025-06-28 00:00:00.0 7.5924 212
29 211.6524 2025-06-29 00:00:00.0 7.0952 212
30 220.3360 2025-06-30 00:00:00.0 8.6836 212
31 228.9633 2025-07-01 00:00:00.0 8.6273 212
32 236.9218 2025-07-02 00:00:00.0 7.9585 212
33 245.4919 2025-07-03 00:00:00.0 8.5701 212
34 252.4193 2025-07-04 00:00:00.0 6.9274 212
35 258.7796 2025-07-05 00:00:00.0 6.3603 212
36 268.0181 2025-07-06 00:00:00.0 9.2385 212
37 276.5783 2025-07-07 00:00:00.0 8.5602 212
38 276.5783 2025-07-08 00:00:00.0 0.0000 212
39 284.8198 2025-07-09 00:00:00.0 8.2415 212
40 292.3519 2025-07-10 00:00:00.0 7.5321 212
41 299.6915 2025-07-11 00:00:00.0 7.3396 212
42 308.9627 2025-07-12 00:00:00.0 9.2712 212
43 317.5484 2025-07-13 00:00:00.0 8.5857 212
44 326.0502 2025-07-14 00:00:00.0 8.5018 212
45 334.9623 2025-07-15 00:00:00.0 8.9121 212
46 342.9157 2025-07-16 00:00:00.0 7.9534 212
47 349.5565 2025-07-17 00:00:00.0 6.6408 212
48 355.2591 2025-07-18 00:00:00.0 5.7026 212
49 363.2178 2025-07-19 00:00:00.0 7.9587 212
50 370.1948 2025-07-20 00:00:00.0 6.9770 212
51 378.3739 2025-07-21 00:00:00.0 8.1791 212
52 386.5078 2025-07-22 00:00:00.0 8.1339 212
53 395.9082 2025-07-23 00:00:00.0 9.4004 212
54 405.2152 2025-07-24 00:00:00.0 9.3070 212
55 414.3886 2025-07-25 00:00:00.0 9.1734 212
56 421.7098 2025-07-26 00:00:00.0 7.3212 212
57 429.3073 2025-07-27 00:00:00.0 7.5975 212
58 438.4842 2025-07-28 00:00:00.0 9.1769 212
59 447.3274 2025-07-29 00:00:00.0 8.8432 212
60 456.4281 2025-07-30 00:00:00.0 9.1007 212
61 464.1198 2025-07-31 00:00:00.0 7.6917 212
62 471.2923 2025-08-01 00:00:00.0 7.1725 212
63 477.7848 2025-08-02 00:00:00.0 6.4925 212
64 485.7792 2025-08-03 00:00:00.0 7.9944 212
65 493.8026 2025-08-04 00:00:00.0 8.0234 212
66 503.1387 2025-08-05 00:00:00.0 9.3361 212
67 512.0203 2025-08-06 00:00:00.0 8.8816 212
68 520.2998 2025-08-07 00:00:00.0 8.2795 212
69 528.0279 2025-08-08 00:00:00.0 7.7281 212
70 537.6406 2025-08-09 00:00:00.0 9.6127 212
71 546.5417 2025-08-10 00:00:00.0 8.9011 212
72 555.8454 2025-08-11 00:00:00.0 9.3037 212
73 564.9571 2025-08-12 00:00:00.0 9.1117 212
74 572.6775 2025-08-13 00:00:00.0 7.7204 212
75 579.5429 2025-08-14 00:00:00.0 6.8654 212
76 587.6343 2025-08-15 00:00:00.0 8.0914 212
77 595.5195 2025-08-16 00:00:00.0 7.8852 212
78 603.8598 2025-08-17 00:00:00.0 8.3403 212
79 612.0597 2025-08-18 00:00:00.0 8.1999 212
80 621.6056 2025-08-19 00:00:00.0 9.5459 212
81 630.0868 2025-08-20 00:00:00.0 8.4812 212
82 638.3137 2025-08-21 00:00:00.0 8.2269 212
83 647.0925 2025-08-22 00:00:00.0 8.7788 212
84 654.5014 2025-08-23 00:00:00.0 7.4089 212
85 662.5595 2025-08-24 00:00:00.0 8.0581 212
86 668.0821 2025-08-25 00:00:00.0 5.5226 212
87 673.8627 2025-08-26 00:00:00.0 5.7806 212
88 681.7315 2025-08-27 00:00:00.0 7.8688 212
89 690.0733 2025-08-28 00:00:00.0 8.3418 212
90 697.8853 2025-08-29 00:00:00.0 7.8120 212
91 704.9961 2025-08-30 00:00:00.0 7.1108 212
92 712.1208 2025-08-31 00:00:00.0 7.1247 212
93 719.3740 2025-09-01 00:00:00.0 7.2532 212
94 727.8318 2025-09-02 00:00:00.0 8.4578 212
95 733.8559 2025-09-03 00:00:00.0 6.0241 212
96 737.3228 2025-09-04 00:00:00.0 3.4669 212
97 737.5922 2025-09-05 00:00:00.0 0.2694 212
98 741.6970 2025-09-06 00:00:00.0 4.1048 212
99 744.2773 2025-09-07 00:00:00.0 2.5803 212
100 748.0502 2025-09-08 00:00:00.0 3.7729 212
101 754.3119 2025-09-09 00:00:00.0 6.2617 212
102 761.4750 2025-09-10 00:00:00.0 7.1631 212
103 768.0536 2025-09-11 00:00:00.0 6.5786 212
104 775.1229 2025-09-12 00:00:00.0 7.0693 212
105 784.4553 2025-09-13 00:00:00.0 9.3324 212
106 793.4428 2025-09-14 00:00:00.0 8.9875 212
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '212') 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 793
9/13/2025 9 784
9/12/2025 7 775
9/11/2025 7 768
9/10/2025 7 761
9/9/2025 6 754
9/8/2025 4 748
9/7/2025 3 744
9/6/2025 4 742
9/5/2025 0 738
9/4/2025 3 737
9/3/2025 6 734
9/2/2025 8 728
9/1/2025 7 719
8/31/2025 7 712
8/30/2025 7 705
8/29/2025 8 698
8/28/2025 8 690
8/27/2025 8 682
8/26/2025 6 674
8/25/2025 6 668
8/24/2025 8 663
8/23/2025 7 655
8/22/2025 9 647
8/21/2025 8 638
8/20/2025 8 630
8/19/2025 10 622
8/18/2025 8 612
8/17/2025 8 604
8/16/2025 8 596
8/15/2025 8 588
8/14/2025 7 580
8/13/2025 8 573
8/12/2025 9 565
8/11/2025 9 556
8/10/2025 9 547
8/9/2025 10 538
8/8/2025 8 528
8/7/2025 8 520
8/6/2025 9 512
8/5/2025 9 503
8/4/2025 8 494
8/3/2025 8 486
8/2/2025 6 478
8/1/2025 7 471
7/31/2025 8 464
7/30/2025 9 456
7/29/2025 9 447
7/28/2025 9 438
7/27/2025 8 429
7/26/2025 7 422
7/25/2025 9 414
7/24/2025 9 405
7/23/2025 9 396
7/22/2025 8 387
7/21/2025 8 378
7/20/2025 7 370
7/19/2025 8 363
7/18/2025 6 355
7/17/2025 7 350
7/16/2025 8 343
7/15/2025 9 335
7/14/2025 9 326
7/13/2025 9 318
7/12/2025 9 309
7/11/2025 7 300
7/10/2025 8 292
7/9/2025 8 285
7/8/2025 0 277
7/7/2025 9 277
7/6/2025 9 268
7/5/2025 6 259
7/4/2025 7 252
7/3/2025 9 245
7/2/2025 8 237
7/1/2025 9 229
6/30/2025 9 220
6/29/2025 7 212
6/28/2025 8 205
6/27/2025 9 197
6/26/2025 8 188
6/25/2025 6 180
6/24/2025 6 174
6/23/2025 9 168
6/22/2025 9 159
6/21/2025 8 150
6/20/2025 8 142
6/19/2025 8 134
6/18/2025 5 126
6/17/2025 9 122
6/16/2025 8 112
6/15/2025 7 105
6/14/2025 7 97
6/13/2025 7 90
6/12/2025 7 83
6/11/2025 8 77
6/10/2025 5 69
6/9/2025 5 64
6/8/2025 9 60
6/7/2025 7 51
6/6/2025 6 44
6/5/2025 7 38
6/4/2025 8 31
6/3/2025 9 23
6/2/2025 7 14
6/1/2025 7 7