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.8730 2017-05-15 00:00:00.0 8.8730 325
2 16.7832 2017-05-16 00:00:00.0 7.9102 325
3 17.3465 2017-05-17 00:00:00.0 0.5633 325
4 17.3465 2017-05-18 00:00:00.0 0.0000 325
5 21.5052 2017-05-19 00:00:00.0 4.1587 325
6 28.1578 2017-05-20 00:00:00.0 6.6526 325
7 31.4104 2017-05-21 00:00:00.0 3.2526 325
8 36.6099 2017-05-22 00:00:00.0 5.1995 325
9 44.0380 2017-05-23 00:00:00.0 7.4281 325
10 52.4946 2017-05-24 00:00:00.0 8.4566 325
11 59.6247 2017-05-25 00:00:00.0 7.1301 325
12 67.8487 2017-05-26 00:00:00.0 8.2240 325
13 76.1910 2017-05-27 00:00:00.0 8.3423 325
14 81.3905 2017-05-28 00:00:00.0 5.1995 325
15 83.5456 2017-05-29 00:00:00.0 2.1551 325
16 89.8594 2017-05-30 00:00:00.0 6.3138 325
17 98.6839 2017-05-31 00:00:00.0 8.8245 325
18 108.6530 2017-06-01 00:00:00.0 9.9691 325
19 117.3086 2017-06-02 00:00:00.0 8.6556 325
20 127.2086 2017-06-03 00:00:00.0 9.9000 325
21 136.8086 2017-06-04 00:00:00.0 9.6000 325
22 146.6851 2017-06-05 00:00:00.0 9.8765 325
23 156.5851 2017-06-06 00:00:00.0 9.9000 325
24 166.0627 2017-06-07 00:00:00.0 9.4776 325
25 176.0581 2017-06-08 00:00:00.0 9.9954 325
26 185.9433 2017-06-09 00:00:00.0 9.8852 325
27 195.7591 2017-06-10 00:00:00.0 9.8158 325
28 205.4142 2017-06-11 00:00:00.0 9.6551 325
29 214.5979 2017-06-12 00:00:00.0 9.1837 325
30 223.8994 2017-06-13 00:00:00.0 9.3015 325
31 233.1234 2017-06-14 00:00:00.0 9.2240 325
32 241.7964 2017-06-15 00:00:00.0 8.6730 325
33 249.5061 2017-06-16 00:00:00.0 7.7097 325
34 256.7872 2017-06-17 00:00:00.0 7.2811 325
35 263.8403 2017-06-18 00:00:00.0 7.0531 325
36 271.2684 2017-06-19 00:00:00.0 7.4281 325
37 279.6107 2017-06-20 00:00:00.0 8.3423 325
38 288.1775 2017-06-21 00:00:00.0 8.5668 325
39 296.6341 2017-06-22 00:00:00.0 8.4566 325
40 303.3688 2017-06-23 00:00:00.0 6.7347 325
41 307.6361 2017-06-24 00:00:00.0 4.2673 325
42 313.3177 2017-06-25 00:00:00.0 5.6816 325
43 321.9907 2017-06-26 00:00:00.0 8.6730 325
44 331.8601 2017-06-27 00:00:00.0 9.8694 325
45 341.6560 2017-06-28 00:00:00.0 9.7959 325
46 350.8397 2017-06-29 00:00:00.0 9.1837 325
47 359.5642 2017-06-30 00:00:00.0 8.7245 325
48 368.2372 2017-07-01 00:00:00.0 8.6730 325
49 376.9102 2017-07-02 00:00:00.0 8.6730 325
50 386.8775 2017-07-03 00:00:00.0 9.9673 325
51 396.8466 2017-07-04 00:00:00.0 9.9691 325
52 406.6972 2017-07-05 00:00:00.0 9.8506 325
53 416.6926 2017-07-06 00:00:00.0 9.9954 325
54 426.3737 2017-07-07 00:00:00.0 9.6811 325
55 436.3717 2017-07-08 00:00:00.0 9.9980 325
56 446.3467 2017-07-09 00:00:00.0 9.9750 325
57 456.3385 2017-07-10 00:00:00.0 9.9918 325
58 465.9385 2017-07-11 00:00:00.0 9.6000 325
59 474.8589 2017-07-12 00:00:00.0 8.9204 325
60 484.0829 2017-07-13 00:00:00.0 9.2240 325
61 494.0502 2017-07-14 00:00:00.0 9.9673 325
62 504.0089 2017-07-15 00:00:00.0 9.9587 325
63 513.8783 2017-07-16 00:00:00.0 9.8694 325
64 523.7783 2017-07-17 00:00:00.0 9.9000 325
65 533.1885 2017-07-18 00:00:00.0 9.4102 325
66 542.6329 2017-07-19 00:00:00.0 9.4444 325
67 552.2038 2017-07-20 00:00:00.0 9.5709 325
68 562.0732 2017-07-21 00:00:00.0 9.8694 325
69 571.3365 2017-07-22 00:00:00.0 9.2633 325
70 581.1712 2017-07-23 00:00:00.0 9.8347 325
71 591.1403 2017-07-24 00:00:00.0 9.9691 325
72 601.1153 2017-07-25 00:00:00.0 9.9750 325
73 611.1107 2017-07-26 00:00:00.0 9.9954 325
74 621.1095 2017-07-27 00:00:00.0 9.9988 325
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '325') 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 621
7/26/2017 10 611
7/25/2017 10 601
7/24/2017 10 591
7/23/2017 10 581
7/22/2017 9 571
7/21/2017 10 562
7/20/2017 10 552
7/19/2017 9 543
7/18/2017 9 533
7/17/2017 10 524
7/16/2017 10 514
7/15/2017 10 504
7/14/2017 10 494
7/13/2017 9 484
7/12/2017 9 475
7/11/2017 10 466
7/10/2017 10 456
7/9/2017 10 446
7/8/2017 10 436
7/7/2017 10 426
7/6/2017 10 417
7/5/2017 10 407
7/4/2017 10 397
7/3/2017 10 387
7/2/2017 9 377
7/1/2017 9 368
6/30/2017 9 360
6/29/2017 9 351
6/28/2017 10 342
6/27/2017 10 332
6/26/2017 9 322
6/25/2017 6 313
6/24/2017 4 308
6/23/2017 7 303
6/22/2017 8 297
6/21/2017 9 288
6/20/2017 8 280
6/19/2017 7 271
6/18/2017 7 264
6/17/2017 7 257
6/16/2017 8 250
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 196
6/9/2017 10 186
6/8/2017 10 176
6/7/2017 9 166
6/6/2017 10 157
6/5/2017 10 147
6/4/2017 10 137
6/3/2017 10 127
6/2/2017 9 117
6/1/2017 10 109
5/31/2017 9 99
5/30/2017 6 90
5/29/2017 2 84
5/28/2017 5 81
5/27/2017 8 76
5/26/2017 8 68
5/25/2017 7 60
5/24/2017 8 52
5/23/2017 7 44
5/22/2017 5 37
5/21/2017 3 31
5/20/2017 7 28
5/19/2017 4 22
5/18/2017 0 17
5/17/2017 1 17
5/16/2017 8 17
5/15/2017 9 9