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 9.1000 2017-05-19 00:00:00.0 9.1000 327
2 15.0587 2017-05-20 00:00:00.0 5.9587 327
3 17.3398 2017-05-21 00:00:00.0 2.2811 327
4 21.0536 2017-05-22 00:00:00.0 3.7138 327
5 29.0924 2017-05-23 00:00:00.0 8.0388 327
6 37.1939 2017-05-24 00:00:00.0 8.1015 327
7 44.7648 2017-05-25 00:00:00.0 7.5709 327
8 52.8663 2017-05-26 00:00:00.0 8.1015 327
9 61.1500 2017-05-27 00:00:00.0 8.2837 327
10 66.0480 2017-05-28 00:00:00.0 4.8980 327
11 67.8189 2017-05-29 00:00:00.0 1.7709 327
12 74.5536 2017-05-30 00:00:00.0 6.7347 327
13 83.4266 2017-05-31 00:00:00.0 8.8730 327
14 93.3853 2017-06-01 00:00:00.0 9.9587 327
15 101.9581 2017-06-02 00:00:00.0 8.5728 327
16 111.9383 2017-06-03 00:00:00.0 9.9802 327
17 121.7342 2017-06-04 00:00:00.0 9.7959 327
18 131.7092 2017-06-05 00:00:00.0 9.9750 327
19 141.4393 2017-06-06 00:00:00.0 9.7301 327
20 150.7781 2017-06-07 00:00:00.0 9.3388 327
21 160.5740 2017-06-08 00:00:00.0 9.7959 327
22 169.6740 2017-06-09 00:00:00.0 9.1000 327
23 179.3021 2017-06-10 00:00:00.0 9.6281 327
24 188.4444 2017-06-11 00:00:00.0 9.1423 327
25 197.2689 2017-06-12 00:00:00.0 8.8245 327
26 205.7811 2017-06-13 00:00:00.0 8.5122 327
27 213.8826 2017-06-14 00:00:00.0 8.1015 327
28 221.5923 2017-06-15 00:00:00.0 7.7097 327
29 229.7556 2017-06-16 00:00:00.0 8.1633 327
30 237.1837 2017-06-17 00:00:00.0 7.4281 327
31 244.3898 2017-06-18 00:00:00.0 7.2061 327
32 252.3000 2017-06-19 00:00:00.0 7.9102 327
33 260.2750 2017-06-20 00:00:00.0 7.9750 327
34 269.4990 2017-06-21 00:00:00.0 9.2240 327
35 277.6623 2017-06-22 00:00:00.0 8.1633 327
36 283.8888 2017-06-23 00:00:00.0 6.2265 327
37 288.0475 2017-06-24 00:00:00.0 4.1587 327
38 293.8225 2017-06-25 00:00:00.0 5.7750 327
39 301.7327 2017-06-26 00:00:00.0 7.9102 327
40 311.6327 2017-06-27 00:00:00.0 9.9000 327
41 321.5914 2017-06-28 00:00:00.0 9.9587 327
42 330.6914 2017-06-29 00:00:00.0 9.1000 327
43 337.1766 2017-07-01 00:00:00.0 6.4852 327
44 340.6618 2017-07-02 00:00:00.0 3.4852 327
45 348.6368 2017-07-05 00:00:00.0 7.9750 327
46 358.6257 2017-07-06 00:00:00.0 9.9889 327
47 368.3788 2017-07-07 00:00:00.0 9.7531 327
48 378.3677 2017-07-08 00:00:00.0 9.9889 327
49 388.3628 2017-07-09 00:00:00.0 9.9951 327
50 398.2628 2017-07-10 00:00:00.0 9.9000 327
51 408.1628 2017-07-11 00:00:00.0 9.9000 327
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '327') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/11/2017 10 408
7/10/2017 10 398
7/9/2017 10 388
7/8/2017 10 378
7/7/2017 10 368
7/6/2017 10 359
7/5/2017 8 349
7/2/2017 3 341
7/1/2017 6 337
6/29/2017 9 331
6/28/2017 10 322
6/27/2017 10 312
6/26/2017 8 302
6/25/2017 6 294
6/24/2017 4 288
6/23/2017 6 284
6/22/2017 8 278
6/21/2017 9 269
6/20/2017 8 260
6/19/2017 8 252
6/18/2017 7 244
6/17/2017 7 237
6/16/2017 8 230
6/15/2017 8 222
6/14/2017 8 214
6/13/2017 9 206
6/12/2017 9 197
6/11/2017 9 188
6/10/2017 10 179
6/9/2017 9 170
6/8/2017 10 161
6/7/2017 9 151
6/6/2017 10 141
6/5/2017 10 132
6/4/2017 10 122
6/3/2017 10 112
6/2/2017 9 102
6/1/2017 10 93
5/31/2017 9 83
5/30/2017 7 75
5/29/2017 2 68
5/28/2017 5 66
5/27/2017 8 61
5/26/2017 8 53
5/25/2017 8 45
5/24/2017 8 37
5/23/2017 8 29
5/22/2017 4 21
5/21/2017 2 17
5/20/2017 6 15
5/19/2017 9 9