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.6312 2025-06-01 00:00:00.0 7.6312 314
2 14.7821 2025-06-02 00:00:00.0 7.1509 314
3 22.3436 2025-06-03 00:00:00.0 7.5615 314
4 28.0596 2025-06-04 00:00:00.0 5.7160 314
5 33.3388 2025-06-05 00:00:00.0 5.2792 314
6 38.5597 2025-06-06 00:00:00.0 5.2209 314
7 45.4490 2025-06-07 00:00:00.0 6.8893 314
8 52.7558 2025-06-08 00:00:00.0 7.3068 314
9 55.7987 2025-06-09 00:00:00.0 3.0429 314
10 61.9497 2025-06-10 00:00:00.0 6.1510 314
11 69.5863 2025-06-11 00:00:00.0 7.6366 314
12 75.6057 2025-06-12 00:00:00.0 6.0194 314
13 81.5348 2025-06-13 00:00:00.0 5.9291 314
14 87.9872 2025-06-14 00:00:00.0 6.4524 314
15 94.5631 2025-06-15 00:00:00.0 6.5759 314
16 102.7069 2025-06-16 00:00:00.0 8.1438 314
17 111.7734 2025-06-17 00:00:00.0 9.0665 314
18 119.6243 2025-06-18 00:00:00.0 7.8509 314
19 128.0673 2025-06-19 00:00:00.0 8.4430 314
20 136.1067 2025-06-20 00:00:00.0 8.0394 314
21 144.7056 2025-06-21 00:00:00.0 8.5989 314
22 153.9307 2025-06-22 00:00:00.0 9.2251 314
23 160.4151 2025-06-23 00:00:00.0 6.4844 314
24 164.3954 2025-06-24 00:00:00.0 3.9803 314
25 170.2641 2025-06-25 00:00:00.0 5.8687 314
26 176.4010 2025-06-26 00:00:00.0 6.1369 314
27 184.6931 2025-06-27 00:00:00.0 8.2921 314
28 192.5617 2025-06-28 00:00:00.0 7.8686 314
29 200.3930 2025-06-29 00:00:00.0 7.8313 314
30 209.5813 2025-06-30 00:00:00.0 9.1883 314
31 218.6650 2025-07-01 00:00:00.0 9.0837 314
32 226.8734 2025-07-02 00:00:00.0 8.2084 314
33 235.3844 2025-07-03 00:00:00.0 8.5110 314
34 242.8033 2025-07-04 00:00:00.0 7.4189 314
35 251.1207 2025-07-05 00:00:00.0 8.3174 314
36 259.1106 2025-07-06 00:00:00.0 7.9899 314
37 264.9761 2025-07-07 00:00:00.0 5.8655 314
38 264.9761 2025-07-08 00:00:00.0 0.0000 314
39 271.4198 2025-07-09 00:00:00.0 6.4437 314
40 279.6640 2025-07-10 00:00:00.0 8.2442 314
41 288.3518 2025-07-11 00:00:00.0 8.6878 314
42 296.7809 2025-07-12 00:00:00.0 8.4291 314
43 304.7591 2025-07-13 00:00:00.0 7.9782 314
44 313.3529 2025-07-14 00:00:00.0 8.5938 314
45 321.2013 2025-07-15 00:00:00.0 7.8484 314
46 327.6530 2025-07-16 00:00:00.0 6.4517 314
47 333.4868 2025-07-17 00:00:00.0 5.8338 314
48 338.7549 2025-07-18 00:00:00.0 5.2681 314
49 345.1706 2025-07-19 00:00:00.0 6.4157 314
50 351.4396 2025-07-20 00:00:00.0 6.2690 314
51 360.2124 2025-07-21 00:00:00.0 8.7728 314
52 369.1130 2025-07-22 00:00:00.0 8.9006 314
53 377.9108 2025-07-23 00:00:00.0 8.7978 314
54 386.8031 2025-07-24 00:00:00.0 8.8923 314
55 395.9939 2025-07-25 00:00:00.0 9.1908 314
56 403.7093 2025-07-26 00:00:00.0 7.7154 314
57 412.2839 2025-07-27 00:00:00.0 8.5746 314
58 421.3756 2025-07-28 00:00:00.0 9.0917 314
59 429.5135 2025-07-29 00:00:00.0 8.1379 314
60 437.1163 2025-07-30 00:00:00.0 7.6028 314
61 443.7347 2025-07-31 00:00:00.0 6.6184 314
62 450.0476 2025-08-01 00:00:00.0 6.3129 314
63 457.2196 2025-08-02 00:00:00.0 7.1720 314
64 465.6357 2025-08-03 00:00:00.0 8.4161 314
65 474.0829 2025-08-04 00:00:00.0 8.4472 314
66 482.0275 2025-08-05 00:00:00.0 7.9446 314
67 491.4725 2025-08-06 00:00:00.0 9.4450 314
68 500.5094 2025-08-07 00:00:00.0 9.0369 314
69 508.4663 2025-08-08 00:00:00.0 7.9569 314
70 518.2097 2025-08-09 00:00:00.0 9.7434 314
71 526.1218 2025-08-10 00:00:00.0 7.9121 314
72 534.8534 2025-08-11 00:00:00.0 8.7316 314
73 543.7341 2025-08-12 00:00:00.0 8.8807 314
74 551.2511 2025-08-13 00:00:00.0 7.5170 314
75 558.0621 2025-08-14 00:00:00.0 6.8110 314
76 566.7628 2025-08-15 00:00:00.0 8.7007 314
77 573.6942 2025-08-16 00:00:00.0 6.9314 314
78 580.2765 2025-08-17 00:00:00.0 6.5823 314
79 587.5988 2025-08-18 00:00:00.0 7.3223 314
80 596.7881 2025-08-19 00:00:00.0 9.1893 314
81 605.9759 2025-08-20 00:00:00.0 9.1878 314
82 613.7429 2025-08-21 00:00:00.0 7.7670 314
83 622.1994 2025-08-22 00:00:00.0 8.4565 314
84 628.7195 2025-08-23 00:00:00.0 6.5201 314
85 634.8731 2025-08-24 00:00:00.0 6.1536 314
86 640.0814 2025-08-25 00:00:00.0 5.2083 314
87 646.1360 2025-08-26 00:00:00.0 6.0546 314
88 653.3211 2025-08-27 00:00:00.0 7.1851 314
89 661.2838 2025-08-28 00:00:00.0 7.9627 314
90 668.7382 2025-08-29 00:00:00.0 7.4544 314
91 676.0872 2025-08-30 00:00:00.0 7.3490 314
92 683.2308 2025-08-31 00:00:00.0 7.1436 314
93 691.0276 2025-09-01 00:00:00.0 7.7968 314
94 699.4467 2025-09-02 00:00:00.0 8.4191 314
95 704.7781 2025-09-03 00:00:00.0 5.3314 314
96 706.6144 2025-09-04 00:00:00.0 1.8363 314
97 706.9152 2025-09-05 00:00:00.0 0.3008 314
98 709.9090 2025-09-06 00:00:00.0 2.9938 314
99 712.0439 2025-09-07 00:00:00.0 2.1349 314
100 715.7374 2025-09-08 00:00:00.0 3.6935 314
101 722.0148 2025-09-09 00:00:00.0 6.2774 314
102 729.4113 2025-09-10 00:00:00.0 7.3965 314
103 736.9494 2025-09-11 00:00:00.0 7.5381 314
104 745.6645 2025-09-12 00:00:00.0 8.7151 314
105 754.6370 2025-09-13 00:00:00.0 8.9725 314
106 763.8317 2025-09-14 00:00:00.0 9.1947 314
107 773.4700 2025-09-15 00:00:00.0 9.6383 314
108 783.0393 2025-09-16 00:00:00.0 9.5693 314
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '314') 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 773
9/14/2025 9 764
9/13/2025 9 755
9/12/2025 9 746
9/11/2025 8 737
9/10/2025 7 729
9/9/2025 6 722
9/8/2025 4 716
9/7/2025 2 712
9/6/2025 3 710
9/5/2025 0 707
9/4/2025 2 707
9/3/2025 5 705
9/2/2025 8 699
9/1/2025 8 691
8/31/2025 7 683
8/30/2025 7 676
8/29/2025 7 669
8/28/2025 8 661
8/27/2025 7 653
8/26/2025 6 646
8/25/2025 5 640
8/24/2025 6 635
8/23/2025 7 629
8/22/2025 8 622
8/21/2025 8 614
8/20/2025 9 606
8/19/2025 9 597
8/18/2025 7 588
8/17/2025 7 580
8/16/2025 7 574
8/15/2025 9 567
8/14/2025 7 558
8/13/2025 8 551
8/12/2025 9 544
8/11/2025 9 535
8/10/2025 8 526
8/9/2025 10 518
8/8/2025 8 508
8/7/2025 9 501
8/6/2025 9 491
8/5/2025 8 482
8/4/2025 8 474
8/3/2025 8 466
8/2/2025 7 457
8/1/2025 6 450
7/31/2025 7 444
7/30/2025 8 437
7/29/2025 8 430
7/28/2025 9 421
7/27/2025 9 412
7/26/2025 8 404
7/25/2025 9 396
7/24/2025 9 387
7/23/2025 9 378
7/22/2025 9 369
7/21/2025 9 360
7/20/2025 6 351
7/19/2025 6 345
7/18/2025 5 339
7/17/2025 6 333
7/16/2025 6 328
7/15/2025 8 321
7/14/2025 9 313
7/13/2025 8 305
7/12/2025 8 297
7/11/2025 9 288
7/10/2025 8 280
7/9/2025 6 271
7/8/2025 0 265
7/7/2025 6 265
7/6/2025 8 259
7/5/2025 8 251
7/4/2025 7 243
7/3/2025 9 235
7/2/2025 8 227
7/1/2025 9 219
6/30/2025 9 210
6/29/2025 8 200
6/28/2025 8 193
6/27/2025 8 185
6/26/2025 6 176
6/25/2025 6 170
6/24/2025 4 164
6/23/2025 6 160
6/22/2025 9 154
6/21/2025 9 145
6/20/2025 8 136
6/19/2025 8 128
6/18/2025 8 120
6/17/2025 9 112
6/16/2025 8 103
6/15/2025 7 95
6/14/2025 6 88
6/13/2025 6 82
6/12/2025 6 76
6/11/2025 8 70
6/10/2025 6 62
6/9/2025 3 56
6/8/2025 7 53
6/7/2025 7 45
6/6/2025 5 39
6/5/2025 5 33
6/4/2025 6 28
6/3/2025 8 22
6/2/2025 7 15
6/1/2025 8 8