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.2061 2017-05-15 00:00:00.0 7.2061 318
2 15.0505 2017-05-16 00:00:00.0 7.8444 318
3 16.5602 2017-05-17 00:00:00.0 1.5097 318
4 16.7025 2017-05-18 00:00:00.0 0.1423 318
5 18.2122 2017-05-19 00:00:00.0 1.5097 318
6 24.6974 2017-05-20 00:00:00.0 6.4852 318
7 29.0724 2017-05-21 00:00:00.0 4.3750 318
8 35.3862 2017-05-22 00:00:00.0 6.3138 318
9 42.8862 2017-05-23 00:00:00.0 7.5000 318
10 50.9250 2017-05-24 00:00:00.0 8.0388 318
11 58.9638 2017-05-25 00:00:00.0 8.0388 318
12 65.6164 2017-05-26 00:00:00.0 6.6526 318
13 72.7465 2017-05-27 00:00:00.0 7.1301 318
14 78.9730 2017-05-28 00:00:00.0 6.2265 318
15 82.6868 2017-05-29 00:00:00.0 3.7138 318
16 89.8169 2017-05-30 00:00:00.0 7.1301 318
17 97.9184 2017-05-31 00:00:00.0 8.1015 318
18 107.7531 2017-06-01 00:00:00.0 9.8347 318
19 113.1593 2017-06-02 00:00:00.0 5.4062 318
20 123.1180 2017-06-03 00:00:00.0 9.9587 318
21 132.5282 2017-06-04 00:00:00.0 9.4102 318
22 142.4955 2017-06-05 00:00:00.0 9.9673 318
23 151.8705 2017-06-06 00:00:00.0 9.3750 318
24 161.0945 2017-06-07 00:00:00.0 9.2240 318
25 170.6042 2017-06-08 00:00:00.0 9.5097 318
26 180.3792 2017-06-09 00:00:00.0 9.7750 318
27 190.1751 2017-06-10 00:00:00.0 9.7959 318
28 198.9996 2017-06-11 00:00:00.0 8.8245 318
29 207.4562 2017-06-12 00:00:00.0 8.4566 318
30 215.1659 2017-06-13 00:00:00.0 7.7097 318
31 224.1781 2017-06-14 00:00:00.0 9.0122 318
32 232.8511 2017-06-15 00:00:00.0 8.6730 318
33 241.5241 2017-06-16 00:00:00.0 8.6730 318
34 249.6874 2017-06-17 00:00:00.0 8.1633 318
35 257.0425 2017-06-18 00:00:00.0 7.3551 318
36 265.8175 2017-06-19 00:00:00.0 8.7750 318
37 274.0415 2017-06-20 00:00:00.0 8.2240 318
38 283.3048 2017-06-21 00:00:00.0 9.2633 318
39 290.9456 2017-06-22 00:00:00.0 7.6408 318
40 297.1721 2017-06-23 00:00:00.0 6.2265 318
41 302.1716 2017-06-24 00:00:00.0 4.9995 318
42 308.3099 2017-06-25 00:00:00.0 6.1383 318
43 315.5160 2017-06-26 00:00:00.0 7.2061 318
44 325.4160 2017-06-27 00:00:00.0 9.9000 318
45 335.2686 2017-06-28 00:00:00.0 9.8526 318
46 344.8395 2017-06-29 00:00:00.0 9.5709 318
47 353.6145 2017-06-30 00:00:00.0 8.7750 318
48 362.1813 2017-07-01 00:00:00.0 8.5668 318
49 370.2828 2017-07-02 00:00:00.0 8.1015 318
50 380.2630 2017-07-03 00:00:00.0 9.9802 318
51 390.0852 2017-07-04 00:00:00.0 9.8222 318
52 400.0770 2017-07-05 00:00:00.0 9.9918 318
53 410.0443 2017-07-06 00:00:00.0 9.9673 318
54 419.9933 2017-07-07 00:00:00.0 9.9490 318
55 429.9606 2017-07-08 00:00:00.0 9.9673 318
56 439.9408 2017-07-09 00:00:00.0 9.9802 318
57 449.9396 2017-07-10 00:00:00.0 9.9988 318
58 459.9146 2017-07-11 00:00:00.0 9.9750 318
59 468.7391 2017-07-12 00:00:00.0 8.8245 318
60 477.6121 2017-07-13 00:00:00.0 8.8730 318
61 487.5331 2017-07-14 00:00:00.0 9.9210 318
62 497.4469 2017-07-15 00:00:00.0 9.9138 318
63 507.2627 2017-07-16 00:00:00.0 9.8158 318
64 517.0586 2017-07-17 00:00:00.0 9.7959 318
65 525.5708 2017-07-18 00:00:00.0 8.5122 318
66 535.0484 2017-07-19 00:00:00.0 9.4776 318
67 544.5892 2017-07-20 00:00:00.0 9.5408 318
68 554.4418 2017-07-21 00:00:00.0 9.8526 318
69 564.2168 2017-07-22 00:00:00.0 9.7750 318
70 573.9469 2017-07-23 00:00:00.0 9.7301 318
71 583.7691 2017-07-24 00:00:00.0 9.8222 318
72 593.5222 2017-07-25 00:00:00.0 9.7531 318
73 603.5210 2017-07-26 00:00:00.0 9.9988 318
74 603.5210 2017-07-27 00:00:00.0 0.0000 318
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '318') 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 0 604
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 554
7/20/2017 10 545
7/19/2017 9 535
7/18/2017 9 526
7/17/2017 10 517
7/16/2017 10 507
7/15/2017 10 497
7/14/2017 10 488
7/13/2017 9 478
7/12/2017 9 469
7/11/2017 10 460
7/10/2017 10 450
7/9/2017 10 440
7/8/2017 10 430
7/7/2017 10 420
7/6/2017 10 410
7/5/2017 10 400
7/4/2017 10 390
7/3/2017 10 380
7/2/2017 8 370
7/1/2017 9 362
6/30/2017 9 354
6/29/2017 10 345
6/28/2017 10 335
6/27/2017 10 325
6/26/2017 7 316
6/25/2017 6 308
6/24/2017 5 302
6/23/2017 6 297
6/22/2017 8 291
6/21/2017 9 283
6/20/2017 8 274
6/19/2017 9 266
6/18/2017 7 257
6/17/2017 8 250
6/16/2017 9 242
6/15/2017 9 233
6/14/2017 9 224
6/13/2017 8 215
6/12/2017 8 207
6/11/2017 9 199
6/10/2017 10 190
6/9/2017 10 180
6/8/2017 10 171
6/7/2017 9 161
6/6/2017 9 152
6/5/2017 10 142
6/4/2017 9 133
6/3/2017 10 123
6/2/2017 5 113
6/1/2017 10 108
5/31/2017 8 98
5/30/2017 7 90
5/29/2017 4 83
5/28/2017 6 79
5/27/2017 7 73
5/26/2017 7 66
5/25/2017 8 59
5/24/2017 8 51
5/23/2017 8 43
5/22/2017 6 35
5/21/2017 4 29
5/20/2017 6 25
5/19/2017 2 18
5/18/2017 0 17
5/17/2017 2 17
5/16/2017 8 15
5/15/2017 7 7