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.3875 2022-06-06 00:00:00.0 5.3875 530
2 11.5796 2022-06-07 00:00:00.0 6.1921 530
3 17.6716 2022-06-08 00:00:00.0 6.0920 530
4 24.0195 2022-06-09 00:00:00.0 6.3479 530
5 32.3184 2022-06-10 00:00:00.0 8.2989 530
6 41.2778 2022-06-11 00:00:00.0 8.9594 530
7 50.3946 2022-06-12 00:00:00.0 9.1168 530
8 58.5635 2022-06-13 00:00:00.0 8.1689 530
9 67.7648 2022-06-14 00:00:00.0 9.2013 530
10 76.4160 2022-06-15 00:00:00.0 8.6512 530
11 84.8864 2022-06-16 00:00:00.0 8.4704 530
12 93.0275 2022-06-17 00:00:00.0 8.1411 530
13 101.0150 2022-06-18 00:00:00.0 7.9875 530
14 105.1411 2022-06-19 00:00:00.0 4.1261 530
15 112.7819 2022-06-20 00:00:00.0 7.6408 530
16 121.3439 2022-06-21 00:00:00.0 8.5620 530
17 128.3084 2022-06-22 00:00:00.0 6.9645 530
18 135.3420 2022-06-23 00:00:00.0 7.0336 530
19 144.1744 2022-06-24 00:00:00.0 8.8324 530
20 152.0941 2022-06-25 00:00:00.0 7.9197 530
21 160.0079 2022-06-26 00:00:00.0 7.9138 530
22 167.5947 2022-06-27 00:00:00.0 7.5868 530
23 175.4320 2022-06-28 00:00:00.0 7.8373 530
24 182.2691 2022-06-29 00:00:00.0 6.8371 530
25 190.4357 2022-06-30 00:00:00.0 8.1666 530
26 197.5144 2022-07-01 00:00:00.0 7.0787 530
27 205.2449 2022-07-02 00:00:00.0 7.7305 530
28 213.8497 2022-07-03 00:00:00.0 8.6048 530
29 223.5356 2022-07-04 00:00:00.0 9.6859 530
30 232.9260 2022-07-05 00:00:00.0 9.3904 530
31 241.6851 2022-07-06 00:00:00.0 8.7591 530
32 250.9757 2022-07-07 00:00:00.0 9.2906 530
33 259.5438 2022-07-08 00:00:00.0 8.5681 530
34 267.5388 2022-07-09 00:00:00.0 7.9950 530
35 276.6103 2022-07-10 00:00:00.0 9.0715 530
36 285.8419 2022-07-11 00:00:00.0 9.2316 530
37 294.9513 2022-07-12 00:00:00.0 9.1094 530
38 303.4492 2022-07-13 00:00:00.0 8.4979 530
39 312.8300 2022-07-14 00:00:00.0 9.3808 530
40 321.1398 2022-07-15 00:00:00.0 8.3098 530
41 330.3147 2022-07-16 00:00:00.0 9.1749 530
42 336.8652 2022-07-17 00:00:00.0 6.5505 530
43 344.5302 2022-07-18 00:00:00.0 7.6650 530
44 354.1168 2022-07-19 00:00:00.0 9.5866 530
45 362.9795 2022-07-20 00:00:00.0 8.8627 530
46 371.6580 2022-07-21 00:00:00.0 8.6785 530
47 380.6241 2022-07-22 00:00:00.0 8.9661 530
48 389.7736 2022-07-23 00:00:00.0 9.1495 530
49 397.1572 2022-07-24 00:00:00.0 7.3836 530
50 404.2439 2022-07-25 00:00:00.0 7.0867 530
51 413.3014 2022-07-26 00:00:00.0 9.0575 530
52 421.6091 2022-07-27 00:00:00.0 8.3077 530
53 430.1584 2022-07-28 00:00:00.0 8.5493 530
54 437.5837 2022-07-29 00:00:00.0 7.4253 530
55 445.5116 2022-07-30 00:00:00.0 7.9279 530
56 454.1490 2022-07-31 00:00:00.0 8.6374 530
57 462.2287 2022-08-01 00:00:00.0 8.0797 530
58 470.7932 2022-08-02 00:00:00.0 8.5645 530
59 479.0695 2022-08-03 00:00:00.0 8.2763 530
60 486.7651 2022-08-04 00:00:00.0 7.6956 530
61 495.3306 2022-08-05 00:00:00.0 8.5655 530
62 502.5058 2022-08-06 00:00:00.0 7.1752 530
63 508.0353 2022-08-07 00:00:00.0 5.5295 530
64 515.5980 2022-08-08 00:00:00.0 7.5627 530
65 524.6879 2022-08-09 00:00:00.0 9.0899 530
66 532.5025 2022-08-10 00:00:00.0 7.8146 530
67 538.9031 2022-08-11 00:00:00.0 6.4006 530
68 547.8968 2022-08-12 00:00:00.0 8.9937 530
69 556.0834 2022-08-13 00:00:00.0 8.1866 530
70 563.7832 2022-08-14 00:00:00.0 7.6998 530
71 572.8142 2022-08-15 00:00:00.0 9.0310 530
72 581.3334 2022-08-16 00:00:00.0 8.5192 530
73 588.9240 2022-08-17 00:00:00.0 7.5906 530
74 598.6672 2022-08-18 00:00:00.0 9.7432 530
75 607.7747 2022-08-19 00:00:00.0 9.1075 530
76 615.3881 2022-08-20 00:00:00.0 7.6134 530
77 622.5336 2022-08-21 00:00:00.0 7.1455 530
78 630.6539 2022-08-22 00:00:00.0 8.1203 530
79 639.6113 2022-08-23 00:00:00.0 8.9574 530
80 647.5712 2022-08-24 00:00:00.0 7.9599 530
81 653.8814 2022-08-25 00:00:00.0 6.3102 530
82 661.8780 2022-08-26 00:00:00.0 7.9966 530
83 670.3165 2022-08-27 00:00:00.0 8.4385 530
84 679.1475 2022-08-28 00:00:00.0 8.8310 530
85 687.7557 2022-08-29 00:00:00.0 8.6082 530
86 695.5561 2022-08-30 00:00:00.0 7.8004 530
87 702.6887 2022-08-31 00:00:00.0 7.1326 530
88 709.7021 2022-09-01 00:00:00.0 7.0134 530
89 717.5873 2022-09-02 00:00:00.0 7.8852 530
90 723.4688 2022-09-03 00:00:00.0 5.8815 530
91 730.1282 2022-09-04 00:00:00.0 6.6594 530
92 738.1685 2022-09-05 00:00:00.0 8.0403 530
93 746.0092 2022-09-06 00:00:00.0 7.8407 530
94 752.0014 2022-09-07 00:00:00.0 5.9922 530
95 759.9700 2022-09-08 00:00:00.0 7.9686 530
96 766.4712 2022-09-09 00:00:00.0 6.5012 530
97 771.3723 2022-09-10 00:00:00.0 4.9011 530
98 776.7603 2022-09-11 00:00:00.0 5.3880 530
99 782.6279 2022-09-12 00:00:00.0 5.8676 530
100 787.2951 2022-09-13 00:00:00.0 4.6672 530
101 793.2471 2022-09-14 00:00:00.0 5.9520 530
102 800.2408 2022-09-15 00:00:00.0 6.9937 530
103 806.1545 2022-09-16 00:00:00.0 5.9137 530
104 813.3832 2022-09-17 00:00:00.0 7.2287 530
105 820.5988 2022-09-18 00:00:00.0 7.2156 530
106 826.8932 2022-09-19 00:00:00.0 6.2944 530
107 833.9959 2022-09-20 00:00:00.0 7.1027 530
108 837.7512 2022-09-21 00:00:00.0 3.7553 530
109 840.0269 2022-09-22 00:00:00.0 2.2757 530
110 843.4581 2022-09-23 00:00:00.0 3.4312 530
111 850.5863 2022-09-24 00:00:00.0 7.1282 530
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '530') 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 851
9/23/2022 3 843
9/22/2022 2 840
9/21/2022 4 838
9/20/2022 7 834
9/19/2022 6 827
9/18/2022 7 821
9/17/2022 7 813
9/16/2022 6 806
9/15/2022 7 800
9/14/2022 6 793
9/13/2022 5 787
9/12/2022 6 783
9/11/2022 5 777
9/10/2022 5 771
9/9/2022 7 766
9/8/2022 8 760
9/7/2022 6 752
9/6/2022 8 746
9/5/2022 8 738
9/4/2022 7 730
9/3/2022 6 723
9/2/2022 8 718
9/1/2022 7 710
8/31/2022 7 703
8/30/2022 8 696
8/29/2022 9 688
8/28/2022 9 679
8/27/2022 8 670
8/26/2022 8 662
8/25/2022 6 654
8/24/2022 8 648
8/23/2022 9 640
8/22/2022 8 631
8/21/2022 7 623
8/20/2022 8 615
8/19/2022 9 608
8/18/2022 10 599
8/17/2022 8 589
8/16/2022 9 581
8/15/2022 9 573
8/14/2022 8 564
8/13/2022 8 556
8/12/2022 9 548
8/11/2022 6 539
8/10/2022 8 533
8/9/2022 9 525
8/8/2022 8 516
8/7/2022 6 508
8/6/2022 7 503
8/5/2022 9 495
8/4/2022 8 487
8/3/2022 8 479
8/2/2022 9 471
8/1/2022 8 462
7/31/2022 9 454
7/30/2022 8 446
7/29/2022 7 438
7/28/2022 9 430
7/27/2022 8 422
7/26/2022 9 413
7/25/2022 7 404
7/24/2022 7 397
7/23/2022 9 390
7/22/2022 9 381
7/21/2022 9 372
7/20/2022 9 363
7/19/2022 10 354
7/18/2022 8 345
7/17/2022 7 337
7/16/2022 9 330
7/15/2022 8 321
7/14/2022 9 313
7/13/2022 8 303
7/12/2022 9 295
7/11/2022 9 286
7/10/2022 9 277
7/9/2022 8 268
7/8/2022 9 260
7/7/2022 9 251
7/6/2022 9 242
7/5/2022 9 233
7/4/2022 10 224
7/3/2022 9 214
7/2/2022 8 205
7/1/2022 7 198
6/30/2022 8 190
6/29/2022 7 182
6/28/2022 8 175
6/27/2022 8 168
6/26/2022 8 160
6/25/2022 8 152
6/24/2022 9 144
6/23/2022 7 135
6/22/2022 7 128
6/21/2022 9 121
6/20/2022 8 113
6/19/2022 4 105
6/18/2022 8 101
6/17/2022 8 93
6/16/2022 8 85
6/15/2022 9 76
6/14/2022 9 68
6/13/2022 8 59
6/12/2022 9 50
6/11/2022 9 41
6/10/2022 8 32
6/9/2022 6 24
6/8/2022 6 18
6/7/2022 6 12