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.6730 2017-05-15 00:00:00.0 8.6730 235
2 16.1011 2017-05-16 00:00:00.0 7.4281 235
3 16.3848 2017-05-17 00:00:00.0 0.2837 235
4 16.3848 2017-05-18 00:00:00.0 0.0000 235
5 20.6521 2017-05-19 00:00:00.0 4.2673 235
6 27.1373 2017-05-20 00:00:00.0 6.4852 235
7 30.3899 2017-05-21 00:00:00.0 3.2526 235
8 35.4899 2017-05-22 00:00:00.0 5.1000 235
9 43.1307 2017-05-23 00:00:00.0 7.6408 235
10 51.5307 2017-05-24 00:00:00.0 8.4000 235
11 59.1715 2017-05-25 00:00:00.0 7.6408 235
12 67.2103 2017-05-26 00:00:00.0 8.0388 235
13 75.6103 2017-05-27 00:00:00.0 8.4000 235
14 80.7103 2017-05-28 00:00:00.0 5.1000 235
15 82.7384 2017-05-29 00:00:00.0 2.0281 235
16 89.2236 2017-05-30 00:00:00.0 6.4852 235
17 98.2802 2017-05-31 00:00:00.0 9.0566 235
18 104.4086 2017-06-01 00:00:00.0 6.1284 235
19 112.9814 2017-06-02 00:00:00.0 8.5728 235
20 122.8814 2017-06-03 00:00:00.0 9.9000 235
21 132.5365 2017-06-04 00:00:00.0 9.6551 235
22 142.4921 2017-06-05 00:00:00.0 9.9556 235
23 152.4131 2017-06-06 00:00:00.0 9.9210 235
24 161.9539 2017-06-07 00:00:00.0 9.5408 235
25 171.9534 2017-06-08 00:00:00.0 9.9995 235
26 181.7493 2017-06-09 00:00:00.0 9.7959 235
27 191.5840 2017-06-10 00:00:00.0 9.8347 235
28 201.2651 2017-06-11 00:00:00.0 9.6811 235
29 210.5284 2017-06-12 00:00:00.0 9.2633 235
30 219.8672 2017-06-13 00:00:00.0 9.3388 235
31 229.0912 2017-06-14 00:00:00.0 9.2240 235
32 237.8662 2017-06-15 00:00:00.0 8.7750 235
33 245.7106 2017-06-16 00:00:00.0 7.8444 235
34 253.1387 2017-06-17 00:00:00.0 7.4281 235
35 260.3448 2017-06-18 00:00:00.0 7.2061 235
36 268.1224 2017-06-19 00:00:00.0 7.7776 235
37 276.7428 2017-06-20 00:00:00.0 8.6204 235
38 285.4673 2017-06-21 00:00:00.0 8.7245 235
39 294.1403 2017-06-22 00:00:00.0 8.6730 235
40 301.0362 2017-06-23 00:00:00.0 6.8959 235
41 305.8316 2017-06-24 00:00:00.0 4.7954 235
42 312.0581 2017-06-25 00:00:00.0 6.2265 235
43 321.2004 2017-06-26 00:00:00.0 9.1423 235
44 331.1958 2017-06-27 00:00:00.0 9.9954 235
45 341.1341 2017-06-28 00:00:00.0 9.9383 235
46 350.6438 2017-06-29 00:00:00.0 9.5097 235
47 359.5168 2017-06-30 00:00:00.0 8.8730 235
48 368.5290 2017-07-01 00:00:00.0 9.0122 235
49 377.4494 2017-07-02 00:00:00.0 8.9204 235
50 387.4412 2017-07-03 00:00:00.0 9.9918 235
51 397.0412 2017-07-04 00:00:00.0 9.6000 235
52 406.0733 2017-07-05 00:00:00.0 9.0321 235
53 415.8313 2017-07-06 00:00:00.0 9.7580 235
54 425.7007 2017-07-07 00:00:00.0 9.8694 235
55 435.4587 2017-07-08 00:00:00.0 9.7580 235
56 445.4476 2017-07-09 00:00:00.0 9.9889 235
57 455.4032 2017-07-10 00:00:00.0 9.9556 235
58 465.0843 2017-07-11 00:00:00.0 9.6811 235
59 474.0965 2017-07-12 00:00:00.0 9.0122 235
60 483.6965 2017-07-13 00:00:00.0 9.6000 235
61 493.5187 2017-07-14 00:00:00.0 9.8222 235
62 503.5182 2017-07-15 00:00:00.0 9.9995 235
63 513.5054 2017-07-16 00:00:00.0 9.9872 235
64 522.7338 2017-07-17 00:00:00.0 9.2284 235
65 532.5088 2017-07-18 00:00:00.0 9.7750 235
66 542.3047 2017-07-19 00:00:00.0 9.7959 235
67 552.1741 2017-07-20 00:00:00.0 9.8694 235
68 562.1006 2017-07-21 00:00:00.0 9.9265 235
69 571.5782 2017-07-22 00:00:00.0 9.4776 235
70 581.5369 2017-07-23 00:00:00.0 9.9587 235
71 591.1369 2017-07-24 00:00:00.0 9.6000 235
72 601.1320 2017-07-25 00:00:00.0 9.9951 235
73 611.0530 2017-07-26 00:00:00.0 9.9210 235
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '235') 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 611
7/25/2017 10 601
7/24/2017 10 591
7/23/2017 10 582
7/22/2017 9 572
7/21/2017 10 562
7/20/2017 10 552
7/19/2017 10 542
7/18/2017 10 533
7/17/2017 9 523
7/16/2017 10 514
7/15/2017 10 504
7/14/2017 10 494
7/13/2017 10 484
7/12/2017 9 474
7/11/2017 10 465
7/10/2017 10 455
7/9/2017 10 445
7/8/2017 10 435
7/7/2017 10 426
7/6/2017 10 416
7/5/2017 9 406
7/4/2017 10 397
7/3/2017 10 387
7/2/2017 9 377
7/1/2017 9 369
6/30/2017 9 360
6/29/2017 10 351
6/28/2017 10 341
6/27/2017 10 331
6/26/2017 9 321
6/25/2017 6 312
6/24/2017 5 306
6/23/2017 7 301
6/22/2017 9 294
6/21/2017 9 285
6/20/2017 9 277
6/19/2017 8 268
6/18/2017 7 260
6/17/2017 7 253
6/16/2017 8 246
6/15/2017 9 238
6/14/2017 9 229
6/13/2017 9 220
6/12/2017 9 211
6/11/2017 10 201
6/10/2017 10 192
6/9/2017 10 182
6/8/2017 10 172
6/7/2017 10 162
6/6/2017 10 152
6/5/2017 10 142
6/4/2017 10 133
6/3/2017 10 123
6/2/2017 9 113
6/1/2017 6 104
5/31/2017 9 98
5/30/2017 6 89
5/29/2017 2 83
5/28/2017 5 81
5/27/2017 8 76
5/26/2017 8 67
5/25/2017 8 59
5/24/2017 8 52
5/23/2017 8 43
5/22/2017 5 35
5/21/2017 3 30
5/20/2017 6 27
5/19/2017 4 21
5/18/2017 0 16
5/17/2017 0 16
5/16/2017 7 16
5/15/2017 9 9