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 6.0115 2022-06-06 00:00:00.0 6.0115 212
2 12.2980 2022-06-07 00:00:00.0 6.2865 212
3 19.4948 2022-06-08 00:00:00.0 7.1968 212
4 25.9682 2022-06-09 00:00:00.0 6.4734 212
5 35.2456 2022-06-10 00:00:00.0 9.2774 212
6 44.2511 2022-06-11 00:00:00.0 9.0055 212
7 53.6913 2022-06-12 00:00:00.0 9.4402 212
8 62.2499 2022-06-13 00:00:00.0 8.5586 212
9 71.5455 2022-06-14 00:00:00.0 9.2956 212
10 80.2858 2022-06-15 00:00:00.0 8.7403 212
11 89.0261 2022-06-16 00:00:00.0 8.7403 212
12 97.7899 2022-06-17 00:00:00.0 8.7638 212
13 105.8612 2022-06-18 00:00:00.0 8.0713 212
14 110.2336 2022-06-19 00:00:00.0 4.3724 212
15 118.0857 2022-06-20 00:00:00.0 7.8521 212
16 126.6556 2022-06-21 00:00:00.0 8.5699 212
17 134.2046 2022-06-22 00:00:00.0 7.5490 212
18 140.9057 2022-06-23 00:00:00.0 6.7011 212
19 149.7411 2022-06-24 00:00:00.0 8.8354 212
20 157.6193 2022-06-25 00:00:00.0 7.8782 212
21 165.8827 2022-06-26 00:00:00.0 8.2634 212
22 174.0228 2022-06-27 00:00:00.0 8.1401 212
23 182.2183 2022-06-28 00:00:00.0 8.1955 212
24 189.7001 2022-06-29 00:00:00.0 7.4818 212
25 198.4378 2022-06-30 00:00:00.0 8.7377 212
26 206.3824 2022-07-01 00:00:00.0 7.9446 212
27 213.7423 2022-07-02 00:00:00.0 7.3599 212
28 222.4797 2022-07-03 00:00:00.0 8.7374 212
29 232.2110 2022-07-04 00:00:00.0 9.7313 212
30 241.6835 2022-07-05 00:00:00.0 9.4725 212
31 250.2721 2022-07-06 00:00:00.0 8.5886 212
32 259.5874 2022-07-07 00:00:00.0 9.3153 212
33 267.9210 2022-07-08 00:00:00.0 8.3336 212
34 275.6201 2022-07-09 00:00:00.0 7.6991 212
35 284.5228 2022-07-10 00:00:00.0 8.9027 212
36 293.7289 2022-07-11 00:00:00.0 9.2061 212
37 302.8863 2022-07-12 00:00:00.0 9.1574 212
38 311.0323 2022-07-13 00:00:00.0 8.1460 212
39 320.3828 2022-07-14 00:00:00.0 9.3505 212
40 328.6455 2022-07-15 00:00:00.0 8.2627 212
41 337.4002 2022-07-16 00:00:00.0 8.7547 212
42 343.2858 2022-07-17 00:00:00.0 5.8856 212
43 350.9638 2022-07-18 00:00:00.0 7.6780 212
44 360.3645 2022-07-19 00:00:00.0 9.4007 212
45 369.3033 2022-07-20 00:00:00.0 8.9388 212
46 377.9022 2022-07-21 00:00:00.0 8.5989 212
47 386.4491 2022-07-22 00:00:00.0 8.5469 212
48 395.7431 2022-07-23 00:00:00.0 9.2940 212
49 403.6228 2022-07-24 00:00:00.0 7.8797 212
50 410.7548 2022-07-25 00:00:00.0 7.1320 212
51 419.8493 2022-07-26 00:00:00.0 9.0945 212
52 428.4477 2022-07-27 00:00:00.0 8.5984 212
53 437.3512 2022-07-28 00:00:00.0 8.9035 212
54 445.0851 2022-07-29 00:00:00.0 7.7339 212
55 452.3062 2022-07-30 00:00:00.0 7.2211 212
56 461.3224 2022-07-31 00:00:00.0 9.0162 212
57 469.3171 2022-08-01 00:00:00.0 7.9947 212
58 477.1603 2022-08-02 00:00:00.0 7.8432 212
59 485.9165 2022-08-03 00:00:00.0 8.7562 212
60 493.8260 2022-08-04 00:00:00.0 7.9095 212
61 502.3733 2022-08-05 00:00:00.0 8.5473 212
62 509.4299 2022-08-06 00:00:00.0 7.0566 212
63 515.3601 2022-08-07 00:00:00.0 5.9302 212
64 522.7988 2022-08-08 00:00:00.0 7.4387 212
65 531.5304 2022-08-09 00:00:00.0 8.7316 212
66 539.6934 2022-08-10 00:00:00.0 8.1630 212
67 546.1590 2022-08-11 00:00:00.0 6.4656 212
68 555.1407 2022-08-12 00:00:00.0 8.9817 212
69 562.9217 2022-08-13 00:00:00.0 7.7810 212
70 570.3556 2022-08-14 00:00:00.0 7.4339 212
71 579.5366 2022-08-15 00:00:00.0 9.1810 212
72 588.0256 2022-08-16 00:00:00.0 8.4890 212
73 595.6908 2022-08-17 00:00:00.0 7.6652 212
74 605.4387 2022-08-18 00:00:00.0 9.7479 212
75 614.7443 2022-08-19 00:00:00.0 9.3056 212
76 623.1604 2022-08-20 00:00:00.0 8.4161 212
77 629.9271 2022-08-21 00:00:00.0 6.7667 212
78 637.9653 2022-08-22 00:00:00.0 8.0382 212
79 646.7782 2022-08-23 00:00:00.0 8.8129 212
80 655.4202 2022-08-24 00:00:00.0 8.6420 212
81 662.6854 2022-08-25 00:00:00.0 7.2652 212
82 671.0423 2022-08-26 00:00:00.0 8.3569 212
83 679.1587 2022-08-27 00:00:00.0 8.1164 212
84 687.9838 2022-08-28 00:00:00.0 8.8251 212
85 697.2071 2022-08-29 00:00:00.0 9.2233 212
86 705.1115 2022-08-30 00:00:00.0 7.9044 212
87 712.4632 2022-08-31 00:00:00.0 7.3517 212
88 719.4232 2022-09-01 00:00:00.0 6.9600 212
89 727.1369 2022-09-02 00:00:00.0 7.7137 212
90 733.3884 2022-09-03 00:00:00.0 6.2515 212
91 740.0463 2022-09-04 00:00:00.0 6.6579 212
92 748.0904 2022-09-05 00:00:00.0 8.0441 212
93 755.9512 2022-09-06 00:00:00.0 7.8608 212
94 762.1797 2022-09-07 00:00:00.0 6.2285 212
95 770.4611 2022-09-08 00:00:00.0 8.2814 212
96 777.1536 2022-09-09 00:00:00.0 6.6925 212
97 781.9479 2022-09-10 00:00:00.0 4.7943 212
98 787.3569 2022-09-11 00:00:00.0 5.4090 212
99 793.6093 2022-09-12 00:00:00.0 6.2524 212
100 798.9273 2022-09-13 00:00:00.0 5.3180 212
101 804.6824 2022-09-14 00:00:00.0 5.7551 212
102 811.7708 2022-09-15 00:00:00.0 7.0884 212
103 817.5563 2022-09-16 00:00:00.0 5.7855 212
104 824.7805 2022-09-17 00:00:00.0 7.2242 212
105 831.9982 2022-09-18 00:00:00.0 7.2177 212
106 838.3031 2022-09-19 00:00:00.0 6.3049 212
107 845.9720 2022-09-20 00:00:00.0 7.6689 212
108 849.7548 2022-09-21 00:00:00.0 3.7828 212
109 852.3082 2022-09-22 00:00:00.0 2.5534 212
110 857.2109 2022-09-23 00:00:00.0 4.9027 212
111 864.8905 2022-09-24 00:00:00.0 7.6796 212
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '212') 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 865
9/23/2022 5 857
9/22/2022 3 852
9/21/2022 4 850
9/20/2022 8 846
9/19/2022 6 838
9/18/2022 7 832
9/17/2022 7 825
9/16/2022 6 818
9/15/2022 7 812
9/14/2022 6 805
9/13/2022 5 799
9/12/2022 6 794
9/11/2022 5 787
9/10/2022 5 782
9/9/2022 7 777
9/8/2022 8 770
9/7/2022 6 762
9/6/2022 8 756
9/5/2022 8 748
9/4/2022 7 740
9/3/2022 6 733
9/2/2022 8 727
9/1/2022 7 719
8/31/2022 7 712
8/30/2022 8 705
8/29/2022 9 697
8/28/2022 9 688
8/27/2022 8 679
8/26/2022 8 671
8/25/2022 7 663
8/24/2022 9 655
8/23/2022 9 647
8/22/2022 8 638
8/21/2022 7 630
8/20/2022 8 623
8/19/2022 9 615
8/18/2022 10 605
8/17/2022 8 596
8/16/2022 8 588
8/15/2022 9 580
8/14/2022 7 570
8/13/2022 8 563
8/12/2022 9 555
8/11/2022 6 546
8/10/2022 8 540
8/9/2022 9 532
8/8/2022 7 523
8/7/2022 6 515
8/6/2022 7 509
8/5/2022 9 502
8/4/2022 8 494
8/3/2022 9 486
8/2/2022 8 477
8/1/2022 8 469
7/31/2022 9 461
7/30/2022 7 452
7/29/2022 8 445
7/28/2022 9 437
7/27/2022 9 428
7/26/2022 9 420
7/25/2022 7 411
7/24/2022 8 404
7/23/2022 9 396
7/22/2022 9 386
7/21/2022 9 378
7/20/2022 9 369
7/19/2022 9 360
7/18/2022 8 351
7/17/2022 6 343
7/16/2022 9 337
7/15/2022 8 329
7/14/2022 9 320
7/13/2022 8 311
7/12/2022 9 303
7/11/2022 9 294
7/10/2022 9 285
7/9/2022 8 276
7/8/2022 8 268
7/7/2022 9 260
7/6/2022 9 250
7/5/2022 9 242
7/4/2022 10 232
7/3/2022 9 222
7/2/2022 7 214
7/1/2022 8 206
6/30/2022 9 198
6/29/2022 7 190
6/28/2022 8 182
6/27/2022 8 174
6/26/2022 8 166
6/25/2022 8 158
6/24/2022 9 150
6/23/2022 7 141
6/22/2022 8 134
6/21/2022 9 127
6/20/2022 8 118
6/19/2022 4 110
6/18/2022 8 106
6/17/2022 9 98
6/16/2022 9 89
6/15/2022 9 80
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 6 26
6/8/2022 7 19
6/7/2022 6 12