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.2168 2022-06-06 00:00:00.0 5.2168 237
2 10.4336 2022-06-07 00:00:00.0 5.2168 237
3 15.6504 2022-06-08 00:00:00.0 5.2168 237
4 20.8672 2022-06-09 00:00:00.0 5.2168 237
5 26.0840 2022-06-10 00:00:00.0 5.2168 237
6 35.0319 2022-06-11 00:00:00.0 8.9479 237
7 44.2463 2022-06-12 00:00:00.0 9.2144 237
8 52.9989 2022-06-13 00:00:00.0 8.7526 237
9 62.1936 2022-06-14 00:00:00.0 9.1947 237
10 70.9000 2022-06-15 00:00:00.0 8.7064 237
11 79.4089 2022-06-16 00:00:00.0 8.5089 237
12 87.8878 2022-06-17 00:00:00.0 8.4789 237
13 96.0295 2022-06-18 00:00:00.0 8.1417 237
14 100.6111 2022-06-19 00:00:00.0 4.5816 237
15 108.8094 2022-06-20 00:00:00.0 8.1983 237
16 117.5792 2022-06-21 00:00:00.0 8.7698 237
17 125.4983 2022-06-22 00:00:00.0 7.9191 237
18 132.7207 2022-06-23 00:00:00.0 7.2224 237
19 141.4430 2022-06-24 00:00:00.0 8.7223 237
20 149.4994 2022-06-25 00:00:00.0 8.0564 237
21 157.8035 2022-06-26 00:00:00.0 8.3041 237
22 165.8941 2022-06-27 00:00:00.0 8.0906 237
23 173.9738 2022-06-28 00:00:00.0 8.0797 237
24 181.0081 2022-06-29 00:00:00.0 7.0343 237
25 189.5771 2022-06-30 00:00:00.0 8.5690 237
26 197.9246 2022-07-01 00:00:00.0 8.3475 237
27 205.6791 2022-07-02 00:00:00.0 7.7545 237
28 214.3030 2022-07-03 00:00:00.0 8.6239 237
29 223.8411 2022-07-04 00:00:00.0 9.5381 237
30 233.1910 2022-07-05 00:00:00.0 9.3499 237
31 242.0081 2022-07-06 00:00:00.0 8.8171 237
32 251.2524 2022-07-07 00:00:00.0 9.2443 237
33 259.5717 2022-07-08 00:00:00.0 8.3193 237
34 267.1660 2022-07-09 00:00:00.0 7.5943 237
35 276.1317 2022-07-10 00:00:00.0 8.9657 237
36 285.2713 2022-07-11 00:00:00.0 9.1396 237
37 294.6891 2022-07-12 00:00:00.0 9.4178 237
38 303.0604 2022-07-13 00:00:00.0 8.3713 237
39 312.2863 2022-07-14 00:00:00.0 9.2259 237
40 320.4625 2022-07-15 00:00:00.0 8.1762 237
41 329.1388 2022-07-16 00:00:00.0 8.6763 237
42 334.7370 2022-07-17 00:00:00.0 5.5982 237
43 342.1565 2022-07-18 00:00:00.0 7.4195 237
44 351.5543 2022-07-19 00:00:00.0 9.3978 237
45 360.3223 2022-07-20 00:00:00.0 8.7680 237
46 369.2425 2022-07-21 00:00:00.0 8.9202 237
47 378.2212 2022-07-22 00:00:00.0 8.9787 237
48 387.3329 2022-07-23 00:00:00.0 9.1117 237
49 395.6788 2022-07-24 00:00:00.0 8.3459 237
50 404.1683 2022-07-25 00:00:00.0 8.4895 237
51 413.1582 2022-07-26 00:00:00.0 8.9899 237
52 421.7849 2022-07-27 00:00:00.0 8.6267 237
53 430.6884 2022-07-28 00:00:00.0 8.9035 237
54 439.1458 2022-07-29 00:00:00.0 8.4574 237
55 446.5340 2022-07-30 00:00:00.0 7.3882 237
56 455.8668 2022-07-31 00:00:00.0 9.3328 237
57 464.5088 2022-08-01 00:00:00.0 8.6420 237
58 472.3942 2022-08-02 00:00:00.0 7.8854 237
59 481.3245 2022-08-03 00:00:00.0 8.9303 237
60 489.3935 2022-08-04 00:00:00.0 8.0690 237
61 497.7100 2022-08-05 00:00:00.0 8.3165 237
62 505.5653 2022-08-06 00:00:00.0 7.8553 237
63 511.8919 2022-08-07 00:00:00.0 6.3266 237
64 519.2084 2022-08-08 00:00:00.0 7.3165 237
65 528.5099 2022-08-09 00:00:00.0 9.3015 237
66 537.0184 2022-08-10 00:00:00.0 8.5085 237
67 543.4502 2022-08-11 00:00:00.0 6.4318 237
68 552.4553 2022-08-12 00:00:00.0 9.0051 237
69 560.4243 2022-08-13 00:00:00.0 7.9690 237
70 568.2189 2022-08-14 00:00:00.0 7.7946 237
71 577.4036 2022-08-15 00:00:00.0 9.1847 237
72 585.9609 2022-08-16 00:00:00.0 8.5573 237
73 593.6706 2022-08-17 00:00:00.0 7.7097 237
74 603.4212 2022-08-18 00:00:00.0 9.7506 237
75 612.2603 2022-08-19 00:00:00.0 8.8391 237
76 620.4287 2022-08-20 00:00:00.0 8.1684 237
77 627.5703 2022-08-21 00:00:00.0 7.1416 237
78 635.6571 2022-08-22 00:00:00.0 8.0868 237
79 644.7453 2022-08-23 00:00:00.0 9.0882 237
80 653.1637 2022-08-24 00:00:00.0 8.4184 237
81 660.3854 2022-08-25 00:00:00.0 7.2217 237
82 668.8968 2022-08-26 00:00:00.0 8.5114 237
83 676.9885 2022-08-27 00:00:00.0 8.0917 237
84 686.1294 2022-08-28 00:00:00.0 9.1409 237
85 695.4863 2022-08-29 00:00:00.0 9.3569 237
86 703.6106 2022-08-30 00:00:00.0 8.1243 237
87 710.8687 2022-08-31 00:00:00.0 7.2581 237
88 716.9695 2022-09-01 00:00:00.0 6.1008 237
89 725.6473 2022-09-02 00:00:00.0 8.6778 237
90 731.9215 2022-09-03 00:00:00.0 6.2742 237
91 738.8567 2022-09-04 00:00:00.0 6.9352 237
92 746.7245 2022-09-05 00:00:00.0 7.8678 237
93 755.4527 2022-09-06 00:00:00.0 8.7282 237
94 762.7463 2022-09-07 00:00:00.0 7.2936 237
95 771.5683 2022-09-08 00:00:00.0 8.8220 237
96 778.7547 2022-09-09 00:00:00.0 7.1864 237
97 783.9777 2022-09-10 00:00:00.0 5.2230 237
98 789.9277 2022-09-11 00:00:00.0 5.9500 237
99 796.4424 2022-09-12 00:00:00.0 6.5147 237
100 801.6872 2022-09-13 00:00:00.0 5.2448 237
101 807.4887 2022-09-14 00:00:00.0 5.8015 237
102 814.9620 2022-09-15 00:00:00.0 7.4733 237
103 820.7841 2022-09-16 00:00:00.0 5.8221 237
104 827.9616 2022-09-17 00:00:00.0 7.1775 237
105 835.9153 2022-09-18 00:00:00.0 7.9537 237
106 842.3687 2022-09-19 00:00:00.0 6.4534 237
107 850.2267 2022-09-20 00:00:00.0 7.8580 237
108 853.9662 2022-09-21 00:00:00.0 3.7395 237
109 856.2838 2022-09-22 00:00:00.0 2.3176 237
110 860.7407 2022-09-23 00:00:00.0 4.4569 237
111 868.5115 2022-09-24 00:00:00.0 7.7708 237
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '237') 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 869
9/23/2022 4 861
9/22/2022 2 856
9/21/2022 4 854
9/20/2022 8 850
9/19/2022 6 842
9/18/2022 8 836
9/17/2022 7 828
9/16/2022 6 821
9/15/2022 7 815
9/14/2022 6 807
9/13/2022 5 802
9/12/2022 7 796
9/11/2022 6 790
9/10/2022 5 784
9/9/2022 7 779
9/8/2022 9 772
9/7/2022 7 763
9/6/2022 9 755
9/5/2022 8 747
9/4/2022 7 739
9/3/2022 6 732
9/2/2022 9 726
9/1/2022 6 717
8/31/2022 7 711
8/30/2022 8 704
8/29/2022 9 695
8/28/2022 9 686
8/27/2022 8 677
8/26/2022 9 669
8/25/2022 7 660
8/24/2022 8 653
8/23/2022 9 645
8/22/2022 8 636
8/21/2022 7 628
8/20/2022 8 620
8/19/2022 9 612
8/18/2022 10 603
8/17/2022 8 594
8/16/2022 9 586
8/15/2022 9 577
8/14/2022 8 568
8/13/2022 8 560
8/12/2022 9 552
8/11/2022 6 543
8/10/2022 9 537
8/9/2022 9 529
8/8/2022 7 519
8/7/2022 6 512
8/6/2022 8 506
8/5/2022 8 498
8/4/2022 8 489
8/3/2022 9 481
8/2/2022 8 472
8/1/2022 9 465
7/31/2022 9 456
7/30/2022 7 447
7/29/2022 8 439
7/28/2022 9 431
7/27/2022 9 422
7/26/2022 9 413
7/25/2022 8 404
7/24/2022 8 396
7/23/2022 9 387
7/22/2022 9 378
7/21/2022 9 369
7/20/2022 9 360
7/19/2022 9 352
7/18/2022 7 342
7/17/2022 6 335
7/16/2022 9 329
7/15/2022 8 320
7/14/2022 9 312
7/13/2022 8 303
7/12/2022 9 295
7/11/2022 9 285
7/10/2022 9 276
7/9/2022 8 267
7/8/2022 8 260
7/7/2022 9 251
7/6/2022 9 242
7/5/2022 9 233
7/4/2022 10 224
7/3/2022 9 214
7/2/2022 8 206
7/1/2022 8 198
6/30/2022 9 190
6/29/2022 7 181
6/28/2022 8 174
6/27/2022 8 166
6/26/2022 8 158
6/25/2022 8 149
6/24/2022 9 141
6/23/2022 7 133
6/22/2022 8 125
6/21/2022 9 118
6/20/2022 8 109
6/19/2022 5 101
6/18/2022 8 96
6/17/2022 8 88
6/16/2022 9 79
6/15/2022 9 71
6/14/2022 9 62
6/13/2022 9 53
6/12/2022 9 44
6/11/2022 9 35
6/10/2022 5 26
6/9/2022 5 21
6/8/2022 5 16
6/7/2022 5 10