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 5.7487 2022-06-06 00:00:00.0 5.7487 325
2 12.4969 2022-06-07 00:00:00.0 6.7482 325
3 19.8698 2022-06-08 00:00:00.0 7.3729 325
4 26.7197 2022-06-09 00:00:00.0 6.8499 325
5 35.4063 2022-06-10 00:00:00.0 8.6866 325
6 44.3542 2022-06-11 00:00:00.0 8.9479 325
7 53.5560 2022-06-12 00:00:00.0 9.2018 325
8 62.4477 2022-06-13 00:00:00.0 8.8917 325
9 71.7585 2022-06-14 00:00:00.0 9.3108 325
10 80.6366 2022-06-15 00:00:00.0 8.8781 325
11 89.1921 2022-06-16 00:00:00.0 8.5555 325
12 97.9196 2022-06-17 00:00:00.0 8.7275 325
13 105.9005 2022-06-18 00:00:00.0 7.9809 325
14 110.0256 2022-06-19 00:00:00.0 4.1251 325
15 118.6287 2022-06-20 00:00:00.0 8.6031 325
16 127.5389 2022-06-21 00:00:00.0 8.9102 325
17 135.5802 2022-06-22 00:00:00.0 8.0413 325
18 142.4347 2022-06-23 00:00:00.0 6.8545 325
19 151.8598 2022-06-24 00:00:00.0 9.4251 325
20 160.0501 2022-06-25 00:00:00.0 8.1903 325
21 168.2157 2022-06-26 00:00:00.0 8.1656 325
22 176.5564 2022-06-27 00:00:00.0 8.3407 325
23 185.0198 2022-06-28 00:00:00.0 8.4634 325
24 193.2768 2022-06-29 00:00:00.0 8.2570 325
25 202.3842 2022-06-30 00:00:00.0 9.1074 325
26 210.1806 2022-07-01 00:00:00.0 7.7964 325
27 218.3827 2022-07-02 00:00:00.0 8.2021 325
28 227.2578 2022-07-03 00:00:00.0 8.8751 325
29 236.7833 2022-07-04 00:00:00.0 9.5255 325
30 246.2162 2022-07-05 00:00:00.0 9.4329 325
31 255.1616 2022-07-06 00:00:00.0 8.9454 325
32 264.5147 2022-07-07 00:00:00.0 9.3531 325
33 273.1566 2022-07-08 00:00:00.0 8.6419 325
34 281.2079 2022-07-09 00:00:00.0 8.0513 325
35 290.5811 2022-07-10 00:00:00.0 9.3732 325
36 300.0301 2022-07-11 00:00:00.0 9.4490 325
37 309.4801 2022-07-12 00:00:00.0 9.4500 325
38 318.1808 2022-07-13 00:00:00.0 8.7007 325
39 327.7990 2022-07-14 00:00:00.0 9.6182 325
40 336.1772 2022-07-15 00:00:00.0 8.3782 325
41 344.9570 2022-07-16 00:00:00.0 8.7798 325
42 350.8203 2022-07-17 00:00:00.0 5.8633 325
43 359.0366 2022-07-18 00:00:00.0 8.2163 325
44 368.7488 2022-07-19 00:00:00.0 9.7122 325
45 377.9804 2022-07-20 00:00:00.0 9.2316 325
46 387.2544 2022-07-21 00:00:00.0 9.2740 325
47 396.8104 2022-07-22 00:00:00.0 9.5560 325
48 405.7802 2022-07-23 00:00:00.0 8.9698 325
49 414.1245 2022-07-24 00:00:00.0 8.3443 325
50 422.3809 2022-07-25 00:00:00.0 8.2564 325
51 431.3891 2022-07-26 00:00:00.0 9.0082 325
52 439.7647 2022-07-27 00:00:00.0 8.3756 325
53 448.3678 2022-07-28 00:00:00.0 8.6031 325
54 455.9602 2022-07-29 00:00:00.0 7.5924 325
55 463.8309 2022-07-30 00:00:00.0 7.8707 325
56 472.4485 2022-07-31 00:00:00.0 8.6176 325
57 480.8802 2022-08-01 00:00:00.0 8.4317 325
58 489.1664 2022-08-02 00:00:00.0 8.2862 325
59 497.5535 2022-08-03 00:00:00.0 8.3871 325
60 505.8369 2022-08-04 00:00:00.0 8.2834 325
61 514.6369 2022-08-05 00:00:00.0 8.8000 325
62 522.0777 2022-08-06 00:00:00.0 7.4408 325
63 528.1378 2022-08-07 00:00:00.0 6.0601 325
64 535.8905 2022-08-08 00:00:00.0 7.7527 325
65 545.0861 2022-08-09 00:00:00.0 9.1956 325
66 552.5843 2022-08-10 00:00:00.0 7.4982 325
67 558.9839 2022-08-11 00:00:00.0 6.3996 325
68 568.3338 2022-08-12 00:00:00.0 9.3499 325
69 576.6144 2022-08-13 00:00:00.0 8.2806 325
70 584.8812 2022-08-14 00:00:00.0 8.2668 325
71 594.4705 2022-08-15 00:00:00.0 9.5893 325
72 603.0921 2022-08-16 00:00:00.0 8.6216 325
73 611.1425 2022-08-17 00:00:00.0 8.0504 325
74 620.9664 2022-08-18 00:00:00.0 9.8239 325
75 630.1321 2022-08-19 00:00:00.0 9.1657 325
76 637.4558 2022-08-20 00:00:00.0 7.3237 325
77 645.4166 2022-08-21 00:00:00.0 7.9608 325
78 654.3657 2022-08-22 00:00:00.0 8.9491 325
79 663.4664 2022-08-23 00:00:00.0 9.1007 325
80 671.4198 2022-08-24 00:00:00.0 7.9534 325
81 677.6745 2022-08-25 00:00:00.0 6.2547 325
82 686.5804 2022-08-26 00:00:00.0 8.9059 325
83 695.0378 2022-08-27 00:00:00.0 8.4574 325
84 704.1368 2022-08-28 00:00:00.0 9.0990 325
85 713.4525 2022-08-29 00:00:00.0 9.3157 325
86 722.0595 2022-08-30 00:00:00.0 8.6070 325
87 729.2092 2022-08-31 00:00:00.0 7.1497 325
88 736.4095 2022-09-01 00:00:00.0 7.2003 325
89 744.5435 2022-09-02 00:00:00.0 8.1340 325
90 750.9532 2022-09-03 00:00:00.0 6.4097 325
91 758.5415 2022-09-04 00:00:00.0 7.5883 325
92 766.9688 2022-09-05 00:00:00.0 8.4273 325
93 774.9164 2022-09-06 00:00:00.0 7.9476 325
94 781.2777 2022-09-07 00:00:00.0 6.3613 325
95 789.9802 2022-09-08 00:00:00.0 8.7025 325
96 796.8115 2022-09-09 00:00:00.0 6.8313 325
97 802.0933 2022-09-10 00:00:00.0 5.2818 325
98 808.0825 2022-09-11 00:00:00.0 5.9892 325
99 815.4038 2022-09-12 00:00:00.0 7.3213 325
100 820.4697 2022-09-13 00:00:00.0 5.0659 325
101 827.4242 2022-09-14 00:00:00.0 6.9545 325
102 834.8598 2022-09-15 00:00:00.0 7.4356 325
103 840.5892 2022-09-16 00:00:00.0 5.7294 325
104 847.8412 2022-09-17 00:00:00.0 7.2520 325
105 854.9808 2022-09-18 00:00:00.0 7.1396 325
106 861.1935 2022-09-19 00:00:00.0 6.2127 325
107 868.7754 2022-09-20 00:00:00.0 7.5819 325
108 873.1445 2022-09-21 00:00:00.0 4.3691 325
109 875.6232 2022-09-22 00:00:00.0 2.4787 325
110 879.6126 2022-09-23 00:00:00.0 3.9894 325
111 887.3393 2022-09-24 00:00:00.0 7.7267 325
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '325') AND ddate BETWEEN {d '2022-06-06'} AND {d '2022-09-24'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/24/2022 8 887
9/23/2022 4 880
9/22/2022 2 876
9/21/2022 4 873
9/20/2022 8 869
9/19/2022 6 861
9/18/2022 7 855
9/17/2022 7 848
9/16/2022 6 841
9/15/2022 7 835
9/14/2022 7 827
9/13/2022 5 820
9/12/2022 7 815
9/11/2022 6 808
9/10/2022 5 802
9/9/2022 7 797
9/8/2022 9 790
9/7/2022 6 781
9/6/2022 8 775
9/5/2022 8 767
9/4/2022 8 759
9/3/2022 6 751
9/2/2022 8 745
9/1/2022 7 736
8/31/2022 7 729
8/30/2022 9 722
8/29/2022 9 713
8/28/2022 9 704
8/27/2022 8 695
8/26/2022 9 687
8/25/2022 6 678
8/24/2022 8 671
8/23/2022 9 663
8/22/2022 9 654
8/21/2022 8 645
8/20/2022 7 637
8/19/2022 9 630
8/18/2022 10 621
8/17/2022 8 611
8/16/2022 9 603
8/15/2022 10 594
8/14/2022 8 585
8/13/2022 8 577
8/12/2022 9 568
8/11/2022 6 559
8/10/2022 7 553
8/9/2022 9 545
8/8/2022 8 536
8/7/2022 6 528
8/6/2022 7 522
8/5/2022 9 515
8/4/2022 8 506
8/3/2022 8 498
8/2/2022 8 489
8/1/2022 8 481
7/31/2022 9 472
7/30/2022 8 464
7/29/2022 8 456
7/28/2022 9 448
7/27/2022 8 440
7/26/2022 9 431
7/25/2022 8 422
7/24/2022 8 414
7/23/2022 9 406
7/22/2022 10 397
7/21/2022 9 387
7/20/2022 9 378
7/19/2022 10 369
7/18/2022 8 359
7/17/2022 6 351
7/16/2022 9 345
7/15/2022 8 336
7/14/2022 10 328
7/13/2022 9 318
7/12/2022 9 309
7/11/2022 9 300
7/10/2022 9 291
7/9/2022 8 281
7/8/2022 9 273
7/7/2022 9 265
7/6/2022 9 255
7/5/2022 9 246
7/4/2022 10 237
7/3/2022 9 227
7/2/2022 8 218
7/1/2022 8 210
6/30/2022 9 202
6/29/2022 8 193
6/28/2022 8 185
6/27/2022 8 177
6/26/2022 8 168
6/25/2022 8 160
6/24/2022 9 152
6/23/2022 7 142
6/22/2022 8 136
6/21/2022 9 128
6/20/2022 9 119
6/19/2022 4 110
6/18/2022 8 106
6/17/2022 9 98
6/16/2022 9 89
6/15/2022 9 81
6/14/2022 9 72
6/13/2022 9 62
6/12/2022 9 54
6/11/2022 9 44
6/10/2022 9 35
6/9/2022 7 27
6/8/2022 7 20
6/7/2022 7 12