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.5012 2022-06-06 00:00:00.0 4.5012 558
2 10.1870 2022-06-07 00:00:00.0 5.6858 558
3 17.9206 2022-06-08 00:00:00.0 7.7336 558
4 24.6800 2022-06-09 00:00:00.0 6.7594 558
5 33.0370 2022-06-10 00:00:00.0 8.3570 558
6 41.3614 2022-06-11 00:00:00.0 8.3244 558
7 50.5711 2022-06-12 00:00:00.0 9.2097 558
8 59.4603 2022-06-13 00:00:00.0 8.8892 558
9 67.7137 2022-06-14 00:00:00.0 8.2534 558
10 74.4208 2022-06-15 00:00:00.0 6.7071 558
11 81.9892 2022-06-16 00:00:00.0 7.5684 558
12 90.3820 2022-06-17 00:00:00.0 8.3928 558
13 97.0243 2022-06-18 00:00:00.0 6.6423 558
14 101.5775 2022-06-19 00:00:00.0 4.5532 558
15 111.0717 2022-06-20 00:00:00.0 9.4942 558
16 120.3301 2022-06-21 00:00:00.0 9.2584 558
17 127.9896 2022-06-22 00:00:00.0 7.6595 558
18 135.5133 2022-06-23 00:00:00.0 7.5237 558
19 144.8232 2022-06-24 00:00:00.0 9.3099 558
20 151.8533 2022-06-25 00:00:00.0 7.0301 558
21 159.2601 2022-06-26 00:00:00.0 7.4068 558
22 167.2546 2022-06-27 00:00:00.0 7.9945 558
23 174.8356 2022-06-28 00:00:00.0 7.5810 558
24 182.6300 2022-06-29 00:00:00.0 7.7944 558
25 191.0158 2022-06-30 00:00:00.0 8.3858 558
26 197.4682 2022-07-01 00:00:00.0 6.4524 558
27 204.8718 2022-07-02 00:00:00.0 7.4036 558
28 213.2250 2022-07-03 00:00:00.0 8.3532 558
29 222.1344 2022-07-04 00:00:00.0 8.9094 558
30 231.3475 2022-07-05 00:00:00.0 9.2131 558
31 239.9427 2022-07-06 00:00:00.0 8.5952 558
32 248.6760 2022-07-07 00:00:00.0 8.7333 558
33 256.6630 2022-07-08 00:00:00.0 7.9870 558
34 264.9981 2022-07-09 00:00:00.0 8.3351 558
35 273.8362 2022-07-10 00:00:00.0 8.8381 558
36 283.0954 2022-07-11 00:00:00.0 9.2592 558
37 291.8346 2022-07-12 00:00:00.0 8.7392 558
38 300.3066 2022-07-13 00:00:00.0 8.4720 558
39 309.4770 2022-07-14 00:00:00.0 9.1704 558
40 317.7307 2022-07-15 00:00:00.0 8.2537 558
41 325.9470 2022-07-16 00:00:00.0 8.2163 558
42 332.3921 2022-07-17 00:00:00.0 6.4451 558
43 340.8282 2022-07-18 00:00:00.0 8.4361 558
44 350.3668 2022-07-19 00:00:00.0 9.5386 558
45 359.5083 2022-07-20 00:00:00.0 9.1415 558
46 368.2414 2022-07-21 00:00:00.0 8.7331 558
47 376.8962 2022-07-22 00:00:00.0 8.6548 558
48 385.6505 2022-07-23 00:00:00.0 8.7543 558
49 393.4126 2022-07-24 00:00:00.0 7.7621 558
50 400.9104 2022-07-25 00:00:00.0 7.4978 558
51 409.5953 2022-07-26 00:00:00.0 8.6849 558
52 417.5876 2022-07-27 00:00:00.0 7.9923 558
53 425.4224 2022-07-28 00:00:00.0 7.8348 558
54 433.1081 2022-07-29 00:00:00.0 7.6857 558
55 440.3870 2022-07-30 00:00:00.0 7.2789 558
56 449.3005 2022-07-31 00:00:00.0 8.9135 558
57 457.5727 2022-08-01 00:00:00.0 8.2722 558
58 465.1368 2022-08-02 00:00:00.0 7.5641 558
59 473.8962 2022-08-03 00:00:00.0 8.7594 558
60 481.4814 2022-08-04 00:00:00.0 7.5852 558
61 490.2042 2022-08-05 00:00:00.0 8.7228 558
62 497.7706 2022-08-06 00:00:00.0 7.5664 558
63 504.0235 2022-08-07 00:00:00.0 6.2529 558
64 511.4403 2022-08-08 00:00:00.0 7.4168 558
65 520.6241 2022-08-09 00:00:00.0 9.1838 558
66 527.5320 2022-08-10 00:00:00.0 6.9079 558
67 534.4499 2022-08-11 00:00:00.0 6.9179 558
68 543.5052 2022-08-12 00:00:00.0 9.0553 558
69 552.1490 2022-08-13 00:00:00.0 8.6438 558
70 559.9593 2022-08-14 00:00:00.0 7.8103 558
71 568.8227 2022-08-15 00:00:00.0 8.8634 558
72 576.8172 2022-08-16 00:00:00.0 7.9945 558
73 585.2538 2022-08-17 00:00:00.0 8.4366 558
74 594.5862 2022-08-18 00:00:00.0 9.3324 558
75 603.7267 2022-08-19 00:00:00.0 9.1405 558
76 611.3126 2022-08-20 00:00:00.0 7.5859 558
77 618.7293 2022-08-21 00:00:00.0 7.4167 558
78 627.7691 2022-08-22 00:00:00.0 9.0398 558
79 636.7646 2022-08-23 00:00:00.0 8.9955 558
80 644.7601 2022-08-24 00:00:00.0 7.9955 558
81 651.6116 2022-08-25 00:00:00.0 6.8515 558
82 660.1926 2022-08-26 00:00:00.0 8.5810 558
83 667.6396 2022-08-27 00:00:00.0 7.4470 558
84 676.6461 2022-08-28 00:00:00.0 9.0065 558
85 685.5068 2022-08-29 00:00:00.0 8.8607 558
86 692.5904 2022-08-30 00:00:00.0 7.0836 558
87 699.6476 2022-08-31 00:00:00.0 7.0572 558
88 706.1567 2022-09-01 00:00:00.0 6.5091 558
89 714.3835 2022-09-02 00:00:00.0 8.2268 558
90 721.1809 2022-09-03 00:00:00.0 6.7974 558
91 729.2250 2022-09-04 00:00:00.0 8.0441 558
92 737.8338 2022-09-05 00:00:00.0 8.6088 558
93 746.2284 2022-09-06 00:00:00.0 8.3946 558
94 752.3282 2022-09-07 00:00:00.0 6.0998 558
95 759.8176 2022-09-08 00:00:00.0 7.4894 558
96 764.9206 2022-09-09 00:00:00.0 5.1030 558
97 770.0722 2022-09-10 00:00:00.0 5.1516 558
98 775.8211 2022-09-11 00:00:00.0 5.7489 558
99 781.8797 2022-09-12 00:00:00.0 6.0586 558
100 785.9332 2022-09-13 00:00:00.0 4.0535 558
101 791.3975 2022-09-14 00:00:00.0 5.4643 558
102 798.4491 2022-09-15 00:00:00.0 7.0516 558
103 803.5062 2022-09-16 00:00:00.0 5.0571 558
104 809.3206 2022-09-17 00:00:00.0 5.8144 558
105 816.5175 2022-09-18 00:00:00.0 7.1969 558
106 821.5839 2022-09-19 00:00:00.0 5.0664 558
107 827.4863 2022-09-20 00:00:00.0 5.9024 558
108 829.8607 2022-09-21 00:00:00.0 2.3744 558
109 832.5106 2022-09-22 00:00:00.0 2.6499 558
110 837.4131 2022-09-23 00:00:00.0 4.9025 558
111 843.9596 2022-09-24 00:00:00.0 6.5465 558
CACHED false
EXECUTIONTIME 15
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '558') 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 844
9/23/2022 5 837
9/22/2022 3 833
9/21/2022 2 830
9/20/2022 6 827
9/19/2022 5 822
9/18/2022 7 817
9/17/2022 6 809
9/16/2022 5 804
9/15/2022 7 798
9/14/2022 5 791
9/13/2022 4 786
9/12/2022 6 782
9/11/2022 6 776
9/10/2022 5 770
9/9/2022 5 765
9/8/2022 7 760
9/7/2022 6 752
9/6/2022 8 746
9/5/2022 9 738
9/4/2022 8 729
9/3/2022 7 721
9/2/2022 8 714
9/1/2022 7 706
8/31/2022 7 700
8/30/2022 7 693
8/29/2022 9 686
8/28/2022 9 677
8/27/2022 7 668
8/26/2022 9 660
8/25/2022 7 652
8/24/2022 8 645
8/23/2022 9 637
8/22/2022 9 628
8/21/2022 7 619
8/20/2022 8 611
8/19/2022 9 604
8/18/2022 9 595
8/17/2022 8 585
8/16/2022 8 577
8/15/2022 9 569
8/14/2022 8 560
8/13/2022 9 552
8/12/2022 9 544
8/11/2022 7 534
8/10/2022 7 528
8/9/2022 9 521
8/8/2022 7 511
8/7/2022 6 504
8/6/2022 8 498
8/5/2022 9 490
8/4/2022 8 481
8/3/2022 9 474
8/2/2022 8 465
8/1/2022 8 458
7/31/2022 9 449
7/30/2022 7 440
7/29/2022 8 433
7/28/2022 8 425
7/27/2022 8 418
7/26/2022 9 410
7/25/2022 7 401
7/24/2022 8 393
7/23/2022 9 386
7/22/2022 9 377
7/21/2022 9 368
7/20/2022 9 360
7/19/2022 10 350
7/18/2022 8 341
7/17/2022 6 332
7/16/2022 8 326
7/15/2022 8 318
7/14/2022 9 309
7/13/2022 8 300
7/12/2022 9 292
7/11/2022 9 283
7/10/2022 9 274
7/9/2022 8 265
7/8/2022 8 257
7/7/2022 9 249
7/6/2022 9 240
7/5/2022 9 231
7/4/2022 9 222
7/3/2022 8 213
7/2/2022 7 205
7/1/2022 6 197
6/30/2022 8 191
6/29/2022 8 183
6/28/2022 8 175
6/27/2022 8 167
6/26/2022 7 159
6/25/2022 7 152
6/24/2022 9 145
6/23/2022 8 136
6/22/2022 8 128
6/21/2022 9 120
6/20/2022 9 111
6/19/2022 5 102
6/18/2022 7 97
6/17/2022 8 90
6/16/2022 8 82
6/15/2022 7 74
6/14/2022 8 68
6/13/2022 9 59
6/12/2022 9 51
6/11/2022 8 41
6/10/2022 8 33
6/9/2022 7 25
6/8/2022 8 18
6/7/2022 6 10