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 244
2 16.5449 2017-05-16 00:00:00.0 7.2061 244
3 18.5730 2017-05-17 00:00:00.0 2.0281 244
4 19.9506 2017-05-18 00:00:00.0 1.3776 244
5 24.3256 2017-05-19 00:00:00.0 4.3750 244
6 28.5929 2017-05-20 00:00:00.0 4.2673 244
7 29.7031 2017-05-21 00:00:00.0 1.1102 244
8 33.0725 2017-05-22 00:00:00.0 3.3694 244
9 40.1256 2017-05-23 00:00:00.0 7.0531 244
10 48.1006 2017-05-24 00:00:00.0 7.9750 244
11 56.1394 2017-05-25 00:00:00.0 8.0388 244
12 64.1144 2017-05-26 00:00:00.0 7.9750 244
13 72.3981 2017-05-27 00:00:00.0 8.2837 244
14 78.3568 2017-05-28 00:00:00.0 5.9587 244
15 81.3726 2017-05-29 00:00:00.0 3.0158 244
16 87.5109 2017-05-30 00:00:00.0 6.1383 244
17 96.7742 2017-05-31 00:00:00.0 9.2633 244
18 103.9298 2017-06-01 00:00:00.0 7.1556 244
19 112.5026 2017-06-02 00:00:00.0 8.5728 244
20 122.0088 2017-06-03 00:00:00.0 9.5062 244
21 131.9675 2017-06-04 00:00:00.0 9.9587 244
22 141.9070 2017-06-05 00:00:00.0 9.9395 244
23 151.6984 2017-06-06 00:00:00.0 9.7914 244
24 161.6249 2017-06-07 00:00:00.0 9.9265 244
25 171.6244 2017-06-08 00:00:00.0 9.9995 244
26 181.5509 2017-06-09 00:00:00.0 9.9265 244
27 191.5096 2017-06-10 00:00:00.0 9.9587 244
28 201.5076 2017-06-11 00:00:00.0 9.9980 244
29 210.9520 2017-06-12 00:00:00.0 9.4444 244
30 220.1760 2017-06-13 00:00:00.0 9.2240 244
31 229.8311 2017-06-14 00:00:00.0 9.6551 244
32 239.0148 2017-06-15 00:00:00.0 9.1837 244
33 248.4250 2017-06-16 00:00:00.0 9.4102 244
34 256.7673 2017-06-17 00:00:00.0 8.3423 244
35 264.3382 2017-06-18 00:00:00.0 7.5709 244
36 272.8504 2017-06-19 00:00:00.0 8.5122 244
37 281.7234 2017-06-20 00:00:00.0 8.8730 244
38 291.0984 2017-06-21 00:00:00.0 9.3750 244
39 300.1106 2017-06-22 00:00:00.0 9.0122 244
40 307.8882 2017-06-23 00:00:00.0 7.7776 244
41 312.3698 2017-06-24 00:00:00.0 4.4816 244
42 318.3285 2017-06-25 00:00:00.0 5.9587 244
43 326.8953 2017-06-26 00:00:00.0 8.5668 244
44 336.7111 2017-06-27 00:00:00.0 9.8158 244
45 346.2208 2017-06-28 00:00:00.0 9.5097 244
46 355.6652 2017-06-29 00:00:00.0 9.4444 244
47 364.6320 2017-06-30 00:00:00.0 8.9668 244
48 373.4070 2017-07-01 00:00:00.0 8.7750 244
49 382.3274 2017-07-02 00:00:00.0 8.9204 244
50 392.3146 2017-07-03 00:00:00.0 9.9872 244
51 401.2763 2017-07-04 00:00:00.0 8.9617 244
52 410.7319 2017-07-05 00:00:00.0 9.4556 244
53 420.4159 2017-07-06 00:00:00.0 9.6840 244
54 430.2118 2017-07-07 00:00:00.0 9.7959 244
55 440.1920 2017-07-08 00:00:00.0 9.9802 244
56 450.0685 2017-07-09 00:00:00.0 9.8765 244
57 460.0376 2017-07-10 00:00:00.0 9.9691 244
58 470.0364 2017-07-11 00:00:00.0 9.9988 244
59 478.9094 2017-07-12 00:00:00.0 8.8730 244
60 488.0931 2017-07-13 00:00:00.0 9.1837 244
61 498.0196 2017-07-14 00:00:00.0 9.9265 244
62 508.0191 2017-07-15 00:00:00.0 9.9995 244
63 517.9574 2017-07-16 00:00:00.0 9.9383 244
64 527.7796 2017-07-17 00:00:00.0 9.8222 244
65 537.5755 2017-07-18 00:00:00.0 9.7959 244
66 546.7592 2017-07-19 00:00:00.0 9.1837 244
67 556.6730 2017-07-20 00:00:00.0 9.9138 244
68 566.6619 2017-07-21 00:00:00.0 9.9889 244
69 576.4369 2017-07-22 00:00:00.0 9.7750 244
70 586.3956 2017-07-23 00:00:00.0 9.9587 244
71 596.3166 2017-07-24 00:00:00.0 9.9210 244
72 606.2968 2017-07-25 00:00:00.0 9.9802 244
73 616.2963 2017-07-26 00:00:00.0 9.9995 244
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '244') 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 616
7/25/2017 10 606
7/24/2017 10 596
7/23/2017 10 586
7/22/2017 10 576
7/21/2017 10 567
7/20/2017 10 557
7/19/2017 9 547
7/18/2017 10 538
7/17/2017 10 528
7/16/2017 10 518
7/15/2017 10 508
7/14/2017 10 498
7/13/2017 9 488
7/12/2017 9 479
7/11/2017 10 470
7/10/2017 10 460
7/9/2017 10 450
7/8/2017 10 440
7/7/2017 10 430
7/6/2017 10 420
7/5/2017 9 411
7/4/2017 9 401
7/3/2017 10 392
7/2/2017 9 382
7/1/2017 9 373
6/30/2017 9 365
6/29/2017 9 356
6/28/2017 10 346
6/27/2017 10 337
6/26/2017 9 327
6/25/2017 6 318
6/24/2017 4 312
6/23/2017 8 308
6/22/2017 9 300
6/21/2017 9 291
6/20/2017 9 282
6/19/2017 9 273
6/18/2017 8 264
6/17/2017 8 257
6/16/2017 9 248
6/15/2017 9 239
6/14/2017 10 230
6/13/2017 9 220
6/12/2017 9 211
6/11/2017 10 202
6/10/2017 10 192
6/9/2017 10 182
6/8/2017 10 172
6/7/2017 10 162
6/6/2017 10 152
6/5/2017 10 142
6/4/2017 10 132
6/3/2017 10 122
6/2/2017 9 113
6/1/2017 7 104
5/31/2017 9 97
5/30/2017 6 88
5/29/2017 3 81
5/28/2017 6 78
5/27/2017 8 72
5/26/2017 8 64
5/25/2017 8 56
5/24/2017 8 48
5/23/2017 7 40
5/22/2017 3 33
5/21/2017 1 30
5/20/2017 4 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