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 5.8469 2017-06-05 00:00:00.0 5.8469 474
2 15.6691 2017-06-06 00:00:00.0 9.8222 474
3 25.5038 2017-06-07 00:00:00.0 9.8347 474
4 35.4840 2017-06-08 00:00:00.0 9.9802 474
5 45.1121 2017-06-09 00:00:00.0 9.6281 474
6 54.9468 2017-06-10 00:00:00.0 9.8347 474
7 64.8162 2017-06-11 00:00:00.0 9.8694 474
8 74.3259 2017-06-12 00:00:00.0 9.5097 474
9 83.1504 2017-06-13 00:00:00.0 8.8245 474
10 92.4137 2017-06-14 00:00:00.0 9.2633 474
11 101.1887 2017-06-15 00:00:00.0 8.7750 474
12 110.4520 2017-06-16 00:00:00.0 9.2633 474
13 118.3622 2017-06-17 00:00:00.0 7.9102 474
14 125.9331 2017-06-18 00:00:00.0 7.5709 474
15 134.2168 2017-06-19 00:00:00.0 8.2837 474
16 143.0413 2017-06-20 00:00:00.0 8.8245 474
17 152.1413 2017-06-21 00:00:00.0 9.1000 474
18 161.0617 2017-06-22 00:00:00.0 8.9204 474
19 168.4898 2017-06-23 00:00:00.0 7.4281 474
20 172.5388 2017-06-24 00:00:00.0 4.0490 474
21 178.3138 2017-06-25 00:00:00.0 5.7750 474
22 187.0888 2017-06-26 00:00:00.0 8.7750 474
23 197.0378 2017-06-27 00:00:00.0 9.9490 474
24 206.8725 2017-06-28 00:00:00.0 9.8347 474
25 216.3169 2017-06-29 00:00:00.0 9.4444 474
26 225.1414 2017-06-30 00:00:00.0 8.8245 474
27 233.8144 2017-07-01 00:00:00.0 8.6730 474
28 242.5894 2017-07-02 00:00:00.0 8.7750 474
29 252.5848 2017-07-03 00:00:00.0 9.9954 474
30 261.6848 2017-07-04 00:00:00.0 9.1000 474
31 270.7848 2017-07-05 00:00:00.0 9.1000 474
32 280.3391 2017-07-06 00:00:00.0 9.5543 474
33 290.1917 2017-07-07 00:00:00.0 9.8526 474
34 300.0139 2017-07-08 00:00:00.0 9.8222 474
35 309.9349 2017-07-09 00:00:00.0 9.9210 474
36 319.8349 2017-07-10 00:00:00.0 9.9000 474
37 329.8329 2017-07-11 00:00:00.0 9.9980 474
38 338.1166 2017-07-12 00:00:00.0 8.2837 474
39 347.3003 2017-07-13 00:00:00.0 9.1837 474
40 357.2590 2017-07-14 00:00:00.0 9.9587 474
41 367.2544 2017-07-15 00:00:00.0 9.9954 474
42 377.1927 2017-07-16 00:00:00.0 9.9383 474
43 386.9149 2017-07-17 00:00:00.0 9.7222 474
44 396.6210 2017-07-18 00:00:00.0 9.7061 474
45 405.4940 2017-07-19 00:00:00.0 8.8730 474
46 415.4205 2017-07-20 00:00:00.0 9.9265 474
47 425.4021 2017-07-21 00:00:00.0 9.9816 474
48 435.0021 2017-07-22 00:00:00.0 9.6000 474
49 444.9771 2017-07-23 00:00:00.0 9.9750 474
50 454.8277 2017-07-24 00:00:00.0 9.8506 474
51 464.8272 2017-07-25 00:00:00.0 9.9995 474
52 474.8223 2017-07-26 00:00:00.0 9.9951 474
53 484.6988 2017-07-27 00:00:00.0 9.8765 474
54 493.9272 2017-07-28 00:00:00.0 9.2284 474
55 503.6112 2017-07-29 00:00:00.0 9.6840 474
56 512.2668 2017-07-30 00:00:00.0 8.6556 474
57 520.0890 2017-07-31 00:00:00.0 7.8222 474
58 530.0563 2017-08-01 00:00:00.0 9.9673 474
59 537.7660 2017-08-02 00:00:00.0 7.7097 474
60 547.1048 2017-08-03 00:00:00.0 9.3388 474
61 556.6145 2017-08-04 00:00:00.0 9.5097 474
62 565.9160 2017-08-05 00:00:00.0 9.3015 474
63 575.2910 2017-08-06 00:00:00.0 9.3750 474
64 585.1604 2017-08-07 00:00:00.0 9.8694 474
65 594.9762 2017-08-08 00:00:00.0 9.8158 474
66 603.9430 2017-08-09 00:00:00.0 8.9668 474
67 613.6961 2017-08-10 00:00:00.0 9.7531 474
68 623.2961 2017-08-11 00:00:00.0 9.6000 474
69 633.0492 2017-08-12 00:00:00.0 9.7531 474
70 642.8242 2017-08-13 00:00:00.0 9.7750 474
71 652.7380 2017-08-14 00:00:00.0 9.9138 474
72 662.3931 2017-08-15 00:00:00.0 9.6551 474
73 672.2089 2017-08-16 00:00:00.0 9.8158 474
74 682.0048 2017-08-17 00:00:00.0 9.7959 474
75 691.9538 2017-08-18 00:00:00.0 9.9490 474
76 701.7760 2017-08-19 00:00:00.0 9.8222 474
77 711.6286 2017-08-20 00:00:00.0 9.8526 474
78 720.0852 2017-08-21 00:00:00.0 8.4566 474
79 728.9582 2017-08-22 00:00:00.0 8.8730 474
80 735.2720 2017-08-23 00:00:00.0 6.3138 474
81 742.6271 2017-08-24 00:00:00.0 7.3551 474
82 752.1047 2017-08-25 00:00:00.0 9.4776 474
83 761.6144 2017-08-26 00:00:00.0 9.5097 474
84 771.4996 2017-08-27 00:00:00.0 9.8852 474
85 781.2576 2017-08-28 00:00:00.0 9.7580 474
86 790.7638 2017-08-29 00:00:00.0 9.5062 474
87 800.1026 2017-08-30 00:00:00.0 9.3388 474
88 809.5802 2017-08-31 00:00:00.0 9.4776 474
89 819.4328 2017-09-01 00:00:00.0 9.8526 474
90 829.2854 2017-09-02 00:00:00.0 9.8526 474
91 839.1548 2017-09-03 00:00:00.0 9.8694 474
92 847.8793 2017-09-04 00:00:00.0 8.7245 474
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '474') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/4/2017 9 848
9/3/2017 10 839
9/2/2017 10 829
9/1/2017 10 819
8/31/2017 9 810
8/30/2017 9 800
8/29/2017 10 791
8/28/2017 10 781
8/27/2017 10 771
8/26/2017 10 762
8/25/2017 9 752
8/24/2017 7 743
8/23/2017 6 735
8/22/2017 9 729
8/21/2017 8 720
8/20/2017 10 712
8/19/2017 10 702
8/18/2017 10 692
8/17/2017 10 682
8/16/2017 10 672
8/15/2017 10 662
8/14/2017 10 653
8/13/2017 10 643
8/12/2017 10 633
8/11/2017 10 623
8/10/2017 10 614
8/9/2017 9 604
8/8/2017 10 595
8/7/2017 10 585
8/6/2017 9 575
8/5/2017 9 566
8/4/2017 10 557
8/3/2017 9 547
8/2/2017 8 538
8/1/2017 10 530
7/31/2017 8 520
7/30/2017 9 512
7/29/2017 10 504
7/28/2017 9 494
7/27/2017 10 485
7/26/2017 10 475
7/25/2017 10 465
7/24/2017 10 455
7/23/2017 10 445
7/22/2017 10 435
7/21/2017 10 425
7/20/2017 10 415
7/19/2017 9 405
7/18/2017 10 397
7/17/2017 10 387
7/16/2017 10 377
7/15/2017 10 367
7/14/2017 10 357
7/13/2017 9 347
7/12/2017 8 338
7/11/2017 10 330
7/10/2017 10 320
7/9/2017 10 310
7/8/2017 10 300
7/7/2017 10 290
7/6/2017 10 280
7/5/2017 9 271
7/4/2017 9 262
7/3/2017 10 253
7/2/2017 9 243
7/1/2017 9 234
6/30/2017 9 225
6/29/2017 9 216
6/28/2017 10 207
6/27/2017 10 197
6/26/2017 9 187
6/25/2017 6 178
6/24/2017 4 173
6/23/2017 7 168
6/22/2017 9 161
6/21/2017 9 152
6/20/2017 9 143
6/19/2017 8 134
6/18/2017 8 126
6/17/2017 8 118
6/16/2017 9 110
6/15/2017 9 101
6/14/2017 9 92
6/13/2017 9 83
6/12/2017 10 74
6/11/2017 10 65
6/10/2017 10 55
6/9/2017 10 45
6/8/2017 10 35
6/7/2017 10 26
6/6/2017 10 16
6/5/2017 6 6