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.0112 2022-06-06 00:00:00.0 5.0112 204
2 11.1236 2022-06-07 00:00:00.0 6.1124 204
3 17.0702 2022-06-08 00:00:00.0 5.9466 204
4 23.0433 2022-06-09 00:00:00.0 5.9731 204
5 31.9560 2022-06-10 00:00:00.0 8.9127 204
6 40.7589 2022-06-11 00:00:00.0 8.8029 204
7 49.6314 2022-06-12 00:00:00.0 8.8725 204
8 57.4473 2022-06-13 00:00:00.0 7.8159 204
9 66.4273 2022-06-14 00:00:00.0 8.9800 204
10 74.5460 2022-06-15 00:00:00.0 8.1187 204
11 82.7234 2022-06-16 00:00:00.0 8.1774 204
12 91.2248 2022-06-17 00:00:00.0 8.5014 204
13 99.7344 2022-06-18 00:00:00.0 8.5096 204
14 105.0981 2022-06-19 00:00:00.0 5.3637 204
15 114.1435 2022-06-20 00:00:00.0 9.0454 204
16 122.4288 2022-06-21 00:00:00.0 8.2853 204
17 130.2201 2022-06-22 00:00:00.0 7.7913 204
18 137.9043 2022-06-23 00:00:00.0 7.6842 204
19 147.4231 2022-06-24 00:00:00.0 9.5188 204
20 154.7540 2022-06-25 00:00:00.0 7.3309 204
21 162.8094 2022-06-26 00:00:00.0 8.0554 204
22 171.2329 2022-06-27 00:00:00.0 8.4235 204
23 179.6912 2022-06-28 00:00:00.0 8.4583 204
24 187.5348 2022-06-29 00:00:00.0 7.8436 204
25 195.5814 2022-06-30 00:00:00.0 8.0466 204
26 203.1624 2022-07-01 00:00:00.0 7.5810 204
27 211.0306 2022-07-02 00:00:00.0 7.8682 204
28 219.8819 2022-07-03 00:00:00.0 8.8513 204
29 229.2152 2022-07-04 00:00:00.0 9.3333 204
30 238.5637 2022-07-05 00:00:00.0 9.3485 204
31 246.8823 2022-07-06 00:00:00.0 8.3186 204
32 255.6156 2022-07-07 00:00:00.0 8.7333 204
33 263.6002 2022-07-08 00:00:00.0 7.9846 204
34 271.3580 2022-07-09 00:00:00.0 7.7578 204
35 280.0491 2022-07-10 00:00:00.0 8.6911 204
36 289.1899 2022-07-11 00:00:00.0 9.1408 204
37 298.4843 2022-07-12 00:00:00.0 9.2944 204
38 306.6219 2022-07-13 00:00:00.0 8.1376 204
39 315.7971 2022-07-14 00:00:00.0 9.1752 204
40 323.6724 2022-07-15 00:00:00.0 7.8753 204
41 331.3374 2022-07-16 00:00:00.0 7.6650 204
42 336.6422 2022-07-17 00:00:00.0 5.3048 204
43 345.2107 2022-07-18 00:00:00.0 8.5685 204
44 354.8454 2022-07-19 00:00:00.0 9.6347 204
45 363.9011 2022-07-20 00:00:00.0 9.0557 204
46 372.7799 2022-07-21 00:00:00.0 8.8788 204
47 381.9634 2022-07-22 00:00:00.0 9.1835 204
48 391.1917 2022-07-23 00:00:00.0 9.2283 204
49 400.0486 2022-07-24 00:00:00.0 8.8569 204
50 408.5433 2022-07-25 00:00:00.0 8.4947 204
51 417.4555 2022-07-26 00:00:00.0 8.9122 204
52 425.7352 2022-07-27 00:00:00.0 8.2797 204
53 434.0922 2022-07-28 00:00:00.0 8.3570 204
54 442.5195 2022-07-29 00:00:00.0 8.4273 204
55 449.9543 2022-07-30 00:00:00.0 7.4348 204
56 459.2465 2022-07-31 00:00:00.0 9.2922 204
57 468.1989 2022-08-01 00:00:00.0 8.9524 204
58 476.1702 2022-08-02 00:00:00.0 7.9713 204
59 485.1699 2022-08-03 00:00:00.0 8.9997 204
60 492.8781 2022-08-04 00:00:00.0 7.7082 204
61 502.0196 2022-08-05 00:00:00.0 9.1415 204
62 509.7881 2022-08-06 00:00:00.0 7.7685 204
63 516.6786 2022-08-07 00:00:00.0 6.8905 204
64 524.3063 2022-08-08 00:00:00.0 7.6277 204
65 533.4583 2022-08-09 00:00:00.0 9.1520 204
66 541.6533 2022-08-10 00:00:00.0 8.1950 204
67 547.8941 2022-08-11 00:00:00.0 6.2408 204
68 557.1551 2022-08-12 00:00:00.0 9.2610 204
69 565.2952 2022-08-13 00:00:00.0 8.1401 204
70 573.6911 2022-08-14 00:00:00.0 8.3959 204
71 583.2399 2022-08-15 00:00:00.0 9.5488 204
72 591.5539 2022-08-16 00:00:00.0 8.3140 204
73 599.6028 2022-08-17 00:00:00.0 8.0489 204
74 609.2888 2022-08-18 00:00:00.0 9.6860 204
75 618.3246 2022-08-19 00:00:00.0 9.0358 204
76 626.0566 2022-08-20 00:00:00.0 7.7320 204
77 633.4592 2022-08-21 00:00:00.0 7.4026 204
78 642.8214 2022-08-22 00:00:00.0 9.3622 204
79 652.2822 2022-08-23 00:00:00.0 9.4608 204
80 660.0598 2022-08-24 00:00:00.0 7.7776 204
81 666.6160 2022-08-25 00:00:00.0 6.5562 204
82 675.2794 2022-08-26 00:00:00.0 8.6634 204
83 682.9651 2022-08-27 00:00:00.0 7.6857 204
84 692.1433 2022-08-28 00:00:00.0 9.1782 204
85 701.3659 2022-08-29 00:00:00.0 9.2226 204
86 709.4664 2022-08-30 00:00:00.0 8.1005 204
87 716.5653 2022-08-31 00:00:00.0 7.0989 204
88 723.5833 2022-09-01 00:00:00.0 7.0180 204
89 731.5085 2022-09-02 00:00:00.0 7.9252 204
90 737.9765 2022-09-03 00:00:00.0 6.4680 204
91 746.2390 2022-09-04 00:00:00.0 8.2625 204
92 753.8615 2022-09-05 00:00:00.0 7.6225 204
93 761.8196 2022-09-06 00:00:00.0 7.9581 204
94 767.9469 2022-09-07 00:00:00.0 6.1273 204
95 775.8915 2022-09-08 00:00:00.0 7.9446 204
96 781.4838 2022-09-09 00:00:00.0 5.5923 204
97 786.5308 2022-09-10 00:00:00.0 5.0470 204
98 792.8334 2022-09-11 00:00:00.0 6.3026 204
99 800.1940 2022-09-12 00:00:00.0 7.3606 204
100 804.5034 2022-09-13 00:00:00.0 4.3094 204
101 810.5761 2022-09-14 00:00:00.0 6.0727 204
102 818.1047 2022-09-15 00:00:00.0 7.5286 204
103 823.7285 2022-09-16 00:00:00.0 5.6238 204
104 830.5542 2022-09-17 00:00:00.0 6.8257 204
105 836.9564 2022-09-18 00:00:00.0 6.4022 204
106 842.3294 2022-09-19 00:00:00.0 5.3730 204
107 848.8288 2022-09-20 00:00:00.0 6.4994 204
108 851.5930 2022-09-21 00:00:00.0 2.7642 204
109 854.0171 2022-09-22 00:00:00.0 2.4241 204
110 858.0623 2022-09-23 00:00:00.0 4.0452 204
111 865.6872 2022-09-24 00:00:00.0 7.6249 204
CACHED false
EXECUTIONTIME 31
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '204') 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 4 858
9/22/2022 2 854
9/21/2022 3 852
9/20/2022 6 849
9/19/2022 5 842
9/18/2022 6 837
9/17/2022 7 831
9/16/2022 6 824
9/15/2022 8 818
9/14/2022 6 811
9/13/2022 4 805
9/12/2022 7 800
9/11/2022 6 793
9/10/2022 5 787
9/9/2022 6 781
9/8/2022 8 776
9/7/2022 6 768
9/6/2022 8 762
9/5/2022 8 754
9/4/2022 8 746
9/3/2022 6 738
9/2/2022 8 732
9/1/2022 7 724
8/31/2022 7 717
8/30/2022 8 709
8/29/2022 9 701
8/28/2022 9 692
8/27/2022 8 683
8/26/2022 9 675
8/25/2022 7 667
8/24/2022 8 660
8/23/2022 9 652
8/22/2022 9 643
8/21/2022 7 633
8/20/2022 8 626
8/19/2022 9 618
8/18/2022 10 609
8/17/2022 8 600
8/16/2022 8 592
8/15/2022 10 583
8/14/2022 8 574
8/13/2022 8 565
8/12/2022 9 557
8/11/2022 6 548
8/10/2022 8 542
8/9/2022 9 533
8/8/2022 8 524
8/7/2022 7 517
8/6/2022 8 510
8/5/2022 9 502
8/4/2022 8 493
8/3/2022 9 485
8/2/2022 8 476
8/1/2022 9 468
7/31/2022 9 459
7/30/2022 7 450
7/29/2022 8 443
7/28/2022 8 434
7/27/2022 8 426
7/26/2022 9 417
7/25/2022 8 409
7/24/2022 9 400
7/23/2022 9 391
7/22/2022 9 382
7/21/2022 9 373
7/20/2022 9 364
7/19/2022 10 355
7/18/2022 9 345
7/17/2022 5 337
7/16/2022 8 331
7/15/2022 8 324
7/14/2022 9 316
7/13/2022 8 307
7/12/2022 9 298
7/11/2022 9 289
7/10/2022 9 280
7/9/2022 8 271
7/8/2022 8 264
7/7/2022 9 256
7/6/2022 8 247
7/5/2022 9 239
7/4/2022 9 229
7/3/2022 9 220
7/2/2022 8 211
7/1/2022 8 203
6/30/2022 8 196
6/29/2022 8 188
6/28/2022 8 180
6/27/2022 8 171
6/26/2022 8 163
6/25/2022 7 155
6/24/2022 10 147
6/23/2022 8 138
6/22/2022 8 130
6/21/2022 8 122
6/20/2022 9 114
6/19/2022 5 105
6/18/2022 9 100
6/17/2022 9 91
6/16/2022 8 83
6/15/2022 8 75
6/14/2022 9 66
6/13/2022 8 57
6/12/2022 9 50
6/11/2022 9 41
6/10/2022 9 32
6/9/2022 6 23
6/8/2022 6 17
6/7/2022 6 11