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.9750 2017-05-15 00:00:00.0 7.9750 204
2 14.5444 2017-05-16 00:00:00.0 6.5694 204
3 14.5444 2017-05-17 00:00:00.0 0.0000 204
4 14.5444 2017-05-18 00:00:00.0 0.0000 204
5 16.5725 2017-05-19 00:00:00.0 2.0281 204
6 21.8705 2017-05-20 00:00:00.0 5.2980 204
7 24.8863 2017-05-21 00:00:00.0 3.0158 204
8 30.6613 2017-05-22 00:00:00.0 5.7750 204
9 37.8674 2017-05-23 00:00:00.0 7.2061 204
10 46.0914 2017-05-24 00:00:00.0 8.2240 204
11 53.2215 2017-05-25 00:00:00.0 7.1301 204
12 60.1174 2017-05-26 00:00:00.0 6.8959 204
13 67.7582 2017-05-27 00:00:00.0 7.6408 204
14 72.3454 2017-05-28 00:00:00.0 4.5872 204
15 74.8755 2017-05-29 00:00:00.0 2.5301 204
16 81.3607 2017-05-30 00:00:00.0 6.4852 204
17 90.0852 2017-05-31 00:00:00.0 8.7245 204
18 97.9074 2017-06-01 00:00:00.0 7.8222 204
19 107.4136 2017-06-02 00:00:00.0 9.5062 204
20 117.4116 2017-06-03 00:00:00.0 9.9980 204
21 126.8892 2017-06-04 00:00:00.0 9.4776 204
22 136.8157 2017-06-05 00:00:00.0 9.9265 204
23 146.7295 2017-06-06 00:00:00.0 9.9138 204
24 156.0683 2017-06-07 00:00:00.0 9.3388 204
25 165.7744 2017-06-08 00:00:00.0 9.7061 204
26 174.9167 2017-06-09 00:00:00.0 9.1423 204
27 184.3611 2017-06-10 00:00:00.0 9.4444 204
28 193.2341 2017-06-11 00:00:00.0 8.8730 204
29 201.6341 2017-06-12 00:00:00.0 8.4000 204
30 209.9178 2017-06-13 00:00:00.0 8.2837 204
31 218.7908 2017-06-14 00:00:00.0 8.8730 204
32 227.1331 2017-06-15 00:00:00.0 8.3423 204
33 234.6331 2017-06-16 00:00:00.0 7.5000 204
34 241.6862 2017-06-17 00:00:00.0 7.0531 204
35 248.8163 2017-06-18 00:00:00.0 7.1301 204
36 256.1714 2017-06-19 00:00:00.0 7.3551 204
37 264.5137 2017-06-20 00:00:00.0 8.3423 204
38 273.3382 2017-06-21 00:00:00.0 8.8245 204
39 281.2484 2017-06-22 00:00:00.0 7.9102 204
40 287.8178 2017-06-23 00:00:00.0 6.5694 204
41 292.7158 2017-06-24 00:00:00.0 4.8980 204
42 298.7648 2017-06-25 00:00:00.0 6.0490 204
43 307.1071 2017-06-26 00:00:00.0 8.3423 204
44 316.9597 2017-06-27 00:00:00.0 9.8526 204
45 326.9184 2017-06-28 00:00:00.0 9.9587 204
46 336.2199 2017-06-29 00:00:00.0 9.3015 204
47 344.6765 2017-06-30 00:00:00.0 8.4566 204
48 353.5010 2017-07-01 00:00:00.0 8.8245 204
49 361.7847 2017-07-02 00:00:00.0 8.2837 204
50 371.7520 2017-07-03 00:00:00.0 9.9673 204
51 381.6520 2017-07-04 00:00:00.0 9.9000 204
52 391.6076 2017-07-05 00:00:00.0 9.9556 204
53 401.5632 2017-07-06 00:00:00.0 9.9556 204
54 411.3163 2017-07-07 00:00:00.0 9.7531 204
55 421.3052 2017-07-08 00:00:00.0 9.9889 204
56 431.2725 2017-07-09 00:00:00.0 9.9673 204
57 441.2597 2017-07-10 00:00:00.0 9.9872 204
58 450.8878 2017-07-11 00:00:00.0 9.6281 204
59 460.1511 2017-07-12 00:00:00.0 9.2633 204
60 469.5261 2017-07-13 00:00:00.0 9.3750 204
61 479.5150 2017-07-14 00:00:00.0 9.9889 204
62 489.4900 2017-07-15 00:00:00.0 9.9750 204
63 499.4390 2017-07-16 00:00:00.0 9.9490 204
64 508.8946 2017-07-17 00:00:00.0 9.4556 204
65 518.2334 2017-07-18 00:00:00.0 9.3388 204
66 527.8334 2017-07-19 00:00:00.0 9.6000 204
67 537.4334 2017-07-20 00:00:00.0 9.6000 204
68 547.2293 2017-07-21 00:00:00.0 9.7959 204
69 556.7701 2017-07-22 00:00:00.0 9.5408 204
70 566.6701 2017-07-23 00:00:00.0 9.9000 204
71 576.4281 2017-07-24 00:00:00.0 9.7580 204
72 586.3954 2017-07-25 00:00:00.0 9.9673 204
73 596.3905 2017-07-26 00:00:00.0 9.9951 204
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '204') 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 596
7/25/2017 10 586
7/24/2017 10 576
7/23/2017 10 567
7/22/2017 10 557
7/21/2017 10 547
7/20/2017 10 537
7/19/2017 10 528
7/18/2017 9 518
7/17/2017 9 509
7/16/2017 10 499
7/15/2017 10 489
7/14/2017 10 480
7/13/2017 9 470
7/12/2017 9 460
7/11/2017 10 451
7/10/2017 10 441
7/9/2017 10 431
7/8/2017 10 421
7/7/2017 10 411
7/6/2017 10 402
7/5/2017 10 392
7/4/2017 10 382
7/3/2017 10 372
7/2/2017 8 362
7/1/2017 9 354
6/30/2017 8 345
6/29/2017 9 336
6/28/2017 10 327
6/27/2017 10 317
6/26/2017 8 307
6/25/2017 6 299
6/24/2017 5 293
6/23/2017 7 288
6/22/2017 8 281
6/21/2017 9 273
6/20/2017 8 265
6/19/2017 7 256
6/18/2017 7 249
6/17/2017 7 242
6/16/2017 8 235
6/15/2017 8 227
6/14/2017 9 219
6/13/2017 8 210
6/12/2017 8 202
6/11/2017 9 193
6/10/2017 9 184
6/9/2017 9 175
6/8/2017 10 166
6/7/2017 9 156
6/6/2017 10 147
6/5/2017 10 137
6/4/2017 9 127
6/3/2017 10 117
6/2/2017 10 107
6/1/2017 8 98
5/31/2017 9 90
5/30/2017 6 81
5/29/2017 3 75
5/28/2017 5 72
5/27/2017 8 68
5/26/2017 7 60
5/25/2017 7 53
5/24/2017 8 46
5/23/2017 7 38
5/22/2017 6 31
5/21/2017 3 25
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