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 7.2061 2017-05-15 00:00:00.0 7.2061 318
2 15.0505 2017-05-16 00:00:00.0 7.8444 318
3 16.5602 2017-05-17 00:00:00.0 1.5097 318
4 16.7025 2017-05-18 00:00:00.0 0.1423 318
5 18.2122 2017-05-19 00:00:00.0 1.5097 318
6 24.6974 2017-05-20 00:00:00.0 6.4852 318
7 29.0724 2017-05-21 00:00:00.0 4.3750 318
8 35.3862 2017-05-22 00:00:00.0 6.3138 318
9 42.8862 2017-05-23 00:00:00.0 7.5000 318
10 50.9250 2017-05-24 00:00:00.0 8.0388 318
11 58.9638 2017-05-25 00:00:00.0 8.0388 318
12 65.6164 2017-05-26 00:00:00.0 6.6526 318
13 72.7465 2017-05-27 00:00:00.0 7.1301 318
14 78.9730 2017-05-28 00:00:00.0 6.2265 318
15 82.6868 2017-05-29 00:00:00.0 3.7138 318
16 89.8169 2017-05-30 00:00:00.0 7.1301 318
17 97.9184 2017-05-31 00:00:00.0 8.1015 318
18 107.7531 2017-06-01 00:00:00.0 9.8347 318
19 113.1593 2017-06-02 00:00:00.0 5.4062 318
20 123.1180 2017-06-03 00:00:00.0 9.9587 318
21 132.5282 2017-06-04 00:00:00.0 9.4102 318
22 142.4955 2017-06-05 00:00:00.0 9.9673 318
23 151.8705 2017-06-06 00:00:00.0 9.3750 318
24 161.0945 2017-06-07 00:00:00.0 9.2240 318
25 170.6042 2017-06-08 00:00:00.0 9.5097 318
26 180.3792 2017-06-09 00:00:00.0 9.7750 318
27 190.1751 2017-06-10 00:00:00.0 9.7959 318
28 198.9996 2017-06-11 00:00:00.0 8.8245 318
29 207.4562 2017-06-12 00:00:00.0 8.4566 318
30 215.1659 2017-06-13 00:00:00.0 7.7097 318
31 224.1781 2017-06-14 00:00:00.0 9.0122 318
32 232.8511 2017-06-15 00:00:00.0 8.6730 318
33 241.5241 2017-06-16 00:00:00.0 8.6730 318
34 249.6874 2017-06-17 00:00:00.0 8.1633 318
35 257.0425 2017-06-18 00:00:00.0 7.3551 318
36 265.8175 2017-06-19 00:00:00.0 8.7750 318
37 274.0415 2017-06-20 00:00:00.0 8.2240 318
38 283.3048 2017-06-21 00:00:00.0 9.2633 318
39 290.9456 2017-06-22 00:00:00.0 7.6408 318
40 297.1721 2017-06-23 00:00:00.0 6.2265 318
41 302.1716 2017-06-24 00:00:00.0 4.9995 318
42 308.3099 2017-06-25 00:00:00.0 6.1383 318
43 315.5160 2017-06-26 00:00:00.0 7.2061 318
44 325.4160 2017-06-27 00:00:00.0 9.9000 318
45 335.2686 2017-06-28 00:00:00.0 9.8526 318
46 344.8395 2017-06-29 00:00:00.0 9.5709 318
47 353.6145 2017-06-30 00:00:00.0 8.7750 318
48 362.1813 2017-07-01 00:00:00.0 8.5668 318
49 370.2828 2017-07-02 00:00:00.0 8.1015 318
50 380.2630 2017-07-03 00:00:00.0 9.9802 318
51 390.0852 2017-07-04 00:00:00.0 9.8222 318
52 400.0770 2017-07-05 00:00:00.0 9.9918 318
53 410.0443 2017-07-06 00:00:00.0 9.9673 318
54 419.9933 2017-07-07 00:00:00.0 9.9490 318
55 429.9606 2017-07-08 00:00:00.0 9.9673 318
56 439.9408 2017-07-09 00:00:00.0 9.9802 318
57 449.9396 2017-07-10 00:00:00.0 9.9988 318
58 459.9146 2017-07-11 00:00:00.0 9.9750 318
59 468.7391 2017-07-12 00:00:00.0 8.8245 318
60 477.6121 2017-07-13 00:00:00.0 8.8730 318
61 487.5331 2017-07-14 00:00:00.0 9.9210 318
62 497.4469 2017-07-15 00:00:00.0 9.9138 318
63 507.2627 2017-07-16 00:00:00.0 9.8158 318
64 517.0586 2017-07-17 00:00:00.0 9.7959 318
65 525.5708 2017-07-18 00:00:00.0 8.5122 318
66 535.0484 2017-07-19 00:00:00.0 9.4776 318
67 544.5892 2017-07-20 00:00:00.0 9.5408 318
68 554.4418 2017-07-21 00:00:00.0 9.8526 318
69 564.2168 2017-07-22 00:00:00.0 9.7750 318
70 573.9469 2017-07-23 00:00:00.0 9.7301 318
71 583.7691 2017-07-24 00:00:00.0 9.8222 318
72 593.5222 2017-07-25 00:00:00.0 9.7531 318
73 603.5210 2017-07-26 00:00:00.0 9.9988 318
74 613.5012 2017-07-27 00:00:00.0 9.9802 318
75 623.2592 2017-07-28 00:00:00.0 9.7580 318
76 633.0172 2017-07-29 00:00:00.0 9.7580 318
77 642.5715 2017-07-30 00:00:00.0 9.5543 318
78 650.7888 2017-07-31 00:00:00.0 8.2173 318
79 660.5419 2017-08-01 00:00:00.0 9.7531 318
80 668.3195 2017-08-02 00:00:00.0 7.7776 318
81 677.4195 2017-08-03 00:00:00.0 9.1000 318
82 687.0195 2017-08-04 00:00:00.0 9.6000 318
83 696.4297 2017-08-05 00:00:00.0 9.4102 318
84 705.5720 2017-08-06 00:00:00.0 9.1423 318
85 715.4985 2017-08-07 00:00:00.0 9.9265 318
86 725.4572 2017-08-08 00:00:00.0 9.9587 318
87 734.3302 2017-08-09 00:00:00.0 8.8730 318
88 743.8399 2017-08-10 00:00:00.0 9.5097 318
89 753.4950 2017-08-11 00:00:00.0 9.6551 318
90 763.1761 2017-08-12 00:00:00.0 9.6811 318
91 772.8822 2017-08-13 00:00:00.0 9.7061 318
92 782.6572 2017-08-14 00:00:00.0 9.7750 318
93 791.5776 2017-08-15 00:00:00.0 8.9204 318
94 801.4123 2017-08-16 00:00:00.0 9.8347 318
95 811.0123 2017-08-17 00:00:00.0 9.6000 318
96 820.9388 2017-08-18 00:00:00.0 9.9265 318
97 830.9277 2017-08-19 00:00:00.0 9.9889 318
98 839.8945 2017-08-20 00:00:00.0 8.9668 318
99 848.5675 2017-08-21 00:00:00.0 8.6730 318
100 856.9098 2017-08-22 00:00:00.0 8.3423 318
101 863.6445 2017-08-23 00:00:00.0 6.7347 318
102 871.2853 2017-08-24 00:00:00.0 7.6408 318
103 881.2236 2017-08-25 00:00:00.0 9.9383 318
104 890.9767 2017-08-26 00:00:00.0 9.7531 318
105 900.4864 2017-08-27 00:00:00.0 9.5097 318
106 910.4614 2017-08-28 00:00:00.0 9.9750 318
107 920.4568 2017-08-29 00:00:00.0 9.9954 318
108 928.8568 2017-08-30 00:00:00.0 8.4000 318
109 938.5869 2017-08-31 00:00:00.0 9.7301 318
110 948.5007 2017-09-01 00:00:00.0 9.9138 318
111 958.2757 2017-09-02 00:00:00.0 9.7750 318
112 967.6859 2017-09-03 00:00:00.0 9.4102 318
113 975.1859 2017-09-04 00:00:00.0 7.5000 318
114 981.5859 2017-09-05 00:00:00.0 6.4000 318
115 989.4961 2017-09-06 00:00:00.0 7.9102 318
116 998.1165 2017-09-07 00:00:00.0 8.6204 318
117 1005.3976 2017-09-08 00:00:00.0 7.2811 318
118 1015.1507 2017-09-09 00:00:00.0 9.7531 318
119 1024.7507 2017-09-10 00:00:00.0 9.6000 318
120 1033.8930 2017-09-11 00:00:00.0 9.1423 318
121 1043.8848 2017-09-12 00:00:00.0 9.9918 318
122 1052.7093 2017-09-13 00:00:00.0 8.8245 318
123 1059.1093 2017-09-14 00:00:00.0 6.4000 318
124 1062.0052 2017-09-15 00:00:00.0 2.8959 318
125 1063.6460 2017-09-16 00:00:00.0 1.6408 318
126 1066.4210 2017-09-17 00:00:00.0 2.7750 318
127 1071.8164 2017-09-18 00:00:00.0 5.3954 318
128 1078.1302 2017-09-19 00:00:00.0 6.3138 318
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '318') 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 6 1078
9/18/2017 5 1072
9/17/2017 3 1066
9/16/2017 2 1064
9/15/2017 3 1062
9/14/2017 6 1059
9/13/2017 9 1053
9/12/2017 10 1044
9/11/2017 9 1034
9/10/2017 10 1025
9/9/2017 10 1015
9/8/2017 7 1005
9/7/2017 9 998
9/6/2017 8 989
9/5/2017 6 982
9/4/2017 8 975
9/3/2017 9 968
9/2/2017 10 958
9/1/2017 10 949
8/31/2017 10 939
8/30/2017 8 929
8/29/2017 10 920
8/28/2017 10 910
8/27/2017 10 900
8/26/2017 10 891
8/25/2017 10 881
8/24/2017 8 871
8/23/2017 7 864
8/22/2017 8 857
8/21/2017 9 849
8/20/2017 9 840
8/19/2017 10 831
8/18/2017 10 821
8/17/2017 10 811
8/16/2017 10 801
8/15/2017 9 792
8/14/2017 10 783
8/13/2017 10 773
8/12/2017 10 763
8/11/2017 10 753
8/10/2017 10 744
8/9/2017 9 734
8/8/2017 10 725
8/7/2017 10 715
8/6/2017 9 706
8/5/2017 9 696
8/4/2017 10 687
8/3/2017 9 677
8/2/2017 8 668
8/1/2017 10 661
7/31/2017 8 651
7/30/2017 10 643
7/29/2017 10 633
7/28/2017 10 623
7/27/2017 10 614
7/26/2017 10 604
7/25/2017 10 594
7/24/2017 10 584
7/23/2017 10 574
7/22/2017 10 564
7/21/2017 10 554
7/20/2017 10 545
7/19/2017 9 535
7/18/2017 9 526
7/17/2017 10 517
7/16/2017 10 507
7/15/2017 10 497
7/14/2017 10 488
7/13/2017 9 478
7/12/2017 9 469
7/11/2017 10 460
7/10/2017 10 450
7/9/2017 10 440
7/8/2017 10 430
7/7/2017 10 420
7/6/2017 10 410
7/5/2017 10 400
7/4/2017 10 390
7/3/2017 10 380
7/2/2017 8 370
7/1/2017 9 362
6/30/2017 9 354
6/29/2017 10 345
6/28/2017 10 335
6/27/2017 10 325
6/26/2017 7 316
6/25/2017 6 308
6/24/2017 5 302
6/23/2017 6 297
6/22/2017 8 291
6/21/2017 9 283
6/20/2017 8 274
6/19/2017 9 266
6/18/2017 7 257
6/17/2017 8 250
6/16/2017 9 242
6/15/2017 9 233
6/14/2017 9 224
6/13/2017 8 215
6/12/2017 8 207
6/11/2017 9 199
6/10/2017 10 190
6/9/2017 10 180
6/8/2017 10 171
6/7/2017 9 161
6/6/2017 9 152
6/5/2017 10 142
6/4/2017 9 133
6/3/2017 10 123
6/2/2017 5 113
6/1/2017 10 108
5/31/2017 8 98
5/30/2017 7 90
5/29/2017 4 83
5/28/2017 6 79
5/27/2017 7 73
5/26/2017 7 66
5/25/2017 8 59
5/24/2017 8 51
5/23/2017 8 43
5/22/2017 6 35
5/21/2017 4 29
5/20/2017 6 25
5/19/2017 2 18
5/18/2017 0 17
5/17/2017 2 17
5/16/2017 8 15
5/15/2017 7 7