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 9.3388 2017-05-15 00:00:00.0 9.3388 212
2 16.7669 2017-05-16 00:00:00.0 7.4281 212
3 18.1445 2017-05-17 00:00:00.0 1.3776 212
4 18.5685 2017-05-18 00:00:00.0 0.4240 212
5 22.3950 2017-05-19 00:00:00.0 3.8265 212
6 28.0766 2017-05-20 00:00:00.0 5.6816 212
7 29.8475 2017-05-21 00:00:00.0 1.7709 212
8 33.5613 2017-05-22 00:00:00.0 3.7138 212
9 40.7674 2017-05-23 00:00:00.0 7.2061 212
10 48.6776 2017-05-24 00:00:00.0 7.9102 212
11 56.3873 2017-05-25 00:00:00.0 7.7097 212
12 64.1649 2017-05-26 00:00:00.0 7.7776 212
13 71.9425 2017-05-27 00:00:00.0 7.7776 212
14 77.2405 2017-05-28 00:00:00.0 5.2980 212
15 79.8936 2017-05-29 00:00:00.0 2.6531 212
16 85.9426 2017-05-30 00:00:00.0 6.0490 212
17 94.9992 2017-05-31 00:00:00.0 9.0566 212
18 104.9910 2017-06-01 00:00:00.0 9.9918 212
19 113.4787 2017-06-02 00:00:00.0 8.4877 212
20 123.3293 2017-06-03 00:00:00.0 9.8506 212
21 133.1819 2017-06-04 00:00:00.0 9.8526 212
22 143.1375 2017-06-05 00:00:00.0 9.9556 212
23 153.1177 2017-06-06 00:00:00.0 9.9802 212
24 162.7988 2017-06-07 00:00:00.0 9.6811 212
25 172.7968 2017-06-08 00:00:00.0 9.9980 212
26 182.5029 2017-06-09 00:00:00.0 9.7061 212
27 192.3187 2017-06-10 00:00:00.0 9.8158 212
28 202.1345 2017-06-11 00:00:00.0 9.8158 212
29 211.3585 2017-06-12 00:00:00.0 9.2240 212
30 220.5422 2017-06-13 00:00:00.0 9.1837 212
31 229.8437 2017-06-14 00:00:00.0 9.3015 212
32 238.5167 2017-06-15 00:00:00.0 8.6730 212
33 247.3412 2017-06-16 00:00:00.0 8.8245 212
34 255.2514 2017-06-17 00:00:00.0 7.9102 212
35 262.6065 2017-06-18 00:00:00.0 7.3551 212
36 270.7698 2017-06-19 00:00:00.0 8.1633 212
37 279.2264 2017-06-20 00:00:00.0 8.4566 212
38 287.8994 2017-06-21 00:00:00.0 8.6730 212
39 296.2994 2017-06-22 00:00:00.0 8.4000 212
40 303.5805 2017-06-23 00:00:00.0 7.2811 212
41 307.8478 2017-06-24 00:00:00.0 4.2673 212
42 313.7151 2017-06-25 00:00:00.0 5.8673 212
43 322.0574 2017-06-26 00:00:00.0 8.3423 212
44 331.8533 2017-06-27 00:00:00.0 9.7959 212
45 341.6283 2017-06-28 00:00:00.0 9.7750 212
46 350.9671 2017-06-29 00:00:00.0 9.3388 212
47 359.6916 2017-06-30 00:00:00.0 8.7245 212
48 368.4666 2017-07-01 00:00:00.0 8.7750 212
49 377.2416 2017-07-02 00:00:00.0 8.7750 212
50 387.2089 2017-07-03 00:00:00.0 9.9673 212
51 396.8929 2017-07-04 00:00:00.0 9.6840 212
52 406.4472 2017-07-05 00:00:00.0 9.5543 212
53 416.2386 2017-07-06 00:00:00.0 9.7914 212
54 426.0136 2017-07-07 00:00:00.0 9.7750 212
55 436.0025 2017-07-08 00:00:00.0 9.9889 212
56 446.0013 2017-07-09 00:00:00.0 9.9988 212
57 455.9967 2017-07-10 00:00:00.0 9.9954 212
58 465.9105 2017-07-11 00:00:00.0 9.9138 212
59 474.4227 2017-07-12 00:00:00.0 8.5122 212
60 483.3895 2017-07-13 00:00:00.0 8.9668 212
61 493.3278 2017-07-14 00:00:00.0 9.9383 212
62 503.3150 2017-07-15 00:00:00.0 9.9872 212
63 513.0681 2017-07-16 00:00:00.0 9.7531 212
64 522.6224 2017-07-17 00:00:00.0 9.5543 212
65 532.1321 2017-07-18 00:00:00.0 9.5097 212
66 541.0989 2017-07-19 00:00:00.0 8.9668 212
67 550.8948 2017-07-20 00:00:00.0 9.7959 212
68 560.8213 2017-07-21 00:00:00.0 9.9265 212
69 570.3621 2017-07-22 00:00:00.0 9.5408 212
70 580.2621 2017-07-23 00:00:00.0 9.9000 212
71 590.2423 2017-07-24 00:00:00.0 9.9802 212
72 600.2295 2017-07-25 00:00:00.0 9.9872 212
73 610.2295 2017-07-26 00:00:00.0 10.0000 212
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '212') 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 610
7/25/2017 10 600
7/24/2017 10 590
7/23/2017 10 580
7/22/2017 10 570
7/21/2017 10 561
7/20/2017 10 551
7/19/2017 9 541
7/18/2017 10 532
7/17/2017 10 523
7/16/2017 10 513
7/15/2017 10 503
7/14/2017 10 493
7/13/2017 9 483
7/12/2017 9 474
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 416
7/5/2017 10 406
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 8 322
6/25/2017 6 314
6/24/2017 4 308
6/23/2017 7 304
6/22/2017 8 296
6/21/2017 9 288
6/20/2017 8 279
6/19/2017 8 271
6/18/2017 7 263
6/17/2017 8 255
6/16/2017 9 247
6/15/2017 9 239
6/14/2017 9 230
6/13/2017 9 221
6/12/2017 9 211
6/11/2017 10 202
6/10/2017 10 192
6/9/2017 10 183
6/8/2017 10 173
6/7/2017 10 163
6/6/2017 10 153
6/5/2017 10 143
6/4/2017 10 133
6/3/2017 10 123
6/2/2017 8 113
6/1/2017 10 105
5/31/2017 9 95
5/30/2017 6 86
5/29/2017 3 80
5/28/2017 5 77
5/27/2017 8 72
5/26/2017 8 64
5/25/2017 8 56
5/24/2017 8 49
5/23/2017 7 41
5/22/2017 4 34
5/21/2017 2 30
5/20/2017 6 28
5/19/2017 4 22
5/18/2017 0 19
5/17/2017 1 18
5/16/2017 7 17
5/15/2017 9 9