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 49.4371 2024-06-06 00:00:00.0 5.7123 223
2 56.6083 2024-06-07 00:00:00.0 7.1712 223
3 63.7742 2024-06-08 00:00:00.0 7.1659 223
4 69.6655 2024-06-09 00:00:00.0 5.8913 223
5 74.7083 2024-06-10 00:00:00.0 5.0428 223
6 83.3529 2024-06-11 00:00:00.0 8.6446 223
7 91.1508 2024-06-12 00:00:00.0 7.7979 223
8 99.6785 2024-06-13 00:00:00.0 8.5277 223
9 106.7398 2024-06-14 00:00:00.0 7.0613 223
10 115.1532 2024-06-15 00:00:00.0 8.4134 223
11 124.7434 2024-06-16 00:00:00.0 9.5902 223
12 132.2225 2024-06-17 00:00:00.0 7.4791 223
13 139.1962 2024-06-18 00:00:00.0 6.9737 223
14 146.6806 2024-06-19 00:00:00.0 7.4844 223
15 155.0747 2024-06-20 00:00:00.0 8.3941 223
16 163.8063 2024-06-21 00:00:00.0 8.7316 223
17 172.7513 2024-06-22 00:00:00.0 8.9450 223
18 181.8253 2024-06-23 00:00:00.0 9.0740 223
19 189.5095 2024-06-24 00:00:00.0 7.6842 223
20 198.8896 2024-06-25 00:00:00.0 9.3801 223
21 206.9793 2024-06-26 00:00:00.0 8.0897 223
22 213.7116 2024-06-27 00:00:00.0 6.7323 223
23 220.6321 2024-06-28 00:00:00.0 6.9205 223
24 227.6358 2024-06-29 00:00:00.0 7.0037 223
25 233.9033 2024-06-30 00:00:00.0 6.2675 223
26 242.4958 2024-07-01 00:00:00.0 8.5925 223
27 251.9756 2024-07-02 00:00:00.0 9.4798 223
28 261.3564 2024-07-03 00:00:00.0 9.3808 223
29 270.0197 2024-07-04 00:00:00.0 8.6633 223
30 279.0314 2024-07-05 00:00:00.0 9.0117 223
31 287.9307 2024-07-06 00:00:00.0 8.8993 223
32 296.6724 2024-07-07 00:00:00.0 8.7417 223
33 305.2854 2024-07-08 00:00:00.0 8.6130 223
34 313.5071 2024-07-09 00:00:00.0 8.2217 223
35 321.7932 2024-07-10 00:00:00.0 8.2861 223
36 329.1817 2024-07-11 00:00:00.0 7.3885 223
37 336.0020 2024-07-12 00:00:00.0 6.8203 223
38 344.0402 2024-07-13 00:00:00.0 8.0382 223
39 352.9716 2024-07-14 00:00:00.0 8.9314 223
40 362.3311 2024-07-15 00:00:00.0 9.3595 223
41 370.5590 2024-07-16 00:00:00.0 8.2279 223
42 377.9038 2024-07-17 00:00:00.0 7.3448 223
43 385.9479 2024-07-18 00:00:00.0 8.0441 223
44 394.4673 2024-07-19 00:00:00.0 8.5194 223
45 402.4123 2024-07-20 00:00:00.0 7.9450 223
46 410.8753 2024-07-21 00:00:00.0 8.4630 223
47 420.1246 2024-07-22 00:00:00.0 9.2493 223
48 429.6820 2024-07-23 00:00:00.0 9.5574 223
49 438.4289 2024-07-24 00:00:00.0 8.7469 223
50 447.0327 2024-07-25 00:00:00.0 8.6038 223
51 453.3823 2024-07-26 00:00:00.0 6.3496 223
52 461.5191 2024-07-27 00:00:00.0 8.1368 223
53 470.9708 2024-07-28 00:00:00.0 9.4517 223
54 479.3943 2024-07-29 00:00:00.0 8.4235 223
55 486.8397 2024-07-30 00:00:00.0 7.4454 223
56 494.4833 2024-07-31 00:00:00.0 7.6436 223
57 501.6512 2024-08-01 00:00:00.0 7.1679 223
58 509.9796 2024-08-02 00:00:00.0 8.3284 223
59 518.9145 2024-08-03 00:00:00.0 8.9349 223
60 526.3840 2024-08-04 00:00:00.0 7.4695 223
61 534.7639 2024-08-05 00:00:00.0 8.3799 223
62 541.3072 2024-08-06 00:00:00.0 6.5433 223
63 549.8016 2024-08-07 00:00:00.0 8.4944 223
64 556.5444 2024-08-08 00:00:00.0 6.7428 223
65 563.8669 2024-08-09 00:00:00.0 7.3225 223
66 571.4328 2024-08-10 00:00:00.0 7.5659 223
67 579.9196 2024-08-11 00:00:00.0 8.4868 223
68 587.4401 2024-08-12 00:00:00.0 7.5205 223
69 595.5984 2024-08-13 00:00:00.0 8.1583 223
70 604.7414 2024-08-14 00:00:00.0 9.1430 223
71 614.5707 2024-08-15 00:00:00.0 9.8293 223
72 624.0526 2024-08-16 00:00:00.0 9.4819 223
73 633.0481 2024-08-17 00:00:00.0 8.9955 223
74 641.0977 2024-08-18 00:00:00.0 8.0496 223
75 649.5224 2024-08-19 00:00:00.0 8.4247 223
76 657.8807 2024-08-20 00:00:00.0 8.3583 223
77 666.9093 2024-08-21 00:00:00.0 9.0286 223
78 676.4373 2024-08-22 00:00:00.0 9.5280 223
79 684.4562 2024-08-23 00:00:00.0 8.0189 223
80 692.0578 2024-08-24 00:00:00.0 7.6016 223
81 698.4354 2024-08-25 00:00:00.0 6.3776 223
82 707.6099 2024-08-26 00:00:00.0 9.1745 223
83 714.7381 2024-08-27 00:00:00.0 7.1282 223
84 721.8687 2024-08-28 00:00:00.0 7.1306 223
85 731.0690 2024-08-29 00:00:00.0 9.2003 223
86 739.8269 2024-08-30 00:00:00.0 8.7579 223
87 748.4061 2024-08-31 00:00:00.0 8.5792 223
88 755.7202 2024-09-01 00:00:00.0 7.3141 223
89 764.1219 2024-09-02 00:00:00.0 8.4017 223
90 772.4428 2024-09-03 00:00:00.0 8.3209 223
91 781.9410 2024-09-04 00:00:00.0 9.4982 223
92 788.3103 2024-09-05 00:00:00.0 6.3693 223
93 794.3190 2024-09-06 00:00:00.0 6.0087 223
94 801.3242 2024-09-07 00:00:00.0 7.0052 223
95 809.9387 2024-09-08 00:00:00.0 8.6145 223
96 817.8922 2024-09-09 00:00:00.0 7.9535 223
97 827.4429 2024-09-10 00:00:00.0 9.5507 223
98 835.6552 2024-09-11 00:00:00.0 8.2123 223
99 843.2466 2024-09-12 00:00:00.0 7.5914 223
100 851.7435 2024-09-13 00:00:00.0 8.4969 223
101 860.8242 2024-09-14 00:00:00.0 9.0807 223
102 869.9049 2024-09-15 00:00:00.0 9.0807 223
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '223') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-09-15'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/15/2024 9 870
9/14/2024 9 861
9/13/2024 8 852
9/12/2024 8 843
9/11/2024 8 836
9/10/2024 10 827
9/9/2024 8 818
9/8/2024 9 810
9/7/2024 7 801
9/6/2024 6 794
9/5/2024 6 788
9/4/2024 9 782
9/3/2024 8 772
9/2/2024 8 764
9/1/2024 7 756
8/31/2024 9 748
8/30/2024 9 740
8/29/2024 9 731
8/28/2024 7 722
8/27/2024 7 715
8/26/2024 9 708
8/25/2024 6 698
8/24/2024 8 692
8/23/2024 8 684
8/22/2024 10 676
8/21/2024 9 667
8/20/2024 8 658
8/19/2024 8 650
8/18/2024 8 641
8/17/2024 9 633
8/16/2024 9 624
8/15/2024 10 615
8/14/2024 9 605
8/13/2024 8 596
8/12/2024 8 587
8/11/2024 8 580
8/10/2024 8 571
8/9/2024 7 564
8/8/2024 7 557
8/7/2024 8 550
8/6/2024 7 541
8/5/2024 8 535
8/4/2024 7 526
8/3/2024 9 519
8/2/2024 8 510
8/1/2024 7 502
7/31/2024 8 494
7/30/2024 7 487
7/29/2024 8 479
7/28/2024 9 471
7/27/2024 8 462
7/26/2024 6 453
7/25/2024 9 447
7/24/2024 9 438
7/23/2024 10 430
7/22/2024 9 420
7/21/2024 8 411
7/20/2024 8 402
7/19/2024 9 394
7/18/2024 8 386
7/17/2024 7 378
7/16/2024 8 371
7/15/2024 9 362
7/14/2024 9 353
7/13/2024 8 344
7/12/2024 7 336
7/11/2024 7 329
7/10/2024 8 322
7/9/2024 8 314
7/8/2024 9 305
7/7/2024 9 297
7/6/2024 9 288
7/5/2024 9 279
7/4/2024 9 270
7/3/2024 9 261
7/2/2024 9 252
7/1/2024 9 242
6/30/2024 6 234
6/29/2024 7 228
6/28/2024 7 221
6/27/2024 7 214
6/26/2024 8 207
6/25/2024 9 199
6/24/2024 8 190
6/23/2024 9 182
6/22/2024 9 173
6/21/2024 9 164
6/20/2024 8 155
6/19/2024 7 147
6/18/2024 7 139
6/17/2024 7 132
6/16/2024 10 125
6/15/2024 8 115
6/14/2024 7 107
6/13/2024 9 100
6/12/2024 8 91
6/11/2024 9 83
6/10/2024 5 75
6/9/2024 6 70
6/8/2024 7 64
6/7/2024 7 57