Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Carberry North Wawanesa Glenboro Glenora Treherne Gladstone Portage East High Bluff Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Macdonald Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 8.3423 2017-05-15 00:00:00.0 8.3423 475
2 14.9117 2017-05-16 00:00:00.0 6.5694 475
3 14.9117 2017-05-17 00:00:00.0 0.0000 475
4 14.9117 2017-05-18 00:00:00.0 0.0000 475
5 17.3178 2017-05-19 00:00:00.0 2.4061 475
6 22.3173 2017-05-20 00:00:00.0 4.9995 475
7 24.2173 2017-05-21 00:00:00.0 1.9000 475
8 28.6989 2017-05-22 00:00:00.0 4.4816 475
9 35.6739 2017-05-23 00:00:00.0 6.9750 475
10 43.3147 2017-05-24 00:00:00.0 7.6408 475
11 50.1305 2017-05-25 00:00:00.0 6.8158 475
12 55.9978 2017-05-26 00:00:00.0 5.8673 475
13 62.6504 2017-05-27 00:00:00.0 6.6526 475
14 68.1422 2017-05-28 00:00:00.0 5.4918 475
15 71.1580 2017-05-29 00:00:00.0 3.0158 475
16 76.4560 2017-05-30 00:00:00.0 5.2980 475
17 84.9682 2017-05-31 00:00:00.0 8.5122 475
18 94.8820 2017-06-01 00:00:00.0 9.9138 475
19 104.5252 2017-06-02 00:00:00.0 9.6432 475
20 114.4742 2017-06-03 00:00:00.0 9.9490 475
21 124.2701 2017-06-04 00:00:00.0 9.7959 475
22 134.2655 2017-06-05 00:00:00.0 9.9954 475
23 144.0614 2017-06-06 00:00:00.0 9.7959 475
24 152.8364 2017-06-07 00:00:00.0 8.7750 475
25 162.6711 2017-06-08 00:00:00.0 9.8347 475
26 171.9726 2017-06-09 00:00:00.0 9.3015 475
27 181.4170 2017-06-10 00:00:00.0 9.4444 475
28 190.7920 2017-06-11 00:00:00.0 9.3750 475
29 199.4650 2017-06-12 00:00:00.0 8.6730 475
30 208.1380 2017-06-13 00:00:00.0 8.6730 475
31 216.4217 2017-06-14 00:00:00.0 8.2837 475
32 224.5850 2017-06-15 00:00:00.0 8.1633 475
33 232.9273 2017-06-16 00:00:00.0 8.3423 475
34 240.4273 2017-06-17 00:00:00.0 7.5000 475
35 247.6334 2017-06-18 00:00:00.0 7.2061 475
36 255.2742 2017-06-19 00:00:00.0 7.6408 475
37 263.1844 2017-06-20 00:00:00.0 7.9102 475
38 272.2410 2017-06-21 00:00:00.0 9.0566 475
39 279.9507 2017-06-22 00:00:00.0 7.7097 475
40 286.0890 2017-06-23 00:00:00.0 6.1383 475
41 289.4584 2017-06-24 00:00:00.0 3.3694 475
42 294.4579 2017-06-25 00:00:00.0 4.9995 475
43 301.6640 2017-06-26 00:00:00.0 7.2061 475
44 311.4798 2017-06-27 00:00:00.0 9.8158 475
45 321.4063 2017-06-28 00:00:00.0 9.9265 475
46 330.5486 2017-06-29 00:00:00.0 9.1423 475
47 338.7726 2017-06-30 00:00:00.0 8.2240 475
48 347.3394 2017-07-01 00:00:00.0 8.5668 475
49 355.5027 2017-07-02 00:00:00.0 8.1633 475
50 365.4843 2017-07-03 00:00:00.0 9.9816 475
51 374.7127 2017-07-04 00:00:00.0 9.2284 475
52 384.6818 2017-07-05 00:00:00.0 9.9691 475
53 394.6201 2017-07-06 00:00:00.0 9.9383 475
54 404.1298 2017-07-07 00:00:00.0 9.5097 475
55 414.1170 2017-07-08 00:00:00.0 9.9872 475
56 424.1150 2017-07-09 00:00:00.0 9.9980 475
57 434.1150 2017-07-10 00:00:00.0 10.0000 475
58 444.1022 2017-07-11 00:00:00.0 9.9872 475
59 452.1410 2017-07-12 00:00:00.0 8.0388 475
60 460.7078 2017-07-13 00:00:00.0 8.5668 475
61 470.6828 2017-07-14 00:00:00.0 9.9750 475
62 480.5354 2017-07-15 00:00:00.0 9.8526 475
63 490.2415 2017-07-16 00:00:00.0 9.7061 475
64 500.1415 2017-07-17 00:00:00.0 9.9000 475
65 509.2415 2017-07-18 00:00:00.0 9.1000 475
66 518.3838 2017-07-19 00:00:00.0 9.1423 475
67 528.1369 2017-07-20 00:00:00.0 9.7531 475
68 538.1119 2017-07-21 00:00:00.0 9.9750 475
69 547.4869 2017-07-22 00:00:00.0 9.3750 475
70 557.2828 2017-07-23 00:00:00.0 9.7959 475
71 567.1593 2017-07-24 00:00:00.0 9.8765 475
72 577.0445 2017-07-25 00:00:00.0 9.8852 475
73 587.0032 2017-07-26 00:00:00.0 9.9587 475
74 596.9848 2017-07-27 00:00:00.0 9.9816 475
75 606.8354 2017-07-28 00:00:00.0 9.8506 475
76 616.8342 2017-07-29 00:00:00.0 9.9988 475
77 626.2898 2017-07-30 00:00:00.0 9.4556 475
78 635.2515 2017-07-31 00:00:00.0 8.9617 475
79 645.0046 2017-08-01 00:00:00.0 9.7531 475
80 651.7393 2017-08-02 00:00:00.0 6.7347 475
81 660.7061 2017-08-03 00:00:00.0 8.9668 475
82 669.7183 2017-08-04 00:00:00.0 9.0122 475
83 678.4428 2017-08-05 00:00:00.0 8.7245 475
84 687.1673 2017-08-06 00:00:00.0 8.7245 475
85 696.8224 2017-08-07 00:00:00.0 9.6551 475
86 706.4224 2017-08-08 00:00:00.0 9.6000 475
87 714.7061 2017-08-09 00:00:00.0 8.2837 475
88 723.9694 2017-08-10 00:00:00.0 9.2633 475
89 732.8898 2017-08-11 00:00:00.0 8.9204 475
90 741.8566 2017-08-12 00:00:00.0 8.9668 475
91 751.0403 2017-08-13 00:00:00.0 9.1837 475
92 760.5179 2017-08-14 00:00:00.0 9.4776 475
93 769.4847 2017-08-15 00:00:00.0 8.9668 475
94 779.0847 2017-08-16 00:00:00.0 9.6000 475
95 788.5623 2017-08-17 00:00:00.0 9.4776 475
96 798.4317 2017-08-18 00:00:00.0 9.8694 475
97 808.3712 2017-08-19 00:00:00.0 9.9395 475
98 817.8156 2017-08-20 00:00:00.0 9.4444 475
99 825.9789 2017-08-21 00:00:00.0 8.1633 475
100 834.5993 2017-08-22 00:00:00.0 8.6204 475
101 842.0274 2017-08-23 00:00:00.0 7.4281 475
102 850.2514 2017-08-24 00:00:00.0 8.2240 475
103 859.8514 2017-08-25 00:00:00.0 9.6000 475
104 869.4514 2017-08-26 00:00:00.0 9.6000 475
105 879.4330 2017-08-27 00:00:00.0 9.9816 475
106 889.1910 2017-08-28 00:00:00.0 9.7580 475
107 898.5379 2017-08-29 00:00:00.0 9.3469 475
108 908.4231 2017-08-30 00:00:00.0 9.8852 475
109 918.3369 2017-08-31 00:00:00.0 9.9138 475
110 928.3287 2017-09-01 00:00:00.0 9.9918 475
111 938.2287 2017-09-02 00:00:00.0 9.9000 475
112 948.2103 2017-09-03 00:00:00.0 9.9816 475
113 957.0833 2017-09-04 00:00:00.0 8.8730 475
114 964.9277 2017-09-05 00:00:00.0 7.8444 475
115 973.1517 2017-09-06 00:00:00.0 8.2240 475
116 982.8068 2017-09-07 00:00:00.0 9.6551 475
117 990.6512 2017-09-08 00:00:00.0 7.8444 475
118 999.9900 2017-09-09 00:00:00.0 9.3388 475
119 1009.7122 2017-09-10 00:00:00.0 9.7222 475
120 1019.7076 2017-09-11 00:00:00.0 9.9954 475
121 1028.1076 2017-09-12 00:00:00.0 8.4000 475
122 1037.6484 2017-09-13 00:00:00.0 9.5408 475
123 1045.3581 2017-09-14 00:00:00.0 7.7097 475
124 1049.2964 2017-09-15 00:00:00.0 3.9383 475
125 1050.9372 2017-09-16 00:00:00.0 1.6408 475
126 1054.7637 2017-09-17 00:00:00.0 3.8265 475
127 1060.9020 2017-09-18 00:00:00.0 6.1383 475
128 1069.4688 2017-09-19 00:00:00.0 8.5668 475
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '475') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/19/2017 9 1069
9/18/2017 6 1061
9/17/2017 4 1055
9/16/2017 2 1051
9/15/2017 4 1049
9/14/2017 8 1045
9/13/2017 10 1038
9/12/2017 8 1028
9/11/2017 10 1020
9/10/2017 10 1010
9/9/2017 9 1000
9/8/2017 8 991
9/7/2017 10 983
9/6/2017 8 973
9/5/2017 8 965
9/4/2017 9 957
9/3/2017 10 948
9/2/2017 10 938
9/1/2017 10 928
8/31/2017 10 918
8/30/2017 10 908
8/29/2017 9 899
8/28/2017 10 889
8/27/2017 10 879
8/26/2017 10 869
8/25/2017 10 860
8/24/2017 8 850
8/23/2017 7 842
8/22/2017 9 835
8/21/2017 8 826
8/20/2017 9 818
8/19/2017 10 808
8/18/2017 10 798
8/17/2017 9 789
8/16/2017 10 779
8/15/2017 9 769
8/14/2017 9 761
8/13/2017 9 751
8/12/2017 9 742
8/11/2017 9 733
8/10/2017 9 724
8/9/2017 8 715
8/8/2017 10 706
8/7/2017 10 697
8/6/2017 9 687
8/5/2017 9 678
8/4/2017 9 670
8/3/2017 9 661
8/2/2017 7 652
8/1/2017 10 645
7/31/2017 9 635
7/30/2017 9 626
7/29/2017 10 617
7/28/2017 10 607
7/27/2017 10 597
7/26/2017 10 587
7/25/2017 10 577
7/24/2017 10 567
7/23/2017 10 557
7/22/2017 9 547
7/21/2017 10 538
7/20/2017 10 528
7/19/2017 9 518
7/18/2017 9 509
7/17/2017 10 500
7/16/2017 10 490
7/15/2017 10 481
7/14/2017 10 471
7/13/2017 9 461
7/12/2017 8 452
7/11/2017 10 444
7/10/2017 10 434
7/9/2017 10 424
7/8/2017 10 414
7/7/2017 10 404
7/6/2017 10 395
7/5/2017 10 385
7/4/2017 9 375
7/3/2017 10 365
7/2/2017 8 356
7/1/2017 9 347
6/30/2017 8 339
6/29/2017 9 331
6/28/2017 10 321
6/27/2017 10 311
6/26/2017 7 302
6/25/2017 5 294
6/24/2017 3 289
6/23/2017 6 286
6/22/2017 8 280
6/21/2017 9 272
6/20/2017 8 263
6/19/2017 8 255
6/18/2017 7 248
6/17/2017 8 240
6/16/2017 8 233
6/15/2017 8 225
6/14/2017 8 216
6/13/2017 9 208
6/12/2017 9 199
6/11/2017 9 191
6/10/2017 9 181
6/9/2017 9 172
6/8/2017 10 163
6/7/2017 9 153
6/6/2017 10 144
6/5/2017 10 134
6/4/2017 10 124
6/3/2017 10 114
6/2/2017 10 105
6/1/2017 10 95
5/31/2017 9 85
5/30/2017 5 76
5/29/2017 3 71
5/28/2017 5 68
5/27/2017 7 63
5/26/2017 6 56
5/25/2017 7 50
5/24/2017 8 43
5/23/2017 7 36
5/22/2017 4 29
5/21/2017 2 24
5/20/2017 5 22
5/19/2017 2 17
5/18/2017 0 15
5/17/2017 0 15
5/16/2017 7 15
5/15/2017 8 8