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.1423 2017-05-15 00:00:00.0 9.1423 223
2 15.1913 2017-05-16 00:00:00.0 6.0490 223
3 17.2194 2017-05-17 00:00:00.0 2.0281 223
4 17.5031 2017-05-18 00:00:00.0 0.2837 223
5 21.7704 2017-05-19 00:00:00.0 4.2673 223
6 26.7699 2017-05-20 00:00:00.0 4.9995 223
7 27.6087 2017-05-21 00:00:00.0 0.8388 223
8 30.0148 2017-05-22 00:00:00.0 2.4061 223
9 37.1449 2017-05-23 00:00:00.0 7.1301 223
10 45.2464 2017-05-24 00:00:00.0 8.1015 223
11 53.1566 2017-05-25 00:00:00.0 7.9102 223
12 61.9811 2017-05-26 00:00:00.0 8.8245 223
13 70.6015 2017-05-27 00:00:00.0 8.6204 223
14 75.4995 2017-05-28 00:00:00.0 4.8980 223
15 77.0092 2017-05-29 00:00:00.0 1.5097 223
16 82.2087 2017-05-30 00:00:00.0 5.1995 223
17 90.4327 2017-05-31 00:00:00.0 8.2240 223
18 98.9204 2017-06-01 00:00:00.0 8.4877 223
19 107.6562 2017-06-02 00:00:00.0 8.7358 223
20 117.2994 2017-06-03 00:00:00.0 9.6432 223
21 127.1520 2017-06-04 00:00:00.0 9.8526 223
22 137.1508 2017-06-05 00:00:00.0 9.9988 223
23 146.7508 2017-06-06 00:00:00.0 9.6000 223
24 156.6360 2017-06-07 00:00:00.0 9.8852 223
25 166.6176 2017-06-08 00:00:00.0 9.9816 223
26 176.5176 2017-06-09 00:00:00.0 9.9000 223
27 186.4176 2017-06-10 00:00:00.0 9.9000 223
28 196.3763 2017-06-11 00:00:00.0 9.9587 223
29 205.6396 2017-06-12 00:00:00.0 9.2633 223
30 214.6962 2017-06-13 00:00:00.0 9.0566 223
31 224.3773 2017-06-14 00:00:00.0 9.6811 223
32 232.9441 2017-06-15 00:00:00.0 8.5668 223
33 241.3441 2017-06-16 00:00:00.0 8.4000 223
34 248.5502 2017-06-17 00:00:00.0 7.2061 223
35 255.8313 2017-06-18 00:00:00.0 7.2811 223
36 263.6757 2017-06-19 00:00:00.0 7.8444 223
37 272.5961 2017-06-20 00:00:00.0 8.9204 223
38 281.1083 2017-06-21 00:00:00.0 8.5122 223
39 289.7813 2017-06-22 00:00:00.0 8.6730 223
40 296.5971 2017-06-23 00:00:00.0 6.8158 223
41 301.1843 2017-06-24 00:00:00.0 4.5872 223
42 306.7715 2017-06-25 00:00:00.0 5.5872 223
43 315.2281 2017-06-26 00:00:00.0 8.4566 223
44 324.9342 2017-06-27 00:00:00.0 9.7061 223
45 334.3444 2017-06-28 00:00:00.0 9.4102 223
46 343.9153 2017-06-29 00:00:00.0 9.5709 223
47 352.7883 2017-06-30 00:00:00.0 8.8730 223
48 361.4613 2017-07-01 00:00:00.0 8.6730 223
49 370.2858 2017-07-02 00:00:00.0 8.8245 223
50 380.1710 2017-07-03 00:00:00.0 9.8852 223
51 389.6266 2017-07-04 00:00:00.0 9.4556 223
52 399.1809 2017-07-05 00:00:00.0 9.5543 223
53 409.1611 2017-07-06 00:00:00.0 9.9802 223
54 418.9769 2017-07-07 00:00:00.0 9.8158 223
55 428.9749 2017-07-08 00:00:00.0 9.9980 223
56 438.9729 2017-07-09 00:00:00.0 9.9980 223
57 448.9683 2017-07-10 00:00:00.0 9.9954 223
58 458.8030 2017-07-11 00:00:00.0 9.8347 223
59 467.5275 2017-07-12 00:00:00.0 8.7245 223
60 476.6698 2017-07-13 00:00:00.0 9.1423 223
61 486.5392 2017-07-14 00:00:00.0 9.8694 223
62 496.4979 2017-07-15 00:00:00.0 9.9587 223
63 506.4117 2017-07-16 00:00:00.0 9.9138 223
64 515.9660 2017-07-17 00:00:00.0 9.5543 223
65 525.6961 2017-07-18 00:00:00.0 9.7301 223
66 535.0349 2017-07-19 00:00:00.0 9.3388 223
67 544.8507 2017-07-20 00:00:00.0 9.8158 223
68 554.7772 2017-07-21 00:00:00.0 9.9265 223
69 564.3772 2017-07-22 00:00:00.0 9.6000 223
70 574.3155 2017-07-23 00:00:00.0 9.9383 223
71 584.1920 2017-07-24 00:00:00.0 9.8765 223
72 594.1871 2017-07-25 00:00:00.0 9.9951 223
73 604.1871 2017-07-26 00:00:00.0 10.0000 223
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '223') 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 604
7/25/2017 10 594
7/24/2017 10 584
7/23/2017 10 574
7/22/2017 10 564
7/21/2017 10 555
7/20/2017 10 545
7/19/2017 9 535
7/18/2017 10 526
7/17/2017 10 516
7/16/2017 10 506
7/15/2017 10 496
7/14/2017 10 487
7/13/2017 9 477
7/12/2017 9 468
7/11/2017 10 459
7/10/2017 10 449
7/9/2017 10 439
7/8/2017 10 429
7/7/2017 10 419
7/6/2017 10 409
7/5/2017 10 399
7/4/2017 9 390
7/3/2017 10 380
7/2/2017 9 370
7/1/2017 9 361
6/30/2017 9 353
6/29/2017 10 344
6/28/2017 9 334
6/27/2017 10 325
6/26/2017 8 315
6/25/2017 6 307
6/24/2017 5 301
6/23/2017 7 297
6/22/2017 9 290
6/21/2017 9 281
6/20/2017 9 273
6/19/2017 8 264
6/18/2017 7 256
6/17/2017 7 249
6/16/2017 8 241
6/15/2017 9 233
6/14/2017 10 224
6/13/2017 9 215
6/12/2017 9 206
6/11/2017 10 196
6/10/2017 10 186
6/9/2017 10 177
6/8/2017 10 167
6/7/2017 10 157
6/6/2017 10 147
6/5/2017 10 137
6/4/2017 10 127
6/3/2017 10 117
6/2/2017 9 108
6/1/2017 8 99
5/31/2017 8 90
5/30/2017 5 82
5/29/2017 2 77
5/28/2017 5 75
5/27/2017 9 71
5/26/2017 9 62
5/25/2017 8 53
5/24/2017 8 45
5/23/2017 7 37
5/22/2017 2 30
5/21/2017 1 28
5/20/2017 5 27
5/19/2017 4 22
5/18/2017 0 18
5/17/2017 2 17
5/16/2017 6 15
5/15/2017 9 9