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 4.5349 2022-06-06 00:00:00.0 4.5349 246
2 10.5517 2022-06-07 00:00:00.0 6.0168 246
3 16.0909 2022-06-08 00:00:00.0 5.5392 246
4 22.2224 2022-06-09 00:00:00.0 6.1315 246
5 31.1945 2022-06-10 00:00:00.0 8.9721 246
6 40.0424 2022-06-11 00:00:00.0 8.8479 246
7 49.3937 2022-06-12 00:00:00.0 9.3513 246
8 58.3433 2022-06-13 00:00:00.0 8.9496 246
9 67.1220 2022-06-14 00:00:00.0 8.7787 246
10 75.0228 2022-06-15 00:00:00.0 7.9008 246
11 83.1988 2022-06-16 00:00:00.0 8.1760 246
12 90.8866 2022-06-17 00:00:00.0 7.6878 246
13 99.1237 2022-06-18 00:00:00.0 8.2371 246
14 102.6478 2022-06-19 00:00:00.0 3.5241 246
15 111.4342 2022-06-20 00:00:00.0 8.7864 246
16 120.1939 2022-06-21 00:00:00.0 8.7597 246
17 127.9340 2022-06-22 00:00:00.0 7.7401 246
18 135.4374 2022-06-23 00:00:00.0 7.5034 246
19 144.5703 2022-06-24 00:00:00.0 9.1329 246
20 151.1507 2022-06-25 00:00:00.0 6.5804 246
21 158.5279 2022-06-26 00:00:00.0 7.3772 246
22 166.1958 2022-06-27 00:00:00.0 7.6679 246
23 173.8381 2022-06-28 00:00:00.0 7.6423 246
24 181.6851 2022-06-29 00:00:00.0 7.8470 246
25 190.5324 2022-06-30 00:00:00.0 8.8473 246
26 197.3835 2022-07-01 00:00:00.0 6.8511 246
27 203.7649 2022-07-02 00:00:00.0 6.3814 246
28 212.5503 2022-07-03 00:00:00.0 8.7854 246
29 222.1780 2022-07-04 00:00:00.0 9.6277 246
30 231.5614 2022-07-05 00:00:00.0 9.3834 246
31 240.3924 2022-07-06 00:00:00.0 8.8310 246
32 249.2741 2022-07-07 00:00:00.0 8.8817 246
33 257.4955 2022-07-08 00:00:00.0 8.2214 246
34 265.8249 2022-07-09 00:00:00.0 8.3294 246
35 274.8700 2022-07-10 00:00:00.0 9.0451 246
36 284.1308 2022-07-11 00:00:00.0 9.2608 246
37 293.0798 2022-07-12 00:00:00.0 8.9490 246
38 300.8587 2022-07-13 00:00:00.0 7.7789 246
39 310.3850 2022-07-14 00:00:00.0 9.5263 246
40 318.8634 2022-07-15 00:00:00.0 8.4784 246
41 327.5170 2022-07-16 00:00:00.0 8.6536 246
42 334.1007 2022-07-17 00:00:00.0 6.5837 246
43 342.8561 2022-07-18 00:00:00.0 8.7554 246
44 352.5243 2022-07-19 00:00:00.0 9.6682 246
45 361.8157 2022-07-20 00:00:00.0 9.2914 246
46 370.4365 2022-07-21 00:00:00.0 8.6208 246
47 378.8494 2022-07-22 00:00:00.0 8.4129 246
48 387.8481 2022-07-23 00:00:00.0 8.9987 246
49 395.4026 2022-07-24 00:00:00.0 7.5545 246
50 402.4308 2022-07-25 00:00:00.0 7.0282 246
51 411.2196 2022-07-26 00:00:00.0 8.7888 246
52 418.9740 2022-07-27 00:00:00.0 7.7544 246
53 426.9552 2022-07-28 00:00:00.0 7.9812 246
54 434.3519 2022-07-29 00:00:00.0 7.3967 246
55 442.1563 2022-07-30 00:00:00.0 7.8044 246
56 450.5792 2022-07-31 00:00:00.0 8.4229 246
57 458.2123 2022-08-01 00:00:00.0 7.6331 246
58 466.4181 2022-08-02 00:00:00.0 8.2058 246
59 474.0864 2022-08-03 00:00:00.0 7.6683 246
60 481.7602 2022-08-04 00:00:00.0 7.6738 246
61 491.0594 2022-08-05 00:00:00.0 9.2992 246
62 497.4629 2022-08-06 00:00:00.0 6.4035 246
63 502.5801 2022-08-07 00:00:00.0 5.1172 246
64 510.5983 2022-08-08 00:00:00.0 8.0182 246
65 519.4637 2022-08-09 00:00:00.0 8.8654 246
66 526.8085 2022-08-10 00:00:00.0 7.3448 246
67 532.9201 2022-08-11 00:00:00.0 6.1116 246
68 542.3000 2022-08-12 00:00:00.0 9.3799 246
69 550.0880 2022-08-13 00:00:00.0 7.7880 246
70 557.6864 2022-08-14 00:00:00.0 7.5984 246
71 566.8422 2022-08-15 00:00:00.0 9.1558 246
72 575.1531 2022-08-16 00:00:00.0 8.3109 246
73 583.0293 2022-08-17 00:00:00.0 7.8762 246
74 592.5101 2022-08-18 00:00:00.0 9.4808 246
75 601.6102 2022-08-19 00:00:00.0 9.1001 246
76 608.4173 2022-08-20 00:00:00.0 6.8071 246
77 615.5647 2022-08-21 00:00:00.0 7.1474 246
78 623.7522 2022-08-22 00:00:00.0 8.1875 246
79 632.4650 2022-08-23 00:00:00.0 8.7128 246
80 639.7562 2022-08-24 00:00:00.0 7.2912 246
81 645.7410 2022-08-25 00:00:00.0 5.9848 246
82 654.1333 2022-08-26 00:00:00.0 8.3923 246
83 662.2658 2022-08-27 00:00:00.0 8.1325 246
84 671.3433 2022-08-28 00:00:00.0 9.0775 246
85 680.0611 2022-08-29 00:00:00.0 8.7178 246
86 687.5939 2022-08-30 00:00:00.0 7.5328 246
87 694.6347 2022-08-31 00:00:00.0 7.0408 246
88 701.7801 2022-09-01 00:00:00.0 7.1454 246
89 709.2196 2022-09-02 00:00:00.0 7.4395 246
90 715.4711 2022-09-03 00:00:00.0 6.2515 246
91 723.3756 2022-09-04 00:00:00.0 7.9045 246
92 732.4000 2022-09-05 00:00:00.0 9.0244 246
93 739.3810 2022-09-06 00:00:00.0 6.9810 246
94 745.4128 2022-09-07 00:00:00.0 6.0318 246
95 753.1406 2022-09-08 00:00:00.0 7.7278 246
96 758.6315 2022-09-09 00:00:00.0 5.4909 246
97 762.9090 2022-09-10 00:00:00.0 4.2775 246
98 768.4521 2022-09-11 00:00:00.0 5.5431 246
99 774.5176 2022-09-12 00:00:00.0 6.0655 246
100 778.6090 2022-09-13 00:00:00.0 4.0914 246
101 783.6260 2022-09-14 00:00:00.0 5.0170 246
102 790.0939 2022-09-15 00:00:00.0 6.4679 246
103 794.7241 2022-09-16 00:00:00.0 4.6302 246
104 800.8981 2022-09-17 00:00:00.0 6.1740 246
105 807.8752 2022-09-18 00:00:00.0 6.9771 246
106 813.5695 2022-09-19 00:00:00.0 5.6943 246
107 820.9410 2022-09-20 00:00:00.0 7.3715 246
108 823.3210 2022-09-21 00:00:00.0 2.3800 246
109 825.8041 2022-09-22 00:00:00.0 2.4831 246
110 831.2682 2022-09-23 00:00:00.0 5.4641 246
111 838.3648 2022-09-24 00:00:00.0 7.0966 246
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '246') 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 7 838
9/23/2022 5 831
9/22/2022 2 826
9/21/2022 2 823
9/20/2022 7 821
9/19/2022 6 814
9/18/2022 7 808
9/17/2022 6 801
9/16/2022 5 795
9/15/2022 6 790
9/14/2022 5 784
9/13/2022 4 779
9/12/2022 6 775
9/11/2022 6 768
9/10/2022 4 763
9/9/2022 5 759
9/8/2022 8 753
9/7/2022 6 745
9/6/2022 7 739
9/5/2022 9 732
9/4/2022 8 723
9/3/2022 6 715
9/2/2022 7 709
9/1/2022 7 702
8/31/2022 7 695
8/30/2022 8 688
8/29/2022 9 680
8/28/2022 9 671
8/27/2022 8 662
8/26/2022 8 654
8/25/2022 6 646
8/24/2022 7 640
8/23/2022 9 632
8/22/2022 8 624
8/21/2022 7 616
8/20/2022 7 608
8/19/2022 9 602
8/18/2022 9 593
8/17/2022 8 583
8/16/2022 8 575
8/15/2022 9 567
8/14/2022 8 558
8/13/2022 8 550
8/12/2022 9 542
8/11/2022 6 533
8/10/2022 7 527
8/9/2022 9 519
8/8/2022 8 511
8/7/2022 5 503
8/6/2022 6 497
8/5/2022 9 491
8/4/2022 8 482
8/3/2022 8 474
8/2/2022 8 466
8/1/2022 8 458
7/31/2022 8 451
7/30/2022 8 442
7/29/2022 7 434
7/28/2022 8 427
7/27/2022 8 419
7/26/2022 9 411
7/25/2022 7 402
7/24/2022 8 395
7/23/2022 9 388
7/22/2022 8 379
7/21/2022 9 370
7/20/2022 9 362
7/19/2022 10 353
7/18/2022 9 343
7/17/2022 7 334
7/16/2022 9 328
7/15/2022 8 319
7/14/2022 10 310
7/13/2022 8 301
7/12/2022 9 293
7/11/2022 9 284
7/10/2022 9 275
7/9/2022 8 266
7/8/2022 8 257
7/7/2022 9 249
7/6/2022 9 240
7/5/2022 9 232
7/4/2022 10 222
7/3/2022 9 213
7/2/2022 6 204
7/1/2022 7 197
6/30/2022 9 191
6/29/2022 8 182
6/28/2022 8 174
6/27/2022 8 166
6/26/2022 7 159
6/25/2022 7 151
6/24/2022 9 145
6/23/2022 8 135
6/22/2022 8 128
6/21/2022 9 120
6/20/2022 9 111
6/19/2022 4 103
6/18/2022 8 99
6/17/2022 8 91
6/16/2022 8 83
6/15/2022 8 75
6/14/2022 9 67
6/13/2022 9 58
6/12/2022 9 49
6/11/2022 9 40
6/10/2022 9 31
6/9/2022 6 22
6/8/2022 6 16
6/7/2022 6 11