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.4444 2017-05-15 00:00:00.0 9.4444 230
2 16.7995 2017-05-16 00:00:00.0 7.3551 230
3 18.9546 2017-05-17 00:00:00.0 2.1551 230
4 20.1990 2017-05-18 00:00:00.0 1.2444 230
5 24.3577 2017-05-19 00:00:00.0 4.1587 230
6 29.1531 2017-05-20 00:00:00.0 4.7954 230
7 30.3975 2017-05-21 00:00:00.0 1.2444 230
8 33.9975 2017-05-22 00:00:00.0 3.6000 230
9 40.9725 2017-05-23 00:00:00.0 6.9750 230
10 48.9475 2017-05-24 00:00:00.0 7.9750 230
11 56.8577 2017-05-25 00:00:00.0 7.9102 230
12 64.7679 2017-05-26 00:00:00.0 7.9102 230
13 73.2801 2017-05-27 00:00:00.0 8.5122 230
14 79.2388 2017-05-28 00:00:00.0 5.9587 230
15 82.6082 2017-05-29 00:00:00.0 3.3694 230
16 88.8347 2017-05-30 00:00:00.0 6.2265 230
17 98.0980 2017-05-31 00:00:00.0 9.2633 230
18 108.0980 2017-06-01 00:00:00.0 10.0000 230
19 116.5857 2017-06-02 00:00:00.0 8.4877 230
20 126.2289 2017-06-03 00:00:00.0 9.6432 230
21 136.2178 2017-06-04 00:00:00.0 9.9889 230
22 146.1178 2017-06-05 00:00:00.0 9.9000 230
23 156.0178 2017-06-06 00:00:00.0 9.9000 230
24 165.7709 2017-06-07 00:00:00.0 9.7531 230
25 175.7709 2017-06-08 00:00:00.0 10.0000 230
26 185.5010 2017-06-09 00:00:00.0 9.7301 230
27 195.4010 2017-06-10 00:00:00.0 9.9000 230
28 205.3597 2017-06-11 00:00:00.0 9.9587 230
29 214.8041 2017-06-12 00:00:00.0 9.4444 230
30 223.6771 2017-06-13 00:00:00.0 8.8730 230
31 233.0159 2017-06-14 00:00:00.0 9.3388 230
32 241.9363 2017-06-15 00:00:00.0 8.9204 230
33 251.2751 2017-06-16 00:00:00.0 9.3388 230
34 259.3766 2017-06-17 00:00:00.0 8.1015 230
35 267.0863 2017-06-18 00:00:00.0 7.7097 230
36 275.3700 2017-06-19 00:00:00.0 8.2837 230
37 283.9368 2017-06-20 00:00:00.0 8.5668 230
38 293.2756 2017-06-21 00:00:00.0 9.3388 230
39 302.1960 2017-06-22 00:00:00.0 8.9204 230
40 309.8368 2017-06-23 00:00:00.0 7.6408 230
41 314.3184 2017-06-24 00:00:00.0 4.4816 230
42 320.0934 2017-06-25 00:00:00.0 5.7750 230
43 328.7664 2017-06-26 00:00:00.0 8.6730 230
44 338.6802 2017-06-27 00:00:00.0 9.9138 230
45 348.4960 2017-06-28 00:00:00.0 9.8158 230
46 357.7975 2017-06-29 00:00:00.0 9.3015 230
47 366.6220 2017-06-30 00:00:00.0 8.8245 230
48 375.4465 2017-07-01 00:00:00.0 8.8245 230
49 384.2215 2017-07-02 00:00:00.0 8.7750 230
50 394.1598 2017-07-03 00:00:00.0 9.9383 230
51 403.1919 2017-07-04 00:00:00.0 9.0321 230
52 412.6475 2017-07-05 00:00:00.0 9.4556 230
53 422.3315 2017-07-06 00:00:00.0 9.6840 230
54 432.1065 2017-07-07 00:00:00.0 9.7750 230
55 442.0460 2017-07-08 00:00:00.0 9.9395 230
56 451.9855 2017-07-09 00:00:00.0 9.9395 230
57 461.9843 2017-07-10 00:00:00.0 9.9988 230
58 471.9732 2017-07-11 00:00:00.0 9.9889 230
59 480.4854 2017-07-12 00:00:00.0 8.5122 230
60 489.4976 2017-07-13 00:00:00.0 9.0122 230
61 499.4848 2017-07-14 00:00:00.0 9.9872 230
62 509.4802 2017-07-15 00:00:00.0 9.9954 230
63 519.3496 2017-07-16 00:00:00.0 9.8694 230
64 529.1410 2017-07-17 00:00:00.0 9.7914 230
65 538.7961 2017-07-18 00:00:00.0 9.6551 230
66 547.8083 2017-07-19 00:00:00.0 9.0122 230
67 557.6430 2017-07-20 00:00:00.0 9.8347 230
68 567.6302 2017-07-21 00:00:00.0 9.9872 230
69 577.3113 2017-07-22 00:00:00.0 9.6811 230
70 587.2496 2017-07-23 00:00:00.0 9.9383 230
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '230') 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 587
7/22/2017 10 577
7/21/2017 10 568
7/20/2017 10 558
7/19/2017 9 548
7/18/2017 10 539
7/17/2017 10 529
7/16/2017 10 519
7/15/2017 10 509
7/14/2017 10 499
7/13/2017 9 489
7/12/2017 9 480
7/11/2017 10 472
7/10/2017 10 462
7/9/2017 10 452
7/8/2017 10 442
7/7/2017 10 432
7/6/2017 10 422
7/5/2017 9 413
7/4/2017 9 403
7/3/2017 10 394
7/2/2017 9 384
7/1/2017 9 375
6/30/2017 9 367
6/29/2017 9 358
6/28/2017 10 348
6/27/2017 10 339
6/26/2017 9 329
6/25/2017 6 320
6/24/2017 4 314
6/23/2017 8 310
6/22/2017 9 302
6/21/2017 9 293
6/20/2017 9 284
6/19/2017 8 275
6/18/2017 8 267
6/17/2017 8 259
6/16/2017 9 251
6/15/2017 9 242
6/14/2017 9 233
6/13/2017 9 224
6/12/2017 9 215
6/11/2017 10 205
6/10/2017 10 195
6/9/2017 10 186
6/8/2017 10 176
6/7/2017 10 166
6/6/2017 10 156
6/5/2017 10 146
6/4/2017 10 136
6/3/2017 10 126
6/2/2017 8 117
6/1/2017 10 108
5/31/2017 9 98
5/30/2017 6 89
5/29/2017 3 83
5/28/2017 6 79
5/27/2017 9 73
5/26/2017 8 65
5/25/2017 8 57
5/24/2017 8 49
5/23/2017 7 41
5/22/2017 4 34
5/21/2017 1 30
5/20/2017 5 29
5/19/2017 4 24
5/18/2017 1 20
5/17/2017 2 19
5/16/2017 7 17
5/15/2017 9 9