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.2426 2022-06-06 00:00:00.0 5.2426 551
2 11.3074 2022-06-07 00:00:00.0 6.0648 551
3 17.2710 2022-06-08 00:00:00.0 5.9636 551
4 23.8875 2022-06-09 00:00:00.0 6.6165 551
5 32.7755 2022-06-10 00:00:00.0 8.8880 551
6 41.4918 2022-06-11 00:00:00.0 8.7163 551
7 50.6096 2022-06-12 00:00:00.0 9.1178 551
8 58.7245 2022-06-13 00:00:00.0 8.1149 551
9 67.5163 2022-06-14 00:00:00.0 8.7918 551
10 74.7336 2022-06-15 00:00:00.0 7.2173 551
11 82.6533 2022-06-16 00:00:00.0 7.9197 551
12 90.9860 2022-06-17 00:00:00.0 8.3327 551
13 99.0391 2022-06-18 00:00:00.0 8.0531 551
14 104.3923 2022-06-19 00:00:00.0 5.3532 551
15 113.9247 2022-06-20 00:00:00.0 9.5324 551
16 122.2632 2022-06-21 00:00:00.0 8.3385 551
17 130.0270 2022-06-22 00:00:00.0 7.7638 551
18 137.8229 2022-06-23 00:00:00.0 7.7959 551
19 146.9981 2022-06-24 00:00:00.0 9.1752 551
20 154.0619 2022-06-25 00:00:00.0 7.0638 551
21 161.8165 2022-06-26 00:00:00.0 7.7546 551
22 170.2099 2022-06-27 00:00:00.0 8.3934 551
23 178.4746 2022-06-28 00:00:00.0 8.2647 551
24 186.0723 2022-06-29 00:00:00.0 7.5977 551
25 194.2389 2022-06-30 00:00:00.0 8.1666 551
26 201.4545 2022-07-01 00:00:00.0 7.2156 551
27 209.4090 2022-07-02 00:00:00.0 7.9545 551
28 217.8136 2022-07-03 00:00:00.0 8.4046 551
29 226.7306 2022-07-04 00:00:00.0 8.9170 551
30 235.9497 2022-07-05 00:00:00.0 9.2191 551
31 244.6314 2022-07-06 00:00:00.0 8.6817 551
32 253.0119 2022-07-07 00:00:00.0 8.3805 551
33 260.9519 2022-07-08 00:00:00.0 7.9400 551
34 269.3892 2022-07-09 00:00:00.0 8.4373 551
35 278.5470 2022-07-10 00:00:00.0 9.1578 551
36 288.0600 2022-07-11 00:00:00.0 9.5130 551
37 297.0445 2022-07-12 00:00:00.0 8.9845 551
38 305.1339 2022-07-13 00:00:00.0 8.0894 551
39 314.6663 2022-07-14 00:00:00.0 9.5324 551
40 322.8001 2022-07-15 00:00:00.0 8.1338 551
41 331.0648 2022-07-16 00:00:00.0 8.2647 551
42 337.7295 2022-07-17 00:00:00.0 6.6647 551
43 346.6668 2022-07-18 00:00:00.0 8.9373 551
44 356.2750 2022-07-19 00:00:00.0 9.6082 551
45 365.4273 2022-07-20 00:00:00.0 9.1523 551
46 374.0828 2022-07-21 00:00:00.0 8.6555 551
47 382.8222 2022-07-22 00:00:00.0 8.7394 551
48 391.2888 2022-07-23 00:00:00.0 8.4666 551
49 398.9305 2022-07-24 00:00:00.0 7.6417 551
50 406.5032 2022-07-25 00:00:00.0 7.5727 551
51 415.0857 2022-07-26 00:00:00.0 8.5825 551
52 422.5509 2022-07-27 00:00:00.0 7.4652 551
53 430.5553 2022-07-28 00:00:00.0 8.0044 551
54 438.1477 2022-07-29 00:00:00.0 7.5924 551
55 445.0289 2022-07-30 00:00:00.0 6.8812 551
56 453.9991 2022-07-31 00:00:00.0 8.9702 551
57 462.3266 2022-08-01 00:00:00.0 8.3275 551
58 470.7513 2022-08-02 00:00:00.0 8.4247 551
59 479.0788 2022-08-03 00:00:00.0 8.3275 551
60 486.5469 2022-08-04 00:00:00.0 7.4681 551
61 495.7081 2022-08-05 00:00:00.0 9.1612 551
62 502.2349 2022-08-06 00:00:00.0 6.5268 551
63 508.3978 2022-08-07 00:00:00.0 6.1629 551
64 516.4276 2022-08-08 00:00:00.0 8.0298 551
65 525.0153 2022-08-09 00:00:00.0 8.5877 551
66 531.9717 2022-08-10 00:00:00.0 6.9564 551
67 537.9874 2022-08-11 00:00:00.0 6.0157 551
68 547.1252 2022-08-12 00:00:00.0 9.1378 551
69 555.6911 2022-08-13 00:00:00.0 8.5659 551
70 563.8359 2022-08-14 00:00:00.0 8.1448 551
71 573.1315 2022-08-15 00:00:00.0 9.2956 551
72 581.2688 2022-08-16 00:00:00.0 8.1373 551
73 590.0018 2022-08-17 00:00:00.0 8.7330 551
74 599.1754 2022-08-18 00:00:00.0 9.1736 551
75 607.7423 2022-08-19 00:00:00.0 8.5669 551
76 614.7288 2022-08-20 00:00:00.0 6.9865 551
77 622.2668 2022-08-21 00:00:00.0 7.5380 551
78 631.0934 2022-08-22 00:00:00.0 8.8266 551
79 640.4851 2022-08-23 00:00:00.0 9.3917 551
80 647.0913 2022-08-24 00:00:00.0 6.6062 551
81 653.3761 2022-08-25 00:00:00.0 6.2848 551
82 661.4349 2022-08-26 00:00:00.0 8.0588 551
83 669.4965 2022-08-27 00:00:00.0 8.0616 551
84 678.3734 2022-08-28 00:00:00.0 8.8769 551
85 686.9895 2022-08-29 00:00:00.0 8.6161 551
86 694.6100 2022-08-30 00:00:00.0 7.6205 551
87 701.5207 2022-08-31 00:00:00.0 6.9107 551
88 708.0830 2022-09-01 00:00:00.0 6.5623 551
89 715.5523 2022-09-02 00:00:00.0 7.4693 551
90 721.5687 2022-09-03 00:00:00.0 6.0164 551
91 729.8057 2022-09-04 00:00:00.0 8.2370 551
92 736.8786 2022-09-05 00:00:00.0 7.0729 551
93 744.2981 2022-09-06 00:00:00.0 7.4195 551
94 750.3878 2022-09-07 00:00:00.0 6.0897 551
95 757.6032 2022-09-08 00:00:00.0 7.2154 551
96 762.9533 2022-09-09 00:00:00.0 5.3501 551
97 767.8735 2022-09-10 00:00:00.0 4.9202 551
98 773.8235 2022-09-11 00:00:00.0 5.9500 551
99 781.0481 2022-09-12 00:00:00.0 7.2246 551
100 785.7810 2022-09-13 00:00:00.0 4.7329 551
101 792.0449 2022-09-14 00:00:00.0 6.2639 551
102 798.8397 2022-09-15 00:00:00.0 6.7948 551
103 803.1385 2022-09-16 00:00:00.0 4.2988 551
104 809.6716 2022-09-17 00:00:00.0 6.5331 551
105 816.7232 2022-09-18 00:00:00.0 7.0516 551
106 821.6319 2022-09-19 00:00:00.0 4.9087 551
107 826.7648 2022-09-20 00:00:00.0 5.1329 551
108 828.5940 2022-09-21 00:00:00.0 1.8292 551
109 830.8799 2022-09-22 00:00:00.0 2.2859 551
110 835.5808 2022-09-23 00:00:00.0 4.7009 551
111 842.6300 2022-09-24 00:00:00.0 7.0492 551
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '551') 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 843
9/23/2022 5 836
9/22/2022 2 831
9/21/2022 2 829
9/20/2022 5 827
9/19/2022 5 822
9/18/2022 7 817
9/17/2022 7 810
9/16/2022 4 803
9/15/2022 7 799
9/14/2022 6 792
9/13/2022 5 786
9/12/2022 7 781
9/11/2022 6 774
9/10/2022 5 768
9/9/2022 5 763
9/8/2022 7 758
9/7/2022 6 750
9/6/2022 7 744
9/5/2022 7 737
9/4/2022 8 730
9/3/2022 6 722
9/2/2022 7 716
9/1/2022 7 708
8/31/2022 7 702
8/30/2022 8 695
8/29/2022 9 687
8/28/2022 9 678
8/27/2022 8 669
8/26/2022 8 661
8/25/2022 6 653
8/24/2022 7 647
8/23/2022 9 640
8/22/2022 9 631
8/21/2022 8 622
8/20/2022 7 615
8/19/2022 9 608
8/18/2022 9 599
8/17/2022 9 590
8/16/2022 8 581
8/15/2022 9 573
8/14/2022 8 564
8/13/2022 9 556
8/12/2022 9 547
8/11/2022 6 538
8/10/2022 7 532
8/9/2022 9 525
8/8/2022 8 516
8/7/2022 6 508
8/6/2022 7 502
8/5/2022 9 496
8/4/2022 7 487
8/3/2022 8 479
8/2/2022 8 471
8/1/2022 8 462
7/31/2022 9 454
7/30/2022 7 445
7/29/2022 8 438
7/28/2022 8 431
7/27/2022 7 423
7/26/2022 9 415
7/25/2022 8 407
7/24/2022 8 399
7/23/2022 8 391
7/22/2022 9 383
7/21/2022 9 374
7/20/2022 9 365
7/19/2022 10 356
7/18/2022 9 347
7/17/2022 7 338
7/16/2022 8 331
7/15/2022 8 323
7/14/2022 10 315
7/13/2022 8 305
7/12/2022 9 297
7/11/2022 10 288
7/10/2022 9 279
7/9/2022 8 269
7/8/2022 8 261
7/7/2022 8 253
7/6/2022 9 245
7/5/2022 9 236
7/4/2022 9 227
7/3/2022 8 218
7/2/2022 8 209
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 8 162
6/25/2022 7 154
6/24/2022 9 147
6/23/2022 8 138
6/22/2022 8 130
6/21/2022 8 122
6/20/2022 10 114
6/19/2022 5 104
6/18/2022 8 99
6/17/2022 8 91
6/16/2022 8 83
6/15/2022 7 75
6/14/2022 9 68
6/13/2022 8 59
6/12/2022 9 51
6/11/2022 9 41
6/10/2022 9 33
6/9/2022 7 24
6/8/2022 6 17
6/7/2022 6 11