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 237
2 17.0485 2017-05-16 00:00:00.0 7.7097 237
3 18.5582 2017-05-17 00:00:00.0 1.5097 237
4 18.8419 2017-05-18 00:00:00.0 0.2837 237
5 23.2169 2017-05-19 00:00:00.0 4.3750 237
6 29.1756 2017-05-20 00:00:00.0 5.9587 237
7 31.5817 2017-05-21 00:00:00.0 2.4061 237
8 35.5200 2017-05-22 00:00:00.0 3.9383 237
9 42.9481 2017-05-23 00:00:00.0 7.4281 237
10 51.1114 2017-05-24 00:00:00.0 8.1633 237
11 58.7522 2017-05-25 00:00:00.0 7.6408 237
12 66.7910 2017-05-26 00:00:00.0 8.0388 237
13 75.3032 2017-05-27 00:00:00.0 8.5122 237
14 80.7950 2017-05-28 00:00:00.0 5.4918 237
15 83.0761 2017-05-29 00:00:00.0 2.2811 237
16 89.4761 2017-05-30 00:00:00.0 6.4000 237
17 98.5761 2017-05-31 00:00:00.0 9.1000 237
18 108.5712 2017-06-01 00:00:00.0 9.9951 237
19 117.3070 2017-06-02 00:00:00.0 8.7358 237
20 127.1576 2017-06-03 00:00:00.0 9.8506 237
21 136.9535 2017-06-04 00:00:00.0 9.7959 237
22 146.9523 2017-06-05 00:00:00.0 9.9988 237
23 156.9523 2017-06-06 00:00:00.0 10.0000 237
24 166.6584 2017-06-07 00:00:00.0 9.7061 237
25 176.6538 2017-06-08 00:00:00.0 9.9954 237
26 186.3349 2017-06-09 00:00:00.0 9.6811 237
27 196.2043 2017-06-10 00:00:00.0 9.8694 237
28 206.0201 2017-06-11 00:00:00.0 9.8158 237
29 215.3216 2017-06-12 00:00:00.0 9.3015 237
30 224.1461 2017-06-13 00:00:00.0 8.8245 237
31 233.5211 2017-06-14 00:00:00.0 9.3750 237
32 242.3941 2017-06-15 00:00:00.0 8.8730 237
33 250.8507 2017-06-16 00:00:00.0 8.4566 237
34 258.4216 2017-06-17 00:00:00.0 7.5709 237
35 265.7027 2017-06-18 00:00:00.0 7.2811 237
36 273.6777 2017-06-19 00:00:00.0 7.9750 237
37 282.4022 2017-06-20 00:00:00.0 8.7245 237
38 290.9690 2017-06-21 00:00:00.0 8.5668 237
39 299.7440 2017-06-22 00:00:00.0 8.7750 237
40 306.8741 2017-06-23 00:00:00.0 7.1301 237
41 311.2491 2017-06-24 00:00:00.0 4.3750 237
42 317.2981 2017-06-25 00:00:00.0 6.0490 237
43 326.3547 2017-06-26 00:00:00.0 9.0566 237
44 336.1506 2017-06-27 00:00:00.0 9.7959 237
45 345.9664 2017-06-28 00:00:00.0 9.8158 237
46 355.2679 2017-06-29 00:00:00.0 9.3015 237
47 364.0429 2017-06-30 00:00:00.0 8.7750 237
48 372.8179 2017-07-01 00:00:00.0 8.7750 237
49 381.8301 2017-07-02 00:00:00.0 9.0122 237
50 391.7566 2017-07-03 00:00:00.0 9.9265 237
51 401.6072 2017-07-04 00:00:00.0 9.8506 237
52 411.1134 2017-07-05 00:00:00.0 9.5062 237
53 421.0529 2017-07-06 00:00:00.0 9.9395 237
54 430.9223 2017-07-07 00:00:00.0 9.8694 237
55 440.7137 2017-07-08 00:00:00.0 9.7914 237
56 450.7125 2017-07-09 00:00:00.0 9.9988 237
57 460.7113 2017-07-10 00:00:00.0 9.9988 237
58 470.5460 2017-07-11 00:00:00.0 9.8347 237
59 479.2705 2017-07-12 00:00:00.0 8.7245 237
60 488.5720 2017-07-13 00:00:00.0 9.3015 237
61 498.5638 2017-07-14 00:00:00.0 9.9918 237
62 508.5618 2017-07-15 00:00:00.0 9.9980 237
63 518.3965 2017-07-16 00:00:00.0 9.8347 237
64 527.6854 2017-07-17 00:00:00.0 9.2889 237
65 537.5012 2017-07-18 00:00:00.0 9.8158 237
66 546.7645 2017-07-19 00:00:00.0 9.2633 237
67 556.5992 2017-07-20 00:00:00.0 9.8347 237
68 566.4844 2017-07-21 00:00:00.0 9.8852 237
69 575.9288 2017-07-22 00:00:00.0 9.4444 237
70 585.8875 2017-07-23 00:00:00.0 9.9587 237
71 595.8863 2017-07-24 00:00:00.0 9.9988 237
72 605.8863 2017-07-25 00:00:00.0 10.0000 237
73 615.8073 2017-07-26 00:00:00.0 9.9210 237
74 625.4913 2017-07-27 00:00:00.0 9.6840 237
75 635.0456 2017-07-28 00:00:00.0 9.5543 237
76 644.5518 2017-07-29 00:00:00.0 9.5062 237
77 653.5839 2017-07-30 00:00:00.0 9.0321 237
78 662.1567 2017-07-31 00:00:00.0 8.5728 237
79 672.1240 2017-08-01 00:00:00.0 9.9673 237
80 680.3480 2017-08-02 00:00:00.0 8.2240 237
81 689.4903 2017-08-03 00:00:00.0 9.1423 237
82 699.0000 2017-08-04 00:00:00.0 9.5097 237
83 708.4776 2017-08-05 00:00:00.0 9.4776 237
84 718.0184 2017-08-06 00:00:00.0 9.5408 237
85 728.0164 2017-08-07 00:00:00.0 9.9980 237
86 737.8322 2017-08-08 00:00:00.0 9.8158 237
87 747.1710 2017-08-09 00:00:00.0 9.3388 237
88 756.9241 2017-08-10 00:00:00.0 9.7531 237
89 766.6772 2017-08-11 00:00:00.0 9.7531 237
90 776.5466 2017-08-12 00:00:00.0 9.8694 237
91 786.4318 2017-08-13 00:00:00.0 9.8852 237
92 796.4134 2017-08-14 00:00:00.0 9.9816 237
93 806.1665 2017-08-15 00:00:00.0 9.7531 237
94 816.0665 2017-08-16 00:00:00.0 9.9000 237
95 825.8415 2017-08-17 00:00:00.0 9.7750 237
96 835.8366 2017-08-18 00:00:00.0 9.9951 237
97 845.1255 2017-08-19 00:00:00.0 9.2889 237
98 855.0520 2017-08-20 00:00:00.0 9.9265 237
99 863.8270 2017-08-21 00:00:00.0 8.7750 237
100 872.7474 2017-08-22 00:00:00.0 8.9204 237
101 879.4821 2017-08-23 00:00:00.0 6.7347 237
102 886.4571 2017-08-24 00:00:00.0 6.9750 237
103 895.9668 2017-08-25 00:00:00.0 9.5097 237
104 905.5076 2017-08-26 00:00:00.0 9.5408 237
105 915.4566 2017-08-27 00:00:00.0 9.9490 237
106 924.7455 2017-08-28 00:00:00.0 9.2889 237
107 934.7344 2017-08-29 00:00:00.0 9.9889 237
108 943.9584 2017-08-30 00:00:00.0 9.2240 237
109 953.3686 2017-08-31 00:00:00.0 9.4102 237
110 963.2538 2017-09-01 00:00:00.0 9.8852 237
111 973.0696 2017-09-02 00:00:00.0 9.8158 237
112 982.8446 2017-09-03 00:00:00.0 9.7750 237
113 991.5176 2017-09-04 00:00:00.0 8.6730 237
114 998.9457 2017-09-05 00:00:00.0 7.4281 237
115 1006.4457 2017-09-06 00:00:00.0 7.5000 237
116 1015.8559 2017-09-07 00:00:00.0 9.4102 237
117 1022.9090 2017-09-08 00:00:00.0 7.0531 237
118 1032.1330 2017-09-09 00:00:00.0 9.2240 237
119 1041.7762 2017-09-10 00:00:00.0 9.6432 237
120 1051.7435 2017-09-11 00:00:00.0 9.9673 237
121 1060.5571 2017-09-12 00:00:00.0 8.8136 237
122 1069.8204 2017-09-13 00:00:00.0 9.2633 237
123 1077.0265 2017-09-14 00:00:00.0 7.2061 237
124 1080.9648 2017-09-15 00:00:00.0 3.9383 237
125 1082.8648 2017-09-16 00:00:00.0 1.9000 237
126 1086.2342 2017-09-17 00:00:00.0 3.3694 237
127 1091.2337 2017-09-18 00:00:00.0 4.9995 237
128 1099.5760 2017-09-19 00:00:00.0 8.3423 237
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '237') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/19/2017 8 1100
9/18/2017 5 1091
9/17/2017 3 1086
9/16/2017 2 1083
9/15/2017 4 1081
9/14/2017 7 1077
9/13/2017 9 1070
9/12/2017 9 1061
9/11/2017 10 1052
9/10/2017 10 1042
9/9/2017 9 1032
9/8/2017 7 1023
9/7/2017 9 1016
9/6/2017 8 1006
9/5/2017 7 999
9/4/2017 9 992
9/3/2017 10 983
9/2/2017 10 973
9/1/2017 10 963
8/31/2017 9 953
8/30/2017 9 944
8/29/2017 10 935
8/28/2017 9 925
8/27/2017 10 915
8/26/2017 10 906
8/25/2017 10 896
8/24/2017 7 886
8/23/2017 7 879
8/22/2017 9 873
8/21/2017 9 864
8/20/2017 10 855
8/19/2017 9 845
8/18/2017 10 836
8/17/2017 10 826
8/16/2017 10 816
8/15/2017 10 806
8/14/2017 10 796
8/13/2017 10 786
8/12/2017 10 777
8/11/2017 10 767
8/10/2017 10 757
8/9/2017 9 747
8/8/2017 10 738
8/7/2017 10 728
8/6/2017 10 718
8/5/2017 9 708
8/4/2017 10 699
8/3/2017 9 689
8/2/2017 8 680
8/1/2017 10 672
7/31/2017 9 662
7/30/2017 9 654
7/29/2017 10 645
7/28/2017 10 635
7/27/2017 10 625
7/26/2017 10 616
7/25/2017 10 606
7/24/2017 10 596
7/23/2017 10 586
7/22/2017 9 576
7/21/2017 10 566
7/20/2017 10 557
7/19/2017 9 547
7/18/2017 10 538
7/17/2017 9 528
7/16/2017 10 518
7/15/2017 10 509
7/14/2017 10 499
7/13/2017 9 489
7/12/2017 9 479
7/11/2017 10 471
7/10/2017 10 461
7/9/2017 10 451
7/8/2017 10 441
7/7/2017 10 431
7/6/2017 10 421
7/5/2017 10 411
7/4/2017 10 402
7/3/2017 10 392
7/2/2017 9 382
7/1/2017 9 373
6/30/2017 9 364
6/29/2017 9 355
6/28/2017 10 346
6/27/2017 10 336
6/26/2017 9 326
6/25/2017 6 317
6/24/2017 4 311
6/23/2017 7 307
6/22/2017 9 300
6/21/2017 9 291
6/20/2017 9 282
6/19/2017 8 274
6/18/2017 7 266
6/17/2017 8 258
6/16/2017 8 251
6/15/2017 9 242
6/14/2017 9 234
6/13/2017 9 224
6/12/2017 9 215
6/11/2017 10 206
6/10/2017 10 196
6/9/2017 10 186
6/8/2017 10 177
6/7/2017 10 167
6/6/2017 10 157
6/5/2017 10 147
6/4/2017 10 137
6/3/2017 10 127
6/2/2017 9 117
6/1/2017 10 109
5/31/2017 9 99
5/30/2017 6 89
5/29/2017 2 83
5/28/2017 5 81
5/27/2017 9 75
5/26/2017 8 67
5/25/2017 8 59
5/24/2017 8 51
5/23/2017 7 43
5/22/2017 4 36
5/21/2017 2 32
5/20/2017 6 29
5/19/2017 4 23
5/18/2017 0 19
5/17/2017 2 19
5/16/2017 8 17
5/15/2017 9 9