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.8444 2017-05-15 00:00:00.0 7.8444 239
2 15.0505 2017-05-16 00:00:00.0 7.2061 239
3 15.1928 2017-05-17 00:00:00.0 0.1423 239
4 15.1928 2017-05-18 00:00:00.0 0.0000 239
5 17.8459 2017-05-19 00:00:00.0 2.6531 239
6 23.5275 2017-05-20 00:00:00.0 5.6816 239
7 26.6622 2017-05-21 00:00:00.0 3.1347 239
8 31.8617 2017-05-22 00:00:00.0 5.1995 239
9 39.3617 2017-05-23 00:00:00.0 7.5000 239
10 47.1393 2017-05-24 00:00:00.0 7.7776 239
11 54.1924 2017-05-25 00:00:00.0 7.0531 239
12 60.5924 2017-05-26 00:00:00.0 6.4000 239
13 67.9475 2017-05-27 00:00:00.0 7.3551 239
14 73.9965 2017-05-28 00:00:00.0 6.0490 239
15 77.8230 2017-05-29 00:00:00.0 3.8265 239
16 84.0495 2017-05-30 00:00:00.0 6.2265 239
17 92.8740 2017-05-31 00:00:00.0 8.8245 239
18 102.8413 2017-06-01 00:00:00.0 9.9673 239
19 111.9413 2017-06-02 00:00:00.0 9.1000 239
20 121.9331 2017-06-03 00:00:00.0 9.9918 239
21 131.7081 2017-06-04 00:00:00.0 9.7750 239
22 141.7035 2017-06-05 00:00:00.0 9.9954 239
23 151.5561 2017-06-06 00:00:00.0 9.8526 239
24 160.8194 2017-06-07 00:00:00.0 9.2633 239
25 170.6720 2017-06-08 00:00:00.0 9.8526 239
26 180.0108 2017-06-09 00:00:00.0 9.3388 239
27 189.5817 2017-06-10 00:00:00.0 9.5709 239
28 198.9919 2017-06-11 00:00:00.0 9.4102 239
29 207.8649 2017-06-12 00:00:00.0 8.8730 239
30 216.5379 2017-06-13 00:00:00.0 8.6730 239
31 224.9945 2017-06-14 00:00:00.0 8.4566 239
32 233.0960 2017-06-15 00:00:00.0 8.1015 239
33 241.6082 2017-06-16 00:00:00.0 8.5122 239
34 248.9633 2017-06-17 00:00:00.0 7.3551 239
35 256.2444 2017-06-18 00:00:00.0 7.2811 239
36 264.1546 2017-06-19 00:00:00.0 7.9102 239
37 272.2561 2017-06-20 00:00:00.0 8.1015 239
38 281.3984 2017-06-21 00:00:00.0 9.1423 239
39 289.2428 2017-06-22 00:00:00.0 7.8444 239
40 295.6428 2017-06-23 00:00:00.0 6.4000 239
41 299.4693 2017-06-24 00:00:00.0 3.8265 239
42 305.1509 2017-06-25 00:00:00.0 5.6816 239
43 312.9285 2017-06-26 00:00:00.0 7.7776 239
44 322.7811 2017-06-27 00:00:00.0 9.8526 239
45 332.7398 2017-06-28 00:00:00.0 9.9587 239
46 342.0413 2017-06-29 00:00:00.0 9.3015 239
47 350.4413 2017-06-30 00:00:00.0 8.4000 239
48 359.4535 2017-07-01 00:00:00.0 9.0122 239
49 367.7958 2017-07-02 00:00:00.0 8.3423 239
50 377.7830 2017-07-03 00:00:00.0 9.9872 239
51 386.8830 2017-07-04 00:00:00.0 9.1000 239
52 396.8632 2017-07-05 00:00:00.0 9.9802 239
53 406.8550 2017-07-06 00:00:00.0 9.9918 239
54 416.5611 2017-07-07 00:00:00.0 9.7061 239
55 426.5599 2017-07-08 00:00:00.0 9.9988 239
56 436.5401 2017-07-09 00:00:00.0 9.9802 239
57 446.4796 2017-07-10 00:00:00.0 9.9395 239
58 456.4469 2017-07-11 00:00:00.0 9.9673 239
59 465.1199 2017-07-12 00:00:00.0 8.6730 239
60 473.9929 2017-07-13 00:00:00.0 8.8730 239
61 483.9801 2017-07-14 00:00:00.0 9.9872 239
62 493.8495 2017-07-15 00:00:00.0 9.8694 239
63 503.7495 2017-07-16 00:00:00.0 9.9000 239
64 513.6890 2017-07-17 00:00:00.0 9.9395 239
65 522.7890 2017-07-18 00:00:00.0 9.1000 239
66 532.0130 2017-07-19 00:00:00.0 9.2240 239
67 541.6130 2017-07-20 00:00:00.0 9.6000 239
68 551.4824 2017-07-21 00:00:00.0 9.8694 239
69 560.8574 2017-07-22 00:00:00.0 9.3750 239
70 570.6105 2017-07-23 00:00:00.0 9.7531 239
71 580.4327 2017-07-24 00:00:00.0 9.8222 239
72 590.2485 2017-07-25 00:00:00.0 9.8158 239
73 600.1975 2017-07-26 00:00:00.0 9.9490 239
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '239') 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 600
7/25/2017 10 590
7/24/2017 10 580
7/23/2017 10 571
7/22/2017 9 561
7/21/2017 10 551
7/20/2017 10 542
7/19/2017 9 532
7/18/2017 9 523
7/17/2017 10 514
7/16/2017 10 504
7/15/2017 10 494
7/14/2017 10 484
7/13/2017 9 474
7/12/2017 9 465
7/11/2017 10 456
7/10/2017 10 446
7/9/2017 10 437
7/8/2017 10 427
7/7/2017 10 417
7/6/2017 10 407
7/5/2017 10 397
7/4/2017 9 387
7/3/2017 10 378
7/2/2017 8 368
7/1/2017 9 359
6/30/2017 8 350
6/29/2017 9 342
6/28/2017 10 333
6/27/2017 10 323
6/26/2017 8 313
6/25/2017 6 305
6/24/2017 4 299
6/23/2017 6 296
6/22/2017 8 289
6/21/2017 9 281
6/20/2017 8 272
6/19/2017 8 264
6/18/2017 7 256
6/17/2017 7 249
6/16/2017 9 242
6/15/2017 8 233
6/14/2017 8 225
6/13/2017 9 217
6/12/2017 9 208
6/11/2017 9 199
6/10/2017 10 190
6/9/2017 9 180
6/8/2017 10 171
6/7/2017 9 161
6/6/2017 10 152
6/5/2017 10 142
6/4/2017 10 132
6/3/2017 10 122
6/2/2017 9 112
6/1/2017 10 103
5/31/2017 9 93
5/30/2017 6 84
5/29/2017 4 78
5/28/2017 6 74
5/27/2017 7 68
5/26/2017 6 61
5/25/2017 7 54
5/24/2017 8 47
5/23/2017 8 39
5/22/2017 5 32
5/21/2017 3 27
5/20/2017 6 24
5/19/2017 3 18
5/18/2017 0 15
5/17/2017 0 15
5/16/2017 7 15
5/15/2017 8 8