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.3388 2017-05-15 00:00:00.0 9.3388 237
2 17.0485 2017-05-16 00:00:00.0 7.7097 237
3 18.5582 2017-05-17 00:00:00.0 1.5097 237
4 18.8419 2017-05-18 00:00:00.0 0.2837 237
5 23.2169 2017-05-19 00:00:00.0 4.3750 237
6 29.1756 2017-05-20 00:00:00.0 5.9587 237
7 31.5817 2017-05-21 00:00:00.0 2.4061 237
8 35.5200 2017-05-22 00:00:00.0 3.9383 237
9 42.9481 2017-05-23 00:00:00.0 7.4281 237
10 51.1114 2017-05-24 00:00:00.0 8.1633 237
11 58.7522 2017-05-25 00:00:00.0 7.6408 237
12 66.7910 2017-05-26 00:00:00.0 8.0388 237
13 75.3032 2017-05-27 00:00:00.0 8.5122 237
14 80.7950 2017-05-28 00:00:00.0 5.4918 237
15 83.0761 2017-05-29 00:00:00.0 2.2811 237
16 89.4761 2017-05-30 00:00:00.0 6.4000 237
17 98.5761 2017-05-31 00:00:00.0 9.1000 237
18 108.5712 2017-06-01 00:00:00.0 9.9951 237
19 117.3070 2017-06-02 00:00:00.0 8.7358 237
20 127.1576 2017-06-03 00:00:00.0 9.8506 237
21 136.9535 2017-06-04 00:00:00.0 9.7959 237
22 146.9523 2017-06-05 00:00:00.0 9.9988 237
23 156.9523 2017-06-06 00:00:00.0 10.0000 237
24 166.6584 2017-06-07 00:00:00.0 9.7061 237
25 176.6538 2017-06-08 00:00:00.0 9.9954 237
26 186.3349 2017-06-09 00:00:00.0 9.6811 237
27 196.2043 2017-06-10 00:00:00.0 9.8694 237
28 206.0201 2017-06-11 00:00:00.0 9.8158 237
29 215.3216 2017-06-12 00:00:00.0 9.3015 237
30 224.1461 2017-06-13 00:00:00.0 8.8245 237
31 233.5211 2017-06-14 00:00:00.0 9.3750 237
32 242.3941 2017-06-15 00:00:00.0 8.8730 237
33 250.8507 2017-06-16 00:00:00.0 8.4566 237
34 258.4216 2017-06-17 00:00:00.0 7.5709 237
35 265.7027 2017-06-18 00:00:00.0 7.2811 237
36 273.6777 2017-06-19 00:00:00.0 7.9750 237
37 282.4022 2017-06-20 00:00:00.0 8.7245 237
38 290.9690 2017-06-21 00:00:00.0 8.5668 237
39 299.7440 2017-06-22 00:00:00.0 8.7750 237
40 306.8741 2017-06-23 00:00:00.0 7.1301 237
41 311.2491 2017-06-24 00:00:00.0 4.3750 237
42 317.2981 2017-06-25 00:00:00.0 6.0490 237
43 326.3547 2017-06-26 00:00:00.0 9.0566 237
44 336.1506 2017-06-27 00:00:00.0 9.7959 237
45 345.9664 2017-06-28 00:00:00.0 9.8158 237
46 355.2679 2017-06-29 00:00:00.0 9.3015 237
47 364.0429 2017-06-30 00:00:00.0 8.7750 237
48 372.8179 2017-07-01 00:00:00.0 8.7750 237
49 381.8301 2017-07-02 00:00:00.0 9.0122 237
50 391.7566 2017-07-03 00:00:00.0 9.9265 237
51 401.6072 2017-07-04 00:00:00.0 9.8506 237
52 411.1134 2017-07-05 00:00:00.0 9.5062 237
53 421.0529 2017-07-06 00:00:00.0 9.9395 237
54 430.9223 2017-07-07 00:00:00.0 9.8694 237
55 440.7137 2017-07-08 00:00:00.0 9.7914 237
56 450.7125 2017-07-09 00:00:00.0 9.9988 237
57 460.7113 2017-07-10 00:00:00.0 9.9988 237
58 470.5460 2017-07-11 00:00:00.0 9.8347 237
59 479.2705 2017-07-12 00:00:00.0 8.7245 237
60 488.5720 2017-07-13 00:00:00.0 9.3015 237
61 498.5638 2017-07-14 00:00:00.0 9.9918 237
62 508.5618 2017-07-15 00:00:00.0 9.9980 237
63 518.3965 2017-07-16 00:00:00.0 9.8347 237
64 527.6854 2017-07-17 00:00:00.0 9.2889 237
65 537.5012 2017-07-18 00:00:00.0 9.8158 237
66 546.7645 2017-07-19 00:00:00.0 9.2633 237
67 556.5992 2017-07-20 00:00:00.0 9.8347 237
68 566.4844 2017-07-21 00:00:00.0 9.8852 237
69 575.9288 2017-07-22 00:00:00.0 9.4444 237
70 585.8875 2017-07-23 00:00:00.0 9.9587 237
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '237') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/23/2017 10 586
7/22/2017 9 576
7/21/2017 10 566
7/20/2017 10 557
7/19/2017 9 547
7/18/2017 10 538
7/17/2017 9 528
7/16/2017 10 518
7/15/2017 10 509
7/14/2017 10 499
7/13/2017 9 489
7/12/2017 9 479
7/11/2017 10 471
7/10/2017 10 461
7/9/2017 10 451
7/8/2017 10 441
7/7/2017 10 431
7/6/2017 10 421
7/5/2017 10 411
7/4/2017 10 402
7/3/2017 10 392
7/2/2017 9 382
7/1/2017 9 373
6/30/2017 9 364
6/29/2017 9 355
6/28/2017 10 346
6/27/2017 10 336
6/26/2017 9 326
6/25/2017 6 317
6/24/2017 4 311
6/23/2017 7 307
6/22/2017 9 300
6/21/2017 9 291
6/20/2017 9 282
6/19/2017 8 274
6/18/2017 7 266
6/17/2017 8 258
6/16/2017 8 251
6/15/2017 9 242
6/14/2017 9 234
6/13/2017 9 224
6/12/2017 9 215
6/11/2017 10 206
6/10/2017 10 196
6/9/2017 10 186
6/8/2017 10 177
6/7/2017 10 167
6/6/2017 10 157
6/5/2017 10 147
6/4/2017 10 137
6/3/2017 10 127
6/2/2017 9 117
6/1/2017 10 109
5/31/2017 9 99
5/30/2017 6 89
5/29/2017 2 83
5/28/2017 5 81
5/27/2017 9 75
5/26/2017 8 67
5/25/2017 8 59
5/24/2017 8 51
5/23/2017 7 43
5/22/2017 4 36
5/21/2017 2 32
5/20/2017 6 29
5/19/2017 4 23
5/18/2017 0 19
5/17/2017 2 19
5/16/2017 8 17
5/15/2017 9 9