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.3423 2017-05-15 00:00:00.0 8.3423 475
2 14.9117 2017-05-16 00:00:00.0 6.5694 475
3 14.9117 2017-05-17 00:00:00.0 0.0000 475
4 14.9117 2017-05-18 00:00:00.0 0.0000 475
5 17.3178 2017-05-19 00:00:00.0 2.4061 475
6 22.3173 2017-05-20 00:00:00.0 4.9995 475
7 24.2173 2017-05-21 00:00:00.0 1.9000 475
8 28.6989 2017-05-22 00:00:00.0 4.4816 475
9 35.6739 2017-05-23 00:00:00.0 6.9750 475
10 43.3147 2017-05-24 00:00:00.0 7.6408 475
11 50.1305 2017-05-25 00:00:00.0 6.8158 475
12 55.9978 2017-05-26 00:00:00.0 5.8673 475
13 62.6504 2017-05-27 00:00:00.0 6.6526 475
14 68.1422 2017-05-28 00:00:00.0 5.4918 475
15 71.1580 2017-05-29 00:00:00.0 3.0158 475
16 76.4560 2017-05-30 00:00:00.0 5.2980 475
17 84.9682 2017-05-31 00:00:00.0 8.5122 475
18 94.8820 2017-06-01 00:00:00.0 9.9138 475
19 104.5252 2017-06-02 00:00:00.0 9.6432 475
20 114.4742 2017-06-03 00:00:00.0 9.9490 475
21 124.2701 2017-06-04 00:00:00.0 9.7959 475
22 134.2655 2017-06-05 00:00:00.0 9.9954 475
23 144.0614 2017-06-06 00:00:00.0 9.7959 475
24 152.8364 2017-06-07 00:00:00.0 8.7750 475
25 162.6711 2017-06-08 00:00:00.0 9.8347 475
26 171.9726 2017-06-09 00:00:00.0 9.3015 475
27 181.4170 2017-06-10 00:00:00.0 9.4444 475
28 190.7920 2017-06-11 00:00:00.0 9.3750 475
29 199.4650 2017-06-12 00:00:00.0 8.6730 475
30 208.1380 2017-06-13 00:00:00.0 8.6730 475
31 216.4217 2017-06-14 00:00:00.0 8.2837 475
32 224.5850 2017-06-15 00:00:00.0 8.1633 475
33 232.9273 2017-06-16 00:00:00.0 8.3423 475
34 240.4273 2017-06-17 00:00:00.0 7.5000 475
35 247.6334 2017-06-18 00:00:00.0 7.2061 475
36 255.2742 2017-06-19 00:00:00.0 7.6408 475
37 263.1844 2017-06-20 00:00:00.0 7.9102 475
38 272.2410 2017-06-21 00:00:00.0 9.0566 475
39 279.9507 2017-06-22 00:00:00.0 7.7097 475
40 286.0890 2017-06-23 00:00:00.0 6.1383 475
41 289.4584 2017-06-24 00:00:00.0 3.3694 475
42 294.4579 2017-06-25 00:00:00.0 4.9995 475
43 301.6640 2017-06-26 00:00:00.0 7.2061 475
44 311.4798 2017-06-27 00:00:00.0 9.8158 475
45 321.4063 2017-06-28 00:00:00.0 9.9265 475
46 330.5486 2017-06-29 00:00:00.0 9.1423 475
47 338.7726 2017-06-30 00:00:00.0 8.2240 475
48 347.3394 2017-07-01 00:00:00.0 8.5668 475
49 355.5027 2017-07-02 00:00:00.0 8.1633 475
50 365.4843 2017-07-03 00:00:00.0 9.9816 475
51 374.7127 2017-07-04 00:00:00.0 9.2284 475
52 384.6818 2017-07-05 00:00:00.0 9.9691 475
53 394.6201 2017-07-06 00:00:00.0 9.9383 475
54 404.1298 2017-07-07 00:00:00.0 9.5097 475
55 414.1170 2017-07-08 00:00:00.0 9.9872 475
56 424.1150 2017-07-09 00:00:00.0 9.9980 475
57 434.1150 2017-07-10 00:00:00.0 10.0000 475
58 444.1022 2017-07-11 00:00:00.0 9.9872 475
59 452.1410 2017-07-12 00:00:00.0 8.0388 475
60 460.7078 2017-07-13 00:00:00.0 8.5668 475
61 470.6828 2017-07-14 00:00:00.0 9.9750 475
62 480.5354 2017-07-15 00:00:00.0 9.8526 475
63 490.2415 2017-07-16 00:00:00.0 9.7061 475
64 500.1415 2017-07-17 00:00:00.0 9.9000 475
65 509.2415 2017-07-18 00:00:00.0 9.1000 475
66 518.3838 2017-07-19 00:00:00.0 9.1423 475
67 528.1369 2017-07-20 00:00:00.0 9.7531 475
68 538.1119 2017-07-21 00:00:00.0 9.9750 475
69 547.4869 2017-07-22 00:00:00.0 9.3750 475
70 557.2828 2017-07-23 00:00:00.0 9.7959 475
71 567.1593 2017-07-24 00:00:00.0 9.8765 475
72 577.0445 2017-07-25 00:00:00.0 9.8852 475
73 587.0032 2017-07-26 00:00:00.0 9.9587 475
74 596.9848 2017-07-27 00:00:00.0 9.9816 475
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '475') 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 597
7/26/2017 10 587
7/25/2017 10 577
7/24/2017 10 567
7/23/2017 10 557
7/22/2017 9 547
7/21/2017 10 538
7/20/2017 10 528
7/19/2017 9 518
7/18/2017 9 509
7/17/2017 10 500
7/16/2017 10 490
7/15/2017 10 481
7/14/2017 10 471
7/13/2017 9 461
7/12/2017 8 452
7/11/2017 10 444
7/10/2017 10 434
7/9/2017 10 424
7/8/2017 10 414
7/7/2017 10 404
7/6/2017 10 395
7/5/2017 10 385
7/4/2017 9 375
7/3/2017 10 365
7/2/2017 8 356
7/1/2017 9 347
6/30/2017 8 339
6/29/2017 9 331
6/28/2017 10 321
6/27/2017 10 311
6/26/2017 7 302
6/25/2017 5 294
6/24/2017 3 289
6/23/2017 6 286
6/22/2017 8 280
6/21/2017 9 272
6/20/2017 8 263
6/19/2017 8 255
6/18/2017 7 248
6/17/2017 8 240
6/16/2017 8 233
6/15/2017 8 225
6/14/2017 8 216
6/13/2017 9 208
6/12/2017 9 199
6/11/2017 9 191
6/10/2017 9 181
6/9/2017 9 172
6/8/2017 10 163
6/7/2017 9 153
6/6/2017 10 144
6/5/2017 10 134
6/4/2017 10 124
6/3/2017 10 114
6/2/2017 10 105
6/1/2017 10 95
5/31/2017 9 85
5/30/2017 5 76
5/29/2017 3 71
5/28/2017 5 68
5/27/2017 7 63
5/26/2017 6 56
5/25/2017 7 50
5/24/2017 8 43
5/23/2017 7 36
5/22/2017 4 29
5/21/2017 2 24
5/20/2017 5 22
5/19/2017 2 17
5/18/2017 0 15
5/17/2017 0 15
5/16/2017 7 15
5/15/2017 8 8