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.8004 2022-06-06 00:00:00.0 4.8004 233
2 11.3000 2022-06-07 00:00:00.0 6.4996 233
3 19.0120 2022-06-08 00:00:00.0 7.7120 233
4 26.2088 2022-06-09 00:00:00.0 7.1968 233
5 34.7020 2022-06-10 00:00:00.0 8.4932 233
6 42.9917 2022-06-11 00:00:00.0 8.2897 233
7 51.9832 2022-06-12 00:00:00.0 8.9915 233
8 60.0865 2022-06-13 00:00:00.0 8.1033 233
9 68.0611 2022-06-14 00:00:00.0 7.9746 233
10 74.2756 2022-06-15 00:00:00.0 6.2145 233
11 81.9870 2022-06-16 00:00:00.0 7.7114 233
12 90.3259 2022-06-17 00:00:00.0 8.3389 233
13 97.9050 2022-06-18 00:00:00.0 7.5791 233
14 104.0759 2022-06-19 00:00:00.0 6.1709 233
15 113.7450 2022-06-20 00:00:00.0 9.6691 233
16 122.7132 2022-06-21 00:00:00.0 8.9682 233
17 131.0874 2022-06-22 00:00:00.0 8.3742 233
18 138.9648 2022-06-23 00:00:00.0 7.8774 233
19 148.0902 2022-06-24 00:00:00.0 9.1254 233
20 154.4980 2022-06-25 00:00:00.0 6.4078 233
21 161.9485 2022-06-26 00:00:00.0 7.4505 233
22 170.1973 2022-06-27 00:00:00.0 8.2488 233
23 178.0870 2022-06-28 00:00:00.0 7.8897 233
24 186.0521 2022-06-29 00:00:00.0 7.9651 233
25 193.9718 2022-06-30 00:00:00.0 7.9197 233
26 200.7895 2022-07-01 00:00:00.0 6.8177 233
27 208.0702 2022-07-02 00:00:00.0 7.2807 233
28 216.3921 2022-07-03 00:00:00.0 8.3219 233
29 225.2214 2022-07-04 00:00:00.0 8.8293 233
30 234.2269 2022-07-05 00:00:00.0 9.0055 233
31 243.3174 2022-07-06 00:00:00.0 9.0905 233
32 251.8803 2022-07-07 00:00:00.0 8.5629 233
33 260.3690 2022-07-08 00:00:00.0 8.4887 233
34 269.1627 2022-07-09 00:00:00.0 8.7937 233
35 278.3719 2022-07-10 00:00:00.0 9.2092 233
36 287.6576 2022-07-11 00:00:00.0 9.2857 233
37 296.6844 2022-07-12 00:00:00.0 9.0268 233
38 305.4480 2022-07-13 00:00:00.0 8.7636 233
39 314.5017 2022-07-14 00:00:00.0 9.0537 233
40 323.0283 2022-07-15 00:00:00.0 8.5266 233
41 331.6406 2022-07-16 00:00:00.0 8.6123 233
42 338.6805 2022-07-17 00:00:00.0 7.0399 233
43 347.9133 2022-07-18 00:00:00.0 9.2328 233
44 357.5877 2022-07-19 00:00:00.0 9.6744 233
45 366.7776 2022-07-20 00:00:00.0 9.1899 233
46 375.4274 2022-07-21 00:00:00.0 8.6498 233
47 384.1325 2022-07-22 00:00:00.0 8.7051 233
48 392.8152 2022-07-23 00:00:00.0 8.6827 233
49 400.2897 2022-07-24 00:00:00.0 7.4745 233
50 408.5044 2022-07-25 00:00:00.0 8.2147 233
51 417.0174 2022-07-26 00:00:00.0 8.5130 233
52 424.5506 2022-07-27 00:00:00.0 7.5332 233
53 432.2393 2022-07-28 00:00:00.0 7.6887 233
54 440.4483 2022-07-29 00:00:00.0 8.2090 233
55 448.1047 2022-07-30 00:00:00.0 7.6564 233
56 457.2878 2022-07-31 00:00:00.0 9.1831 233
57 466.1654 2022-08-01 00:00:00.0 8.8776 233
58 474.7054 2022-08-02 00:00:00.0 8.5400 233
59 483.4889 2022-08-03 00:00:00.0 8.7835 233
60 491.5815 2022-08-04 00:00:00.0 8.0926 233
61 500.8200 2022-08-05 00:00:00.0 9.2385 233
62 507.5921 2022-08-06 00:00:00.0 6.7721 233
63 514.2014 2022-08-07 00:00:00.0 6.6093 233
64 522.0702 2022-08-08 00:00:00.0 7.8688 233
65 531.0637 2022-08-09 00:00:00.0 8.9935 233
66 539.3232 2022-08-10 00:00:00.0 8.2595 233
67 546.6851 2022-08-11 00:00:00.0 7.3619 233
68 555.9759 2022-08-12 00:00:00.0 9.2908 233
69 564.9650 2022-08-13 00:00:00.0 8.9891 233
70 573.6510 2022-08-14 00:00:00.0 8.6860 233
71 583.0454 2022-08-15 00:00:00.0 9.3944 233
72 591.5174 2022-08-16 00:00:00.0 8.4720 233
73 600.6371 2022-08-17 00:00:00.0 9.1197 233
74 609.9608 2022-08-18 00:00:00.0 9.3237 233
75 619.2183 2022-08-19 00:00:00.0 9.2575 233
76 627.2356 2022-08-20 00:00:00.0 8.0173 233
77 634.8942 2022-08-21 00:00:00.0 7.6586 233
78 644.2913 2022-08-22 00:00:00.0 9.3971 233
79 653.5813 2022-08-23 00:00:00.0 9.2900 233
80 661.3461 2022-08-24 00:00:00.0 7.7648 233
81 668.4448 2022-08-25 00:00:00.0 7.0987 233
82 676.8465 2022-08-26 00:00:00.0 8.4017 233
83 684.6254 2022-08-27 00:00:00.0 7.7789 233
84 693.3291 2022-08-28 00:00:00.0 8.7037 233
85 701.4818 2022-08-29 00:00:00.0 8.1527 233
86 709.2607 2022-08-30 00:00:00.0 7.7789 233
87 717.0553 2022-08-31 00:00:00.0 7.7946 233
88 724.5327 2022-09-01 00:00:00.0 7.4774 233
89 732.0694 2022-09-02 00:00:00.0 7.5367 233
90 739.3299 2022-09-03 00:00:00.0 7.2605 233
91 746.9182 2022-09-04 00:00:00.0 7.5883 233
92 755.4091 2022-09-05 00:00:00.0 8.4909 233
93 763.2306 2022-09-06 00:00:00.0 7.8215 233
94 770.3110 2022-09-07 00:00:00.0 7.0804 233
95 777.4608 2022-09-08 00:00:00.0 7.1498 233
96 781.6287 2022-09-09 00:00:00.0 4.1679 233
97 785.7581 2022-09-10 00:00:00.0 4.1294 233
98 791.6201 2022-09-11 00:00:00.0 5.8620 233
99 798.7517 2022-09-12 00:00:00.0 7.1316 233
100 802.9455 2022-09-13 00:00:00.0 4.1938 233
101 808.0127 2022-09-14 00:00:00.0 5.0672 233
102 814.2331 2022-09-15 00:00:00.0 6.2204 233
103 818.4710 2022-09-16 00:00:00.0 4.2379 233
104 823.7706 2022-09-17 00:00:00.0 5.2996 233
105 830.6277 2022-09-18 00:00:00.0 6.8571 233
106 835.2442 2022-09-19 00:00:00.0 4.6165 233
107 840.1789 2022-09-20 00:00:00.0 4.9347 233
108 841.8525 2022-09-21 00:00:00.0 1.6736 233
109 844.2179 2022-09-22 00:00:00.0 2.3654 233
110 847.2065 2022-09-23 00:00:00.0 2.9886 233
111 852.9825 2022-09-24 00:00:00.0 5.7760 233
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '233') 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 6 853
9/23/2022 3 847
9/22/2022 2 844
9/21/2022 2 842
9/20/2022 5 840
9/19/2022 5 835
9/18/2022 7 831
9/17/2022 5 824
9/16/2022 4 818
9/15/2022 6 814
9/14/2022 5 808
9/13/2022 4 803
9/12/2022 7 799
9/11/2022 6 792
9/10/2022 4 786
9/9/2022 4 782
9/8/2022 7 777
9/7/2022 7 770
9/6/2022 8 763
9/5/2022 8 755
9/4/2022 8 747
9/3/2022 7 739
9/2/2022 8 732
9/1/2022 7 725
8/31/2022 8 717
8/30/2022 8 709
8/29/2022 8 701
8/28/2022 9 693
8/27/2022 8 685
8/26/2022 8 677
8/25/2022 7 668
8/24/2022 8 661
8/23/2022 9 654
8/22/2022 9 644
8/21/2022 8 635
8/20/2022 8 627
8/19/2022 9 619
8/18/2022 9 610
8/17/2022 9 601
8/16/2022 8 592
8/15/2022 9 583
8/14/2022 9 574
8/13/2022 9 565
8/12/2022 9 556
8/11/2022 7 547
8/10/2022 8 539
8/9/2022 9 531
8/8/2022 8 522
8/7/2022 7 514
8/6/2022 7 508
8/5/2022 9 501
8/4/2022 8 492
8/3/2022 9 483
8/2/2022 9 475
8/1/2022 9 466
7/31/2022 9 457
7/30/2022 8 448
7/29/2022 8 440
7/28/2022 8 432
7/27/2022 8 425
7/26/2022 9 417
7/25/2022 8 409
7/24/2022 7 400
7/23/2022 9 393
7/22/2022 9 384
7/21/2022 9 375
7/20/2022 9 367
7/19/2022 10 358
7/18/2022 9 348
7/17/2022 7 339
7/16/2022 9 332
7/15/2022 9 323
7/14/2022 9 315
7/13/2022 9 305
7/12/2022 9 297
7/11/2022 9 288
7/10/2022 9 278
7/9/2022 9 269
7/8/2022 8 260
7/7/2022 9 252
7/6/2022 9 243
7/5/2022 9 234
7/4/2022 9 225
7/3/2022 8 216
7/2/2022 7 208
7/1/2022 7 201
6/30/2022 8 194
6/29/2022 8 186
6/28/2022 8 178
6/27/2022 8 170
6/26/2022 7 162
6/25/2022 6 154
6/24/2022 9 148
6/23/2022 8 139
6/22/2022 8 131
6/21/2022 9 123
6/20/2022 10 114
6/19/2022 6 104
6/18/2022 8 98
6/17/2022 8 90
6/16/2022 8 82
6/15/2022 6 74
6/14/2022 8 68
6/13/2022 8 60
6/12/2022 9 52
6/11/2022 8 43
6/10/2022 8 35
6/9/2022 7 26
6/8/2022 8 19
6/7/2022 6 11