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.5728 2017-06-05 00:00:00.0 8.5728 471
2 18.3642 2017-06-06 00:00:00.0 9.7914 471
3 28.0943 2017-06-07 00:00:00.0 9.7301 471
4 38.0208 2017-06-08 00:00:00.0 9.9265 471
5 47.7958 2017-06-09 00:00:00.0 9.7750 471
6 57.4769 2017-06-10 00:00:00.0 9.6811 471
7 66.9866 2017-06-11 00:00:00.0 9.5097 471
8 75.7616 2017-06-12 00:00:00.0 8.7750 471
9 84.7284 2017-06-13 00:00:00.0 8.9668 471
10 93.7406 2017-06-14 00:00:00.0 9.0122 471
11 102.1406 2017-06-15 00:00:00.0 8.4000 471
12 109.6406 2017-06-16 00:00:00.0 7.5000 471
13 116.8467 2017-06-17 00:00:00.0 7.2061 471
14 123.8998 2017-06-18 00:00:00.0 7.0531 471
15 131.3279 2017-06-19 00:00:00.0 7.4281 471
16 139.7845 2017-06-20 00:00:00.0 8.4566 471
17 148.1268 2017-06-21 00:00:00.0 8.3423 471
18 156.1018 2017-06-22 00:00:00.0 7.9750 471
19 162.6712 2017-06-23 00:00:00.0 6.5694 471
20 167.1528 2017-06-24 00:00:00.0 4.4816 471
21 173.1115 2017-06-25 00:00:00.0 5.9587 471
22 181.5681 2017-06-26 00:00:00.0 8.4566 471
23 191.3640 2017-06-27 00:00:00.0 9.7959 471
24 201.1171 2017-06-28 00:00:00.0 9.7531 471
25 210.3411 2017-06-29 00:00:00.0 9.2240 471
26 218.9615 2017-06-30 00:00:00.0 8.6204 471
27 227.7860 2017-07-01 00:00:00.0 8.8245 471
28 236.6105 2017-07-02 00:00:00.0 8.8245 471
29 246.5977 2017-07-03 00:00:00.0 9.9872 471
30 256.5533 2017-07-04 00:00:00.0 9.9556 471
31 266.4743 2017-07-05 00:00:00.0 9.9210 471
32 276.4694 2017-07-06 00:00:00.0 9.9951 471
33 286.2444 2017-07-07 00:00:00.0 9.7750 471
34 296.2362 2017-07-08 00:00:00.0 9.9918 471
35 306.2112 2017-07-09 00:00:00.0 9.9750 471
36 316.2092 2017-07-10 00:00:00.0 9.9980 471
37 325.6536 2017-07-11 00:00:00.0 9.4444 471
38 334.8776 2017-07-12 00:00:00.0 9.2240 471
39 344.1409 2017-07-13 00:00:00.0 9.2633 471
40 354.1281 2017-07-14 00:00:00.0 9.9872 471
41 364.1031 2017-07-15 00:00:00.0 9.9750 471
42 374.0296 2017-07-16 00:00:00.0 9.9265 471
43 384.0098 2017-07-17 00:00:00.0 9.9802 471
44 393.1098 2017-07-18 00:00:00.0 9.1000 471
45 402.6195 2017-07-19 00:00:00.0 9.5097 471
46 412.2195 2017-07-20 00:00:00.0 9.6000 471
47 422.0721 2017-07-21 00:00:00.0 9.8526 471
48 431.4109 2017-07-22 00:00:00.0 9.3388 471
49 441.2456 2017-07-23 00:00:00.0 9.8347 471
50 451.1851 2017-07-24 00:00:00.0 9.9395 471
51 461.1601 2017-07-25 00:00:00.0 9.9750 471
52 471.1519 2017-07-26 00:00:00.0 9.9918 471
53 481.1321 2017-07-27 00:00:00.0 9.9802 471
54 490.8901 2017-07-28 00:00:00.0 9.7580 471
55 500.8111 2017-07-29 00:00:00.0 9.9210 471
56 510.3173 2017-07-30 00:00:00.0 9.5062 471
57 519.4827 2017-07-31 00:00:00.0 9.1654 471
58 529.3521 2017-08-01 00:00:00.0 9.8694 471
59 537.9189 2017-08-02 00:00:00.0 8.5668 471
60 546.5919 2017-08-03 00:00:00.0 8.6730 471
61 555.8159 2017-08-04 00:00:00.0 9.2240 471
62 564.9582 2017-08-05 00:00:00.0 9.1423 471
63 574.1822 2017-08-06 00:00:00.0 9.2240 471
64 583.9980 2017-08-07 00:00:00.0 9.8158 471
65 593.6791 2017-08-08 00:00:00.0 9.6811 471
66 602.7791 2017-08-09 00:00:00.0 9.1000 471
67 612.4072 2017-08-10 00:00:00.0 9.6281 471
68 622.1986 2017-08-12 00:00:00.0 9.7914 471
69 631.8797 2017-08-13 00:00:00.0 9.6811 471
70 641.6328 2017-08-14 00:00:00.0 9.7531 471
71 651.1425 2017-08-15 00:00:00.0 9.5097 471
72 660.8726 2017-08-16 00:00:00.0 9.7301 471
73 670.3502 2017-08-17 00:00:00.0 9.4776 471
74 680.1849 2017-08-18 00:00:00.0 9.8347 471
75 690.1651 2017-08-19 00:00:00.0 9.9802 471
76 699.7651 2017-08-20 00:00:00.0 9.6000 471
77 707.8666 2017-08-21 00:00:00.0 8.1015 471
78 716.0299 2017-08-22 00:00:00.0 8.1633 471
79 722.4299 2017-08-23 00:00:00.0 6.4000 471
80 728.9993 2017-08-24 00:00:00.0 6.5694 471
81 738.5090 2017-08-25 00:00:00.0 9.5097 471
82 747.8478 2017-08-26 00:00:00.0 9.3388 471
83 757.5289 2017-08-27 00:00:00.0 9.6811 471
84 767.5105 2017-08-28 00:00:00.0 9.9816 471
85 777.4778 2017-08-29 00:00:00.0 9.9673 471
86 786.6615 2017-08-30 00:00:00.0 9.1837 471
87 796.1712 2017-08-31 00:00:00.0 9.5097 471
88 805.9243 2017-09-01 00:00:00.0 9.7531 471
89 815.1483 2017-09-02 00:00:00.0 9.2240 471
90 824.2049 2017-09-03 00:00:00.0 9.0566 471
91 832.4289 2017-09-04 00:00:00.0 8.2240 471
92 839.6350 2017-09-05 00:00:00.0 7.2061 471
93 846.0350 2017-09-06 00:00:00.0 6.4000 471
94 855.0018 2017-09-07 00:00:00.0 8.9668 471
95 862.5018 2017-09-08 00:00:00.0 7.5000 471
96 871.7258 2017-09-09 00:00:00.0 9.2240 471
97 881.6023 2017-09-10 00:00:00.0 9.8765 471
98 891.3554 2017-09-11 00:00:00.0 9.7531 471
99 901.3505 2017-09-12 00:00:00.0 9.9951 471
100 910.2235 2017-09-13 00:00:00.0 8.8730 471
101 916.5373 2017-09-14 00:00:00.0 6.3138 471
102 920.6960 2017-09-15 00:00:00.0 4.1587 471
103 922.7241 2017-09-16 00:00:00.0 2.0281 471
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '471') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
9/16/2017 2 923
9/15/2017 4 921
9/14/2017 6 917
9/13/2017 9 910
9/12/2017 10 901
9/11/2017 10 891
9/10/2017 10 882
9/9/2017 9 872
9/8/2017 8 863
9/7/2017 9 855
9/6/2017 6 846
9/5/2017 7 840
9/4/2017 8 832
9/3/2017 9 824
9/2/2017 9 815
9/1/2017 10 806
8/31/2017 10 796
8/30/2017 9 787
8/29/2017 10 777
8/28/2017 10 768
8/27/2017 10 758
8/26/2017 9 748
8/25/2017 10 739
8/24/2017 7 729
8/23/2017 6 722
8/22/2017 8 716
8/21/2017 8 708
8/20/2017 10 700
8/19/2017 10 690
8/18/2017 10 680
8/17/2017 9 670
8/16/2017 10 661
8/15/2017 10 651
8/14/2017 10 642
8/13/2017 10 632
8/12/2017 10 622
8/10/2017 10 612
8/9/2017 9 603
8/8/2017 10 594
8/7/2017 10 584
8/6/2017 9 574
8/5/2017 9 565
8/4/2017 9 556
8/3/2017 9 547
8/2/2017 9 538
8/1/2017 10 529
7/31/2017 9 519
7/30/2017 10 510
7/29/2017 10 501
7/28/2017 10 491
7/27/2017 10 481
7/26/2017 10 471
7/25/2017 10 461
7/24/2017 10 451
7/23/2017 10 441
7/22/2017 9 431
7/21/2017 10 422
7/20/2017 10 412
7/19/2017 10 403
7/18/2017 9 393
7/17/2017 10 384
7/16/2017 10 374
7/15/2017 10 364
7/14/2017 10 354
7/13/2017 9 344
7/12/2017 9 335
7/11/2017 9 326
7/10/2017 10 316
7/9/2017 10 306
7/8/2017 10 296
7/7/2017 10 286
7/6/2017 10 276
7/5/2017 10 266
7/4/2017 10 257
7/3/2017 10 247
7/2/2017 9 237
7/1/2017 9 228
6/30/2017 9 219
6/29/2017 9 210
6/28/2017 10 201
6/27/2017 10 191
6/26/2017 8 182
6/25/2017 6 173
6/24/2017 4 167
6/23/2017 7 163
6/22/2017 8 156
6/21/2017 8 148
6/20/2017 8 140
6/19/2017 7 131
6/18/2017 7 124
6/17/2017 7 117
6/16/2017 8 110
6/15/2017 8 102
6/14/2017 9 94
6/13/2017 9 85
6/12/2017 9 76
6/11/2017 10 67
6/10/2017 10 57
6/9/2017 10 48
6/8/2017 10 38
6/7/2017 10 28
6/6/2017 10 18
6/5/2017 9 9