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 7.7776 2017-05-15 00:00:00.0 7.7776 240
2 14.9837 2017-05-16 00:00:00.0 7.2061 240
3 15.1260 2017-05-17 00:00:00.0 0.1423 240
4 15.1260 2017-05-18 00:00:00.0 0.0000 240
5 18.2607 2017-05-19 00:00:00.0 3.1347 240
6 24.2194 2017-05-20 00:00:00.0 5.9587 240
7 28.0459 2017-05-21 00:00:00.0 3.8265 240
8 33.5377 2017-05-22 00:00:00.0 5.4918 240
9 40.8188 2017-05-23 00:00:00.0 7.2811 240
10 49.3856 2017-05-24 00:00:00.0 8.5668 240
11 56.5157 2017-05-25 00:00:00.0 7.1301 240
12 63.0009 2017-05-26 00:00:00.0 6.4852 240
13 70.0540 2017-05-27 00:00:00.0 7.0531 240
14 75.8290 2017-05-28 00:00:00.0 5.7750 240
15 79.6555 2017-05-29 00:00:00.0 3.8265 240
16 86.0555 2017-05-30 00:00:00.0 6.4000 240
17 95.2392 2017-05-31 00:00:00.0 9.1837 240
18 105.2194 2017-06-01 00:00:00.0 9.9802 240
19 113.7071 2017-06-02 00:00:00.0 8.4877 240
20 123.7066 2017-06-03 00:00:00.0 9.9995 240
21 133.5413 2017-06-04 00:00:00.0 9.8347 240
22 143.5163 2017-06-05 00:00:00.0 9.9750 240
23 153.2224 2017-06-06 00:00:00.0 9.7061 240
24 162.5974 2017-06-07 00:00:00.0 9.3750 240
25 172.3505 2017-06-08 00:00:00.0 9.7531 240
26 181.3173 2017-06-09 00:00:00.0 8.9668 240
27 190.9173 2017-06-10 00:00:00.0 9.6000 240
28 200.3949 2017-06-11 00:00:00.0 9.4776 240
29 209.3153 2017-06-12 00:00:00.0 8.9204 240
30 217.4168 2017-06-13 00:00:00.0 8.1015 240
31 225.8168 2017-06-14 00:00:00.0 8.4000 240
32 233.9801 2017-06-15 00:00:00.0 8.1633 240
33 242.5469 2017-06-16 00:00:00.0 8.5668 240
34 249.9750 2017-06-17 00:00:00.0 7.4281 240
35 257.5459 2017-06-18 00:00:00.0 7.5709 240
36 265.7699 2017-06-19 00:00:00.0 8.2240 240
37 274.2821 2017-06-20 00:00:00.0 8.5122 240
38 283.6923 2017-06-21 00:00:00.0 9.4102 240
39 291.8556 2017-06-22 00:00:00.0 8.1633 240
40 298.1694 2017-06-23 00:00:00.0 6.3138 240
41 302.3281 2017-06-24 00:00:00.0 4.1587 240
42 308.1954 2017-06-25 00:00:00.0 5.8673 240
43 316.5377 2017-06-26 00:00:00.0 8.3423 240
44 326.5357 2017-06-27 00:00:00.0 9.9980 240
45 336.5107 2017-06-28 00:00:00.0 9.9750 240
46 345.9209 2017-06-29 00:00:00.0 9.4102 240
47 354.4877 2017-06-30 00:00:00.0 8.5668 240
48 363.6714 2017-07-01 00:00:00.0 9.1837 240
49 372.3959 2017-07-02 00:00:00.0 8.7245 240
50 382.3848 2017-07-03 00:00:00.0 9.9889 240
51 391.4169 2017-07-04 00:00:00.0 9.0321 240
52 401.2391 2017-07-05 00:00:00.0 9.8222 240
53 411.2280 2017-07-06 00:00:00.0 9.9889 240
54 421.0030 2017-07-07 00:00:00.0 9.7750 240
55 430.9832 2017-07-08 00:00:00.0 9.9802 240
56 440.9388 2017-07-09 00:00:00.0 9.9556 240
57 450.6228 2017-07-10 00:00:00.0 9.6840 240
58 460.5611 2017-07-11 00:00:00.0 9.9383 240
59 469.4341 2017-07-12 00:00:00.0 8.8730 240
60 478.6178 2017-07-13 00:00:00.0 9.1837 240
61 488.5980 2017-07-14 00:00:00.0 9.9802 240
62 498.5730 2017-07-15 00:00:00.0 9.9750 240
63 508.5220 2017-07-16 00:00:00.0 9.9490 240
64 518.4615 2017-07-17 00:00:00.0 9.9395 240
65 527.6855 2017-07-18 00:00:00.0 9.2240 240
66 536.8692 2017-07-19 00:00:00.0 9.1837 240
67 546.6442 2017-07-20 00:00:00.0 9.7750 240
68 556.5580 2017-07-21 00:00:00.0 9.9138 240
69 566.0024 2017-07-22 00:00:00.0 9.4444 240
70 575.8550 2017-07-23 00:00:00.0 9.8526 240
71 585.4982 2017-07-24 00:00:00.0 9.6432 240
72 595.2732 2017-07-25 00:00:00.0 9.7750 240
73 605.2604 2017-07-26 00:00:00.0 9.9872 240
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '240') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/26/2017 10 605
7/25/2017 10 595
7/24/2017 10 585
7/23/2017 10 576
7/22/2017 9 566
7/21/2017 10 557
7/20/2017 10 547
7/19/2017 9 537
7/18/2017 9 528
7/17/2017 10 518
7/16/2017 10 509
7/15/2017 10 499
7/14/2017 10 489
7/13/2017 9 479
7/12/2017 9 469
7/11/2017 10 461
7/10/2017 10 451
7/9/2017 10 441
7/8/2017 10 431
7/7/2017 10 421
7/6/2017 10 411
7/5/2017 10 401
7/4/2017 9 391
7/3/2017 10 382
7/2/2017 9 372
7/1/2017 9 364
6/30/2017 9 354
6/29/2017 9 346
6/28/2017 10 337
6/27/2017 10 327
6/26/2017 8 317
6/25/2017 6 308
6/24/2017 4 302
6/23/2017 6 298
6/22/2017 8 292
6/21/2017 9 284
6/20/2017 9 274
6/19/2017 8 266
6/18/2017 8 258
6/17/2017 7 250
6/16/2017 9 243
6/15/2017 8 234
6/14/2017 8 226
6/13/2017 8 217
6/12/2017 9 209
6/11/2017 9 200
6/10/2017 10 191
6/9/2017 9 181
6/8/2017 10 172
6/7/2017 9 163
6/6/2017 10 153
6/5/2017 10 144
6/4/2017 10 134
6/3/2017 10 124
6/2/2017 8 114
6/1/2017 10 105
5/31/2017 9 95
5/30/2017 6 86
5/29/2017 4 80
5/28/2017 6 76
5/27/2017 7 70
5/26/2017 6 63
5/25/2017 7 57
5/24/2017 9 49
5/23/2017 7 41
5/22/2017 5 34
5/21/2017 4 28
5/20/2017 6 24
5/19/2017 3 18
5/18/2017 0 15
5/17/2017 0 15
5/16/2017 7 15
5/15/2017 8 8