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.3786 2022-06-06 00:00:00.0 5.3786 203
2 11.3077 2022-06-07 00:00:00.0 5.9291 203
3 17.4143 2022-06-08 00:00:00.0 6.1066 203
4 23.4169 2022-06-09 00:00:00.0 6.0026 203
5 31.3289 2022-06-10 00:00:00.0 7.9120 203
6 40.1825 2022-06-11 00:00:00.0 8.8536 203
7 49.2759 2022-06-12 00:00:00.0 9.0934 203
8 57.3923 2022-06-13 00:00:00.0 8.1164 203
9 66.6845 2022-06-14 00:00:00.0 9.2922 203
10 75.7624 2022-06-15 00:00:00.0 9.0779 203
11 84.3320 2022-06-16 00:00:00.0 8.5696 203
12 92.3951 2022-06-17 00:00:00.0 8.0631 203
13 100.7353 2022-06-18 00:00:00.0 8.3402 203
14 104.3159 2022-06-19 00:00:00.0 3.5806 203
15 110.4946 2022-06-20 00:00:00.0 6.1787 203
16 118.6576 2022-06-21 00:00:00.0 8.1630 203
17 125.9512 2022-06-22 00:00:00.0 7.2936 203
18 132.4443 2022-06-23 00:00:00.0 6.4931 203
19 141.2637 2022-06-24 00:00:00.0 8.8194 203
20 149.3528 2022-06-25 00:00:00.0 8.0891 203
21 157.3483 2022-06-26 00:00:00.0 7.9955 203
22 164.7721 2022-06-27 00:00:00.0 7.4238 203
23 172.2914 2022-06-28 00:00:00.0 7.5193 203
24 180.0609 2022-06-29 00:00:00.0 7.7695 203
25 188.1221 2022-06-30 00:00:00.0 8.0612 203
26 194.3606 2022-07-01 00:00:00.0 6.2385 203
27 201.9982 2022-07-02 00:00:00.0 7.6376 203
28 210.2352 2022-07-03 00:00:00.0 8.2370 203
29 220.0095 2022-07-04 00:00:00.0 9.7743 203
30 229.1988 2022-07-05 00:00:00.0 9.1893 203
31 237.9033 2022-07-06 00:00:00.0 8.7045 203
32 246.9689 2022-07-07 00:00:00.0 9.0656 203
33 254.5547 2022-07-08 00:00:00.0 7.5858 203
34 262.6060 2022-07-09 00:00:00.0 8.0513 203
35 271.6430 2022-07-10 00:00:00.0 9.0370 203
36 280.9658 2022-07-11 00:00:00.0 9.3228 203
37 289.8937 2022-07-12 00:00:00.0 8.9279 203
38 298.0467 2022-07-13 00:00:00.0 8.1530 203
39 307.7006 2022-07-14 00:00:00.0 9.6539 203
40 316.0424 2022-07-15 00:00:00.0 8.3418 203
41 324.8498 2022-07-16 00:00:00.0 8.8074 203
42 331.4009 2022-07-17 00:00:00.0 6.5511 203
43 338.4526 2022-07-18 00:00:00.0 7.0517 203
44 347.6775 2022-07-19 00:00:00.0 9.2249 203
45 356.5723 2022-07-20 00:00:00.0 8.8948 203
46 365.4446 2022-07-21 00:00:00.0 8.8723 203
47 374.4243 2022-07-22 00:00:00.0 8.9797 203
48 383.5798 2022-07-23 00:00:00.0 9.1555 203
49 391.3503 2022-07-24 00:00:00.0 7.7705 203
50 398.7898 2022-07-25 00:00:00.0 7.4395 203
51 408.0895 2022-07-26 00:00:00.0 9.2997 203
52 416.1615 2022-07-27 00:00:00.0 8.0720 203
53 424.5379 2022-07-28 00:00:00.0 8.3764 203
54 432.0964 2022-07-29 00:00:00.0 7.5585 203
55 440.5197 2022-07-30 00:00:00.0 8.4233 203
56 448.9381 2022-07-31 00:00:00.0 8.4184 203
57 456.7346 2022-08-01 00:00:00.0 7.7965 203
58 465.5586 2022-08-02 00:00:00.0 8.8240 203
59 474.1617 2022-08-03 00:00:00.0 8.6031 203
60 482.2346 2022-08-04 00:00:00.0 8.0729 203
61 490.8331 2022-08-05 00:00:00.0 8.5985 203
62 498.7301 2022-08-06 00:00:00.0 7.8970 203
63 505.4724 2022-08-07 00:00:00.0 6.7423 203
64 513.3628 2022-08-08 00:00:00.0 7.8904 203
65 522.2521 2022-08-09 00:00:00.0 8.8893 203
66 529.1917 2022-08-10 00:00:00.0 6.9396 203
67 535.4336 2022-08-11 00:00:00.0 6.2419 203
68 544.5848 2022-08-12 00:00:00.0 9.1512 203
69 552.7224 2022-08-13 00:00:00.0 8.1376 203
70 561.0040 2022-08-14 00:00:00.0 8.2816 203
71 569.7815 2022-08-15 00:00:00.0 8.7775 203
72 578.6066 2022-08-16 00:00:00.0 8.8251 203
73 586.7269 2022-08-17 00:00:00.0 8.1203 203
74 596.4250 2022-08-18 00:00:00.0 9.6981 203
75 605.5773 2022-08-19 00:00:00.0 9.1523 203
76 613.5742 2022-08-20 00:00:00.0 7.9969 203
77 621.1255 2022-08-21 00:00:00.0 7.5513 203
78 629.2648 2022-08-22 00:00:00.0 8.1393 203
79 638.0701 2022-08-23 00:00:00.0 8.8053 203
80 646.0463 2022-08-24 00:00:00.0 7.9762 203
81 652.3019 2022-08-25 00:00:00.0 6.2556 203
82 660.5810 2022-08-26 00:00:00.0 8.2791 203
83 669.5856 2022-08-27 00:00:00.0 9.0046 203
84 678.4883 2022-08-28 00:00:00.0 8.9027 203
85 687.0579 2022-08-29 00:00:00.0 8.5696 203
86 694.5580 2022-08-30 00:00:00.0 7.5001 203
87 701.5729 2022-08-31 00:00:00.0 7.0149 203
88 708.5446 2022-09-01 00:00:00.0 6.9717 203
89 716.2228 2022-09-02 00:00:00.0 7.6782 203
90 721.9362 2022-09-03 00:00:00.0 5.7134 203
91 730.0443 2022-09-04 00:00:00.0 8.1081 203
92 738.7130 2022-09-05 00:00:00.0 8.6687 203
93 746.6530 2022-09-06 00:00:00.0 7.9400 203
94 752.9806 2022-09-07 00:00:00.0 6.3276 203
95 761.3178 2022-09-08 00:00:00.0 8.3372 203
96 767.3981 2022-09-09 00:00:00.0 6.0803 203
97 771.7387 2022-09-10 00:00:00.0 4.3406 203
98 777.7447 2022-09-11 00:00:00.0 6.0060 203
99 784.8021 2022-09-12 00:00:00.0 7.0574 203
100 789.8608 2022-09-13 00:00:00.0 5.0587 203
101 795.2486 2022-09-14 00:00:00.0 5.3878 203
102 802.8086 2022-09-15 00:00:00.0 7.5600 203
103 809.3594 2022-09-16 00:00:00.0 6.5508 203
104 816.9274 2022-09-17 00:00:00.0 7.5680 203
105 824.6947 2022-09-18 00:00:00.0 7.7673 203
106 831.3821 2022-09-19 00:00:00.0 6.6874 203
107 838.8911 2022-09-20 00:00:00.0 7.5090 203
108 841.6026 2022-09-21 00:00:00.0 2.7115 203
109 843.8634 2022-09-22 00:00:00.0 2.2608 203
110 848.2499 2022-09-23 00:00:00.0 4.3865 203
111 853.7058 2022-09-24 00:00:00.0 5.4559 203
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '203') 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 5 854
9/23/2022 4 848
9/22/2022 2 844
9/21/2022 3 842
9/20/2022 8 839
9/19/2022 7 831
9/18/2022 8 825
9/17/2022 8 817
9/16/2022 7 809
9/15/2022 8 803
9/14/2022 5 795
9/13/2022 5 790
9/12/2022 7 785
9/11/2022 6 778
9/10/2022 4 772
9/9/2022 6 767
9/8/2022 8 761
9/7/2022 6 753
9/6/2022 8 747
9/5/2022 9 739
9/4/2022 8 730
9/3/2022 6 722
9/2/2022 8 716
9/1/2022 7 709
8/31/2022 7 702
8/30/2022 8 695
8/29/2022 9 687
8/28/2022 9 678
8/27/2022 9 670
8/26/2022 8 661
8/25/2022 6 652
8/24/2022 8 646
8/23/2022 9 638
8/22/2022 8 629
8/21/2022 8 621
8/20/2022 8 614
8/19/2022 9 606
8/18/2022 10 596
8/17/2022 8 587
8/16/2022 9 579
8/15/2022 9 570
8/14/2022 8 561
8/13/2022 8 553
8/12/2022 9 545
8/11/2022 6 535
8/10/2022 7 529
8/9/2022 9 522
8/8/2022 8 513
8/7/2022 7 505
8/6/2022 8 499
8/5/2022 9 491
8/4/2022 8 482
8/3/2022 9 474
8/2/2022 9 466
8/1/2022 8 457
7/31/2022 8 449
7/30/2022 8 441
7/29/2022 8 432
7/28/2022 8 425
7/27/2022 8 416
7/26/2022 9 408
7/25/2022 7 399
7/24/2022 8 391
7/23/2022 9 384
7/22/2022 9 374
7/21/2022 9 365
7/20/2022 9 357
7/19/2022 9 348
7/18/2022 7 338
7/17/2022 7 331
7/16/2022 9 325
7/15/2022 8 316
7/14/2022 10 308
7/13/2022 8 298
7/12/2022 9 290
7/11/2022 9 281
7/10/2022 9 272
7/9/2022 8 263
7/8/2022 8 255
7/7/2022 9 247
7/6/2022 9 238
7/5/2022 9 229
7/4/2022 10 220
7/3/2022 8 210
7/2/2022 8 202
7/1/2022 6 194
6/30/2022 8 188
6/29/2022 8 180
6/28/2022 8 172
6/27/2022 7 165
6/26/2022 8 157
6/25/2022 8 149
6/24/2022 9 141
6/23/2022 6 132
6/22/2022 7 126
6/21/2022 8 119
6/20/2022 6 110
6/19/2022 4 104
6/18/2022 8 101
6/17/2022 8 92
6/16/2022 9 84
6/15/2022 9 76
6/14/2022 9 67
6/13/2022 8 57
6/12/2022 9 49
6/11/2022 9 40
6/10/2022 8 31
6/9/2022 6 23
6/8/2022 6 17
6/7/2022 6 11