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.2313 2022-06-06 00:00:00.0 5.2313 534
2 11.3437 2022-06-07 00:00:00.0 6.1124 534
3 17.8150 2022-06-08 00:00:00.0 6.4713 534
4 24.2731 2022-06-09 00:00:00.0 6.4581 534
5 33.3676 2022-06-10 00:00:00.0 9.0945 534
6 42.2399 2022-06-11 00:00:00.0 8.8723 534
7 51.4534 2022-06-12 00:00:00.0 9.2135 534
8 60.0980 2022-06-13 00:00:00.0 8.6446 534
9 69.4915 2022-06-14 00:00:00.0 9.3935 534
10 78.2389 2022-06-15 00:00:00.0 8.7474 534
11 86.7882 2022-06-16 00:00:00.0 8.5493 534
12 95.7064 2022-06-17 00:00:00.0 8.9182 534
13 104.4315 2022-06-18 00:00:00.0 8.7251 534
14 109.1231 2022-06-19 00:00:00.0 4.6916 534
15 117.8246 2022-06-20 00:00:00.0 8.7015 534
16 126.6757 2022-06-21 00:00:00.0 8.8511 534
17 134.9088 2022-06-22 00:00:00.0 8.2331 534
18 142.4492 2022-06-23 00:00:00.0 7.5404 534
19 152.0947 2022-06-24 00:00:00.0 9.6455 534
20 159.4500 2022-06-25 00:00:00.0 7.3553 534
21 167.5842 2022-06-26 00:00:00.0 8.1342 534
22 176.1951 2022-06-27 00:00:00.0 8.6109 534
23 184.6513 2022-06-28 00:00:00.0 8.4562 534
24 192.6844 2022-06-29 00:00:00.0 8.0331 534
25 201.8714 2022-06-30 00:00:00.0 9.1870 534
26 209.8079 2022-07-01 00:00:00.0 7.9365 534
27 218.1831 2022-07-02 00:00:00.0 8.3752 534
28 226.9697 2022-07-03 00:00:00.0 8.7866 534
29 236.3543 2022-07-04 00:00:00.0 9.3846 534
30 245.7878 2022-07-05 00:00:00.0 9.4335 534
31 254.5562 2022-07-06 00:00:00.0 8.7684 534
32 263.7829 2022-07-07 00:00:00.0 9.2267 534
33 272.3070 2022-07-08 00:00:00.0 8.5241 534
34 280.2643 2022-07-09 00:00:00.0 7.9573 534
35 289.2443 2022-07-10 00:00:00.0 8.9800 534
36 298.5317 2022-07-11 00:00:00.0 9.2874 534
37 307.9110 2022-07-12 00:00:00.0 9.3793 534
38 316.5102 2022-07-13 00:00:00.0 8.5992 534
39 325.8761 2022-07-14 00:00:00.0 9.3659 534
40 333.8808 2022-07-15 00:00:00.0 8.0047 534
41 341.5588 2022-07-16 00:00:00.0 7.6780 534
42 346.5869 2022-07-17 00:00:00.0 5.0281 534
43 354.6097 2022-07-18 00:00:00.0 8.0228 534
44 364.1070 2022-07-19 00:00:00.0 9.4973 534
45 373.1854 2022-07-20 00:00:00.0 9.0784 534
46 382.1738 2022-07-21 00:00:00.0 8.9884 534
47 391.1922 2022-07-22 00:00:00.0 9.0184 534
48 400.5929 2022-07-23 00:00:00.0 9.4007 534
49 409.4552 2022-07-24 00:00:00.0 8.8623 534
50 417.8503 2022-07-25 00:00:00.0 8.3951 534
51 426.7681 2022-07-26 00:00:00.0 8.9178 534
52 435.1426 2022-07-27 00:00:00.0 8.3745 534
53 443.8251 2022-07-28 00:00:00.0 8.6825 534
54 452.1675 2022-07-29 00:00:00.0 8.3424 534
55 459.5736 2022-07-30 00:00:00.0 7.4061 534
56 468.7481 2022-07-31 00:00:00.0 9.1745 534
57 477.5518 2022-08-01 00:00:00.0 8.8037 534
58 485.4778 2022-08-02 00:00:00.0 7.9260 534
59 494.3781 2022-08-03 00:00:00.0 8.9003 534
60 502.2352 2022-08-04 00:00:00.0 7.8571 534
61 510.6753 2022-08-05 00:00:00.0 8.4401 534
62 518.4516 2022-08-06 00:00:00.0 7.7763 534
63 525.3588 2022-08-07 00:00:00.0 6.9072 534
64 532.8427 2022-08-08 00:00:00.0 7.4839 534
65 542.1489 2022-08-09 00:00:00.0 9.3062 534
66 550.3266 2022-08-10 00:00:00.0 8.1777 534
67 557.1639 2022-08-11 00:00:00.0 6.8373 534
68 566.5421 2022-08-12 00:00:00.0 9.3782 534
69 574.8531 2022-08-13 00:00:00.0 8.3110 534
70 583.0962 2022-08-14 00:00:00.0 8.2431 534
71 592.6774 2022-08-15 00:00:00.0 9.5812 534
72 601.0103 2022-08-16 00:00:00.0 8.3329 534
73 609.1079 2022-08-17 00:00:00.0 8.0976 534
74 618.7939 2022-08-18 00:00:00.0 9.6860 534
75 627.9113 2022-08-19 00:00:00.0 9.1174 534
76 635.7550 2022-08-20 00:00:00.0 7.8437 534
77 643.0268 2022-08-21 00:00:00.0 7.2718 534
78 652.3174 2022-08-22 00:00:00.0 9.2906 534
79 661.6419 2022-08-23 00:00:00.0 9.3245 534
80 669.2727 2022-08-24 00:00:00.0 7.6308 534
81 675.7770 2022-08-25 00:00:00.0 6.5043 534
82 684.7063 2022-08-26 00:00:00.0 8.9293 534
83 692.7503 2022-08-27 00:00:00.0 8.0440 534
84 702.0603 2022-08-28 00:00:00.0 9.3100 534
85 711.3319 2022-08-29 00:00:00.0 9.2716 534
86 719.7476 2022-08-30 00:00:00.0 8.4157 534
87 727.0742 2022-08-31 00:00:00.0 7.3266 534
88 734.4013 2022-09-01 00:00:00.0 7.3271 534
89 742.5491 2022-09-02 00:00:00.0 8.1478 534
90 748.9895 2022-09-03 00:00:00.0 6.4404 534
91 756.4562 2022-09-04 00:00:00.0 7.4667 534
92 764.7396 2022-09-05 00:00:00.0 8.2834 534
93 773.1235 2022-09-06 00:00:00.0 8.3839 534
94 779.5010 2022-09-07 00:00:00.0 6.3775 534
95 787.7832 2022-09-08 00:00:00.0 8.2822 534
96 793.5592 2022-09-09 00:00:00.0 5.7760 534
97 798.6535 2022-09-10 00:00:00.0 5.0943 534
98 804.8740 2022-09-11 00:00:00.0 6.2205 534
99 811.7198 2022-09-12 00:00:00.0 6.8458 534
100 815.4290 2022-09-13 00:00:00.0 3.7092 534
101 822.1328 2022-09-14 00:00:00.0 6.7038 534
102 829.3757 2022-09-15 00:00:00.0 7.2429 534
103 834.4841 2022-09-16 00:00:00.0 5.1084 534
104 841.2072 2022-09-17 00:00:00.0 6.7231 534
105 848.6727 2022-09-18 00:00:00.0 7.4655 534
106 854.5687 2022-09-19 00:00:00.0 5.8960 534
107 861.6796 2022-09-20 00:00:00.0 7.1109 534
108 864.2992 2022-09-21 00:00:00.0 2.6196 534
109 866.9040 2022-09-22 00:00:00.0 2.6048 534
110 871.2209 2022-09-23 00:00:00.0 4.3169 534
111 878.8572 2022-09-24 00:00:00.0 7.6363 534
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '534') 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 879
9/23/2022 4 871
9/22/2022 3 867
9/21/2022 3 864
9/20/2022 7 862
9/19/2022 6 855
9/18/2022 7 849
9/17/2022 7 841
9/16/2022 5 834
9/15/2022 7 829
9/14/2022 7 822
9/13/2022 4 815
9/12/2022 7 812
9/11/2022 6 805
9/10/2022 5 799
9/9/2022 6 794
9/8/2022 8 788
9/7/2022 6 780
9/6/2022 8 773
9/5/2022 8 765
9/4/2022 7 756
9/3/2022 6 749
9/2/2022 8 743
9/1/2022 7 734
8/31/2022 7 727
8/30/2022 8 720
8/29/2022 9 711
8/28/2022 9 702
8/27/2022 8 693
8/26/2022 9 685
8/25/2022 7 676
8/24/2022 8 669
8/23/2022 9 662
8/22/2022 9 652
8/21/2022 7 643
8/20/2022 8 636
8/19/2022 9 628
8/18/2022 10 619
8/17/2022 8 609
8/16/2022 8 601
8/15/2022 10 593
8/14/2022 8 583
8/13/2022 8 575
8/12/2022 9 567
8/11/2022 7 557
8/10/2022 8 550
8/9/2022 9 542
8/8/2022 7 533
8/7/2022 7 525
8/6/2022 8 518
8/5/2022 8 511
8/4/2022 8 502
8/3/2022 9 494
8/2/2022 8 485
8/1/2022 9 478
7/31/2022 9 469
7/30/2022 7 460
7/29/2022 8 452
7/28/2022 9 444
7/27/2022 8 435
7/26/2022 9 427
7/25/2022 8 418
7/24/2022 9 409
7/23/2022 9 401
7/22/2022 9 391
7/21/2022 9 382
7/20/2022 9 373
7/19/2022 9 364
7/18/2022 8 355
7/17/2022 5 347
7/16/2022 8 342
7/15/2022 8 334
7/14/2022 9 326
7/13/2022 9 317
7/12/2022 9 308
7/11/2022 9 299
7/10/2022 9 289
7/9/2022 8 280
7/8/2022 9 272
7/7/2022 9 264
7/6/2022 9 255
7/5/2022 9 246
7/4/2022 9 236
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 9 176
6/26/2022 8 168
6/25/2022 7 159
6/24/2022 10 152
6/23/2022 8 142
6/22/2022 8 135
6/21/2022 9 127
6/20/2022 9 118
6/19/2022 5 109
6/18/2022 9 104
6/17/2022 9 96
6/16/2022 9 87
6/15/2022 9 78
6/14/2022 9 69
6/13/2022 9 60
6/12/2022 9 51
6/11/2022 9 42
6/10/2022 9 33
6/9/2022 6 24
6/8/2022 6 18
6/7/2022 6 11