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 8.2240 2017-05-25 00:00:00.0 8.2240 362
2 16.4480 2017-05-26 00:00:00.0 8.2240 362
3 24.8480 2017-05-27 00:00:00.0 8.4000 362
4 30.0475 2017-05-28 00:00:00.0 5.1995 362
5 32.2026 2017-05-29 00:00:00.0 2.1551 362
6 38.8552 2017-05-30 00:00:00.0 6.6526 362
7 47.9975 2017-05-31 00:00:00.0 9.1423 362
8 57.9370 2017-06-01 00:00:00.0 9.9395 362
9 66.5926 2017-06-02 00:00:00.0 8.6556 362
10 76.4691 2017-06-03 00:00:00.0 9.8765 362
11 86.1502 2017-06-04 00:00:00.0 9.6811 362
12 96.1304 2017-06-05 00:00:00.0 9.9802 362
13 105.6401 2017-06-06 00:00:00.0 9.5097 362
14 115.2110 2017-06-07 00:00:00.0 9.5709 362
15 125.1110 2017-06-08 00:00:00.0 9.9000 362
16 134.1676 2017-06-09 00:00:00.0 9.0566 362
17 143.7957 2017-06-10 00:00:00.0 9.6281 362
18 152.9380 2017-06-11 00:00:00.0 9.1423 362
19 161.7625 2017-06-12 00:00:00.0 8.8245 362
20 170.5375 2017-06-13 00:00:00.0 8.7750 362
21 178.2472 2017-06-14 00:00:00.0 7.7097 362
22 185.9569 2017-06-15 00:00:00.0 7.7097 362
23 194.1202 2017-06-16 00:00:00.0 8.1633 362
24 201.5483 2017-06-17 00:00:00.0 7.4281 362
25 208.7544 2017-06-18 00:00:00.0 7.2061 362
26 216.6646 2017-06-19 00:00:00.0 7.9102 362
27 224.7034 2017-06-20 00:00:00.0 8.0388 362
28 233.9274 2017-06-21 00:00:00.0 9.2240 362
29 241.6371 2017-06-22 00:00:00.0 7.7097 362
30 247.0325 2017-06-23 00:00:00.0 5.3954 362
31 251.0815 2017-06-24 00:00:00.0 4.0490 362
32 257.0402 2017-06-25 00:00:00.0 5.9587 362
33 264.9504 2017-06-26 00:00:00.0 7.9102 362
34 274.7662 2017-06-27 00:00:00.0 9.8158 362
35 284.6356 2017-06-28 00:00:00.0 9.8694 362
36 293.6024 2017-06-29 00:00:00.0 8.9668 362
37 301.9447 2017-06-30 00:00:00.0 8.3423 362
38 311.0013 2017-07-01 00:00:00.0 9.0566 362
39 319.6217 2017-07-02 00:00:00.0 8.6204 362
40 329.6019 2017-07-03 00:00:00.0 9.9802 362
41 339.5019 2017-07-04 00:00:00.0 9.9000 362
42 349.5007 2017-07-05 00:00:00.0 9.9988 362
43 359.4594 2017-07-06 00:00:00.0 9.9587 362
44 369.2553 2017-07-07 00:00:00.0 9.7959 362
45 379.2541 2017-07-08 00:00:00.0 9.9988 362
46 389.2529 2017-07-09 00:00:00.0 9.9988 362
47 399.1924 2017-07-10 00:00:00.0 9.9395 362
48 408.8475 2017-07-11 00:00:00.0 9.6551 362
49 418.1490 2017-07-12 00:00:00.0 9.3015 362
50 427.4878 2017-07-13 00:00:00.0 9.3388 362
51 437.4551 2017-07-14 00:00:00.0 9.9673 362
52 447.3816 2017-07-15 00:00:00.0 9.9265 362
53 457.3199 2017-07-16 00:00:00.0 9.9383 362
54 467.2786 2017-07-17 00:00:00.0 9.9587 362
55 475.9516 2017-07-18 00:00:00.0 8.6730 362
56 485.3618 2017-07-19 00:00:00.0 9.4102 362
57 495.0919 2017-07-20 00:00:00.0 9.7301 362
58 505.0735 2017-07-21 00:00:00.0 9.9816 362
59 514.2975 2017-07-22 00:00:00.0 9.2240 362
60 524.0934 2017-07-23 00:00:00.0 9.7959 362
61 533.9156 2017-07-24 00:00:00.0 9.8222 362
62 543.2171 2017-07-25 00:00:00.0 9.3015 362
63 553.2043 2017-07-26 00:00:00.0 9.9872 362
64 563.1994 2017-07-27 00:00:00.0 9.9951 362
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '362') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/27/2017 10 563
7/26/2017 10 553
7/25/2017 9 543
7/24/2017 10 534
7/23/2017 10 524
7/22/2017 9 514
7/21/2017 10 505
7/20/2017 10 495
7/19/2017 9 485
7/18/2017 9 476
7/17/2017 10 467
7/16/2017 10 457
7/15/2017 10 447
7/14/2017 10 437
7/13/2017 9 427
7/12/2017 9 418
7/11/2017 10 409
7/10/2017 10 399
7/9/2017 10 389
7/8/2017 10 379
7/7/2017 10 369
7/6/2017 10 359
7/5/2017 10 350
7/4/2017 10 340
7/3/2017 10 330
7/2/2017 9 320
7/1/2017 9 311
6/30/2017 8 302
6/29/2017 9 294
6/28/2017 10 285
6/27/2017 10 275
6/26/2017 8 265
6/25/2017 6 257
6/24/2017 4 251
6/23/2017 5 247
6/22/2017 8 242
6/21/2017 9 234
6/20/2017 8 225
6/19/2017 8 217
6/18/2017 7 209
6/17/2017 7 202
6/16/2017 8 194
6/15/2017 8 186
6/14/2017 8 178
6/13/2017 9 171
6/12/2017 9 162
6/11/2017 9 153
6/10/2017 10 144
6/9/2017 9 134
6/8/2017 10 125
6/7/2017 10 115
6/6/2017 10 106
6/5/2017 10 96
6/4/2017 10 86
6/3/2017 10 76
6/2/2017 9 67
6/1/2017 10 58
5/31/2017 9 48
5/30/2017 7 39
5/29/2017 2 32
5/28/2017 5 30
5/27/2017 8 25
5/26/2017 8 16
5/25/2017 8 8