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.6635 2022-06-06 00:00:00.0 5.6635 524
2 12.1078 2022-06-07 00:00:00.0 6.4443 524
3 18.4105 2022-06-08 00:00:00.0 6.3027 524
4 25.3950 2022-06-09 00:00:00.0 6.9845 524
5 34.5676 2022-06-10 00:00:00.0 9.1726 524
6 43.5364 2022-06-11 00:00:00.0 8.9688 524
7 52.5216 2022-06-12 00:00:00.0 8.9852 524
8 60.3379 2022-06-13 00:00:00.0 7.8163 524
9 69.6064 2022-06-14 00:00:00.0 9.2685 524
10 78.2591 2022-06-15 00:00:00.0 8.6527 524
11 86.8803 2022-06-16 00:00:00.0 8.6212 524
12 94.8817 2022-06-17 00:00:00.0 8.0014 524
13 102.6069 2022-06-18 00:00:00.0 7.7252 524
14 106.4046 2022-06-19 00:00:00.0 3.7977 524
15 114.1840 2022-06-20 00:00:00.0 7.7794 524
16 123.2106 2022-06-21 00:00:00.0 9.0266 524
17 131.0418 2022-06-22 00:00:00.0 7.8312 524
18 137.9266 2022-06-23 00:00:00.0 6.8848 524
19 146.6813 2022-06-24 00:00:00.0 8.7547 524
20 154.5794 2022-06-25 00:00:00.0 7.8981 524
21 162.7364 2022-06-26 00:00:00.0 8.1570 524
22 170.6245 2022-06-27 00:00:00.0 7.8881 524
23 178.3704 2022-06-28 00:00:00.0 7.7459 524
24 185.7663 2022-06-29 00:00:00.0 7.3959 524
25 194.8209 2022-06-30 00:00:00.0 9.0546 524
26 202.7398 2022-07-01 00:00:00.0 7.9189 524
27 209.5892 2022-07-02 00:00:00.0 6.8494 524
28 217.8364 2022-07-03 00:00:00.0 8.2472 524
29 227.6222 2022-07-04 00:00:00.0 9.7858 524
30 236.6635 2022-07-05 00:00:00.0 9.0413 524
31 245.0558 2022-07-06 00:00:00.0 8.3923 524
32 254.3480 2022-07-07 00:00:00.0 9.2922 524
33 262.3574 2022-07-08 00:00:00.0 8.0094 524
34 269.8498 2022-07-09 00:00:00.0 7.4924 524
35 278.8979 2022-07-10 00:00:00.0 9.0481 524
36 287.9793 2022-07-11 00:00:00.0 9.0814 524
37 296.9740 2022-07-12 00:00:00.0 8.9947 524
38 305.2547 2022-07-13 00:00:00.0 8.2807 524
39 314.6537 2022-07-14 00:00:00.0 9.3990 524
40 322.9831 2022-07-15 00:00:00.0 8.3294 524
41 331.6816 2022-07-16 00:00:00.0 8.6985 524
42 337.5399 2022-07-17 00:00:00.0 5.8583 524
43 344.7479 2022-07-18 00:00:00.0 7.2080 524
44 354.1602 2022-07-19 00:00:00.0 9.4123 524
45 363.0092 2022-07-20 00:00:00.0 8.8490 524
46 371.7283 2022-07-21 00:00:00.0 8.7191 524
47 380.2397 2022-07-22 00:00:00.0 8.5114 524
48 389.3929 2022-07-23 00:00:00.0 9.1532 524
49 397.9762 2022-07-24 00:00:00.0 8.5833 524
50 405.7415 2022-07-25 00:00:00.0 7.7653 524
51 414.8526 2022-07-26 00:00:00.0 9.1111 524
52 423.1910 2022-07-27 00:00:00.0 8.3384 524
53 431.8263 2022-07-28 00:00:00.0 8.6353 524
54 440.0896 2022-07-29 00:00:00.0 8.2633 524
55 447.5710 2022-07-30 00:00:00.0 7.4814 524
56 456.8042 2022-07-31 00:00:00.0 9.2332 524
57 465.0441 2022-08-01 00:00:00.0 8.2399 524
58 473.1987 2022-08-02 00:00:00.0 8.1546 524
59 481.6044 2022-08-03 00:00:00.0 8.4057 524
60 489.6137 2022-08-04 00:00:00.0 8.0093 524
61 497.7369 2022-08-05 00:00:00.0 8.1232 524
62 505.8330 2022-08-06 00:00:00.0 8.0961 524
63 512.3115 2022-08-07 00:00:00.0 6.4785 524
64 519.6917 2022-08-08 00:00:00.0 7.3802 524
65 528.9852 2022-08-09 00:00:00.0 9.2935 524
66 537.1104 2022-08-10 00:00:00.0 8.1252 524
67 543.4187 2022-08-11 00:00:00.0 6.3083 524
68 552.4123 2022-08-12 00:00:00.0 8.9936 524
69 560.6493 2022-08-13 00:00:00.0 8.2370 524
70 568.5787 2022-08-14 00:00:00.0 7.9294 524
71 577.7341 2022-08-15 00:00:00.0 9.1554 524
72 586.5124 2022-08-16 00:00:00.0 8.7783 524
73 594.3070 2022-08-17 00:00:00.0 7.7946 524
74 604.0504 2022-08-18 00:00:00.0 9.7434 524
75 612.9326 2022-08-19 00:00:00.0 8.8822 524
76 620.8153 2022-08-20 00:00:00.0 7.8827 524
77 627.9356 2022-08-21 00:00:00.0 7.1203 524
78 635.5743 2022-08-22 00:00:00.0 7.6387 524
79 644.2302 2022-08-23 00:00:00.0 8.6559 524
80 652.2639 2022-08-24 00:00:00.0 8.0337 524
81 658.9081 2022-08-25 00:00:00.0 6.6442 524
82 667.5543 2022-08-26 00:00:00.0 8.6462 524
83 676.1300 2022-08-27 00:00:00.0 8.5757 524
84 685.0535 2022-08-28 00:00:00.0 8.9235 524
85 693.9584 2022-08-29 00:00:00.0 8.9049 524
86 701.8484 2022-08-30 00:00:00.0 7.8900 524
87 709.0153 2022-08-31 00:00:00.0 7.1669 524
88 716.1530 2022-09-01 00:00:00.0 7.1377 524
89 724.0000 2022-09-02 00:00:00.0 7.8470 524
90 730.1908 2022-09-03 00:00:00.0 6.1908 524
91 737.5006 2022-09-04 00:00:00.0 7.3098 524
92 745.6834 2022-09-05 00:00:00.0 8.1828 524
93 754.4682 2022-09-06 00:00:00.0 8.7848 524
94 761.0278 2022-09-07 00:00:00.0 6.5596 524
95 769.8029 2022-09-08 00:00:00.0 8.7751 524
96 776.1888 2022-09-09 00:00:00.0 6.3859 524
97 781.5889 2022-09-10 00:00:00.0 5.4001 524
98 787.2959 2022-09-11 00:00:00.0 5.7070 524
99 793.0711 2022-09-12 00:00:00.0 5.7752 524
100 798.2307 2022-09-13 00:00:00.0 5.1596 524
101 803.6446 2022-09-14 00:00:00.0 5.4139 524
102 810.9997 2022-09-15 00:00:00.0 7.3551 524
103 817.1047 2022-09-16 00:00:00.0 6.1050 524
104 824.5040 2022-09-17 00:00:00.0 7.3993 524
105 832.2535 2022-09-18 00:00:00.0 7.7495 524
106 839.5633 2022-09-19 00:00:00.0 7.3098 524
107 847.1243 2022-09-20 00:00:00.0 7.5610 524
108 851.0877 2022-09-21 00:00:00.0 3.9634 524
109 853.3520 2022-09-22 00:00:00.0 2.2643 524
110 858.2885 2022-09-23 00:00:00.0 4.9365 524
111 866.0840 2022-09-24 00:00:00.0 7.7955 524
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '524') 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 866
9/23/2022 5 858
9/22/2022 2 853
9/21/2022 4 851
9/20/2022 8 847
9/19/2022 7 840
9/18/2022 8 832
9/17/2022 7 825
9/16/2022 6 817
9/15/2022 7 811
9/14/2022 5 804
9/13/2022 5 798
9/12/2022 6 793
9/11/2022 6 787
9/10/2022 5 782
9/9/2022 6 776
9/8/2022 9 770
9/7/2022 7 761
9/6/2022 9 754
9/5/2022 8 746
9/4/2022 7 738
9/3/2022 6 730
9/2/2022 8 724
9/1/2022 7 716
8/31/2022 7 709
8/30/2022 8 702
8/29/2022 9 694
8/28/2022 9 685
8/27/2022 9 676
8/26/2022 9 668
8/25/2022 7 659
8/24/2022 8 652
8/23/2022 9 644
8/22/2022 8 636
8/21/2022 7 628
8/20/2022 8 621
8/19/2022 9 613
8/18/2022 10 604
8/17/2022 8 594
8/16/2022 9 587
8/15/2022 9 578
8/14/2022 8 569
8/13/2022 8 561
8/12/2022 9 552
8/11/2022 6 543
8/10/2022 8 537
8/9/2022 9 529
8/8/2022 7 520
8/7/2022 6 512
8/6/2022 8 506
8/5/2022 8 498
8/4/2022 8 490
8/3/2022 8 482
8/2/2022 8 473
8/1/2022 8 465
7/31/2022 9 457
7/30/2022 7 448
7/29/2022 8 440
7/28/2022 9 432
7/27/2022 8 423
7/26/2022 9 415
7/25/2022 8 406
7/24/2022 9 398
7/23/2022 9 389
7/22/2022 9 380
7/21/2022 9 372
7/20/2022 9 363
7/19/2022 9 354
7/18/2022 7 345
7/17/2022 6 338
7/16/2022 9 332
7/15/2022 8 323
7/14/2022 9 315
7/13/2022 8 305
7/12/2022 9 297
7/11/2022 9 288
7/10/2022 9 279
7/9/2022 7 270
7/8/2022 8 262
7/7/2022 9 254
7/6/2022 8 245
7/5/2022 9 237
7/4/2022 10 228
7/3/2022 8 218
7/2/2022 7 210
7/1/2022 8 203
6/30/2022 9 195
6/29/2022 7 186
6/28/2022 8 178
6/27/2022 8 171
6/26/2022 8 163
6/25/2022 8 155
6/24/2022 9 147
6/23/2022 7 138
6/22/2022 8 131
6/21/2022 9 123
6/20/2022 8 114
6/19/2022 4 106
6/18/2022 8 103
6/17/2022 8 95
6/16/2022 9 87
6/15/2022 9 78
6/14/2022 9 70
6/13/2022 8 60
6/12/2022 9 53
6/11/2022 9 44
6/10/2022 9 35
6/9/2022 7 25
6/8/2022 6 18
6/7/2022 6 12