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.8730 2017-05-15 00:00:00.0 8.8730 325
2 16.7832 2017-05-16 00:00:00.0 7.9102 325
3 17.3465 2017-05-17 00:00:00.0 0.5633 325
4 17.3465 2017-05-18 00:00:00.0 0.0000 325
5 21.5052 2017-05-19 00:00:00.0 4.1587 325
6 28.1578 2017-05-20 00:00:00.0 6.6526 325
7 31.4104 2017-05-21 00:00:00.0 3.2526 325
8 36.6099 2017-05-22 00:00:00.0 5.1995 325
9 44.0380 2017-05-23 00:00:00.0 7.4281 325
10 52.4946 2017-05-24 00:00:00.0 8.4566 325
11 59.6247 2017-05-25 00:00:00.0 7.1301 325
12 67.8487 2017-05-26 00:00:00.0 8.2240 325
13 76.1910 2017-05-27 00:00:00.0 8.3423 325
14 81.3905 2017-05-28 00:00:00.0 5.1995 325
15 83.5456 2017-05-29 00:00:00.0 2.1551 325
16 89.8594 2017-05-30 00:00:00.0 6.3138 325
17 98.6839 2017-05-31 00:00:00.0 8.8245 325
18 108.6530 2017-06-01 00:00:00.0 9.9691 325
19 117.3086 2017-06-02 00:00:00.0 8.6556 325
20 127.2086 2017-06-03 00:00:00.0 9.9000 325
21 136.8086 2017-06-04 00:00:00.0 9.6000 325
22 146.6851 2017-06-05 00:00:00.0 9.8765 325
23 156.5851 2017-06-06 00:00:00.0 9.9000 325
24 166.0627 2017-06-07 00:00:00.0 9.4776 325
25 176.0581 2017-06-08 00:00:00.0 9.9954 325
26 185.9433 2017-06-09 00:00:00.0 9.8852 325
27 195.7591 2017-06-10 00:00:00.0 9.8158 325
28 205.4142 2017-06-11 00:00:00.0 9.6551 325
29 214.5979 2017-06-12 00:00:00.0 9.1837 325
30 223.8994 2017-06-13 00:00:00.0 9.3015 325
31 233.1234 2017-06-14 00:00:00.0 9.2240 325
32 241.7964 2017-06-15 00:00:00.0 8.6730 325
33 249.5061 2017-06-16 00:00:00.0 7.7097 325
34 256.7872 2017-06-17 00:00:00.0 7.2811 325
35 263.8403 2017-06-18 00:00:00.0 7.0531 325
36 271.2684 2017-06-19 00:00:00.0 7.4281 325
37 279.6107 2017-06-20 00:00:00.0 8.3423 325
38 288.1775 2017-06-21 00:00:00.0 8.5668 325
39 296.6341 2017-06-22 00:00:00.0 8.4566 325
40 303.3688 2017-06-23 00:00:00.0 6.7347 325
41 307.6361 2017-06-24 00:00:00.0 4.2673 325
42 313.3177 2017-06-25 00:00:00.0 5.6816 325
43 321.9907 2017-06-26 00:00:00.0 8.6730 325
44 331.8601 2017-06-27 00:00:00.0 9.8694 325
45 341.6560 2017-06-28 00:00:00.0 9.7959 325
46 350.8397 2017-06-29 00:00:00.0 9.1837 325
47 359.5642 2017-06-30 00:00:00.0 8.7245 325
48 368.2372 2017-07-01 00:00:00.0 8.6730 325
49 376.9102 2017-07-02 00:00:00.0 8.6730 325
50 386.8775 2017-07-03 00:00:00.0 9.9673 325
51 396.8466 2017-07-04 00:00:00.0 9.9691 325
52 406.6972 2017-07-05 00:00:00.0 9.8506 325
53 416.6926 2017-07-06 00:00:00.0 9.9954 325
54 426.3737 2017-07-07 00:00:00.0 9.6811 325
55 436.3717 2017-07-08 00:00:00.0 9.9980 325
56 446.3467 2017-07-09 00:00:00.0 9.9750 325
57 456.3385 2017-07-10 00:00:00.0 9.9918 325
58 465.9385 2017-07-11 00:00:00.0 9.6000 325
59 474.8589 2017-07-12 00:00:00.0 8.9204 325
60 484.0829 2017-07-13 00:00:00.0 9.2240 325
61 494.0502 2017-07-14 00:00:00.0 9.9673 325
62 504.0089 2017-07-15 00:00:00.0 9.9587 325
63 513.8783 2017-07-16 00:00:00.0 9.8694 325
64 523.7783 2017-07-17 00:00:00.0 9.9000 325
65 533.1885 2017-07-18 00:00:00.0 9.4102 325
66 542.6329 2017-07-19 00:00:00.0 9.4444 325
67 552.2038 2017-07-20 00:00:00.0 9.5709 325
68 562.0732 2017-07-21 00:00:00.0 9.8694 325
69 571.3365 2017-07-22 00:00:00.0 9.2633 325
70 581.1712 2017-07-23 00:00:00.0 9.8347 325
71 591.1403 2017-07-24 00:00:00.0 9.9691 325
72 601.1153 2017-07-25 00:00:00.0 9.9750 325
73 611.1107 2017-07-26 00:00:00.0 9.9954 325
74 621.1095 2017-07-27 00:00:00.0 9.9988 325
75 630.9317 2017-07-28 00:00:00.0 9.8222 325
76 640.8527 2017-07-29 00:00:00.0 9.9210 325
77 650.4959 2017-07-30 00:00:00.0 9.6432 325
78 659.6613 2017-07-31 00:00:00.0 9.1654 325
79 669.5751 2017-08-01 00:00:00.0 9.9138 325
80 677.8588 2017-08-02 00:00:00.0 8.2837 325
81 686.5318 2017-08-03 00:00:00.0 8.6730 325
82 695.6741 2017-08-04 00:00:00.0 9.1423 325
83 704.7307 2017-08-05 00:00:00.0 9.0566 325
84 713.7429 2017-08-06 00:00:00.0 9.0122 325
85 723.5776 2017-08-07 00:00:00.0 9.8347 325
86 733.2057 2017-08-08 00:00:00.0 9.6281 325
87 742.3894 2017-08-09 00:00:00.0 9.1837 325
88 751.8338 2017-08-10 00:00:00.0 9.4444 325
89 761.3114 2017-08-11 00:00:00.0 9.4776 325
90 770.9114 2017-08-12 00:00:00.0 9.6000 325
91 780.6415 2017-08-13 00:00:00.0 9.7301 325
92 790.4374 2017-08-14 00:00:00.0 9.7959 325
93 800.0925 2017-08-15 00:00:00.0 9.6551 325
94 809.9083 2017-08-16 00:00:00.0 9.8158 325
95 819.4792 2017-08-17 00:00:00.0 9.5709 325
96 829.3792 2017-08-18 00:00:00.0 9.9000 325
97 839.3483 2017-08-19 00:00:00.0 9.9691 325
98 849.1014 2017-08-20 00:00:00.0 9.7531 325
99 857.5014 2017-08-21 00:00:00.0 8.4000 325
100 866.1218 2017-08-22 00:00:00.0 8.6204 325
101 872.4356 2017-08-23 00:00:00.0 6.3138 325
102 879.0882 2017-08-24 00:00:00.0 6.6526 325
103 888.4984 2017-08-25 00:00:00.0 9.4102 325
104 897.9428 2017-08-26 00:00:00.0 9.4444 325
105 907.7775 2017-08-27 00:00:00.0 9.8347 325
106 917.7755 2017-08-28 00:00:00.0 9.9980 325
107 927.7709 2017-08-29 00:00:00.0 9.9954 325
108 936.3913 2017-08-30 00:00:00.0 8.6204 325
109 945.9321 2017-08-31 00:00:00.0 9.5408 325
110 955.6622 2017-09-01 00:00:00.0 9.7301 325
111 965.2903 2017-09-02 00:00:00.0 9.6281 325
112 974.4740 2017-09-03 00:00:00.0 9.1837 325
113 983.0408 2017-09-04 00:00:00.0 8.5668 325
114 990.0158 2017-09-05 00:00:00.0 6.9750 325
115 996.2423 2017-09-06 00:00:00.0 6.2265 325
116 1005.5811 2017-09-07 00:00:00.0 9.3388 325
117 1013.3587 2017-09-08 00:00:00.0 7.7776 325
118 1022.7337 2017-09-09 00:00:00.0 9.3750 325
119 1032.4177 2017-09-10 00:00:00.0 9.6840 325
120 1042.3442 2017-09-11 00:00:00.0 9.9265 325
121 1052.1022 2017-09-12 00:00:00.0 9.7580 325
122 1060.7752 2017-09-13 00:00:00.0 8.6730 325
123 1067.0890 2017-09-14 00:00:00.0 6.3138 325
124 1071.0273 2017-09-15 00:00:00.0 3.9383 325
125 1072.7982 2017-09-16 00:00:00.0 1.7709 325
126 1075.8140 2017-09-17 00:00:00.0 3.0158 325
127 1081.5890 2017-09-18 00:00:00.0 5.7750 325
128 1089.4992 2017-09-19 00:00:00.0 7.9102 325
CACHED false
EXECUTIONTIME 4
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '325') 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 1089
9/18/2017 6 1082
9/17/2017 3 1076
9/16/2017 2 1073
9/15/2017 4 1071
9/14/2017 6 1067
9/13/2017 9 1061
9/12/2017 10 1052
9/11/2017 10 1042
9/10/2017 10 1032
9/9/2017 9 1023
9/8/2017 8 1013
9/7/2017 9 1006
9/6/2017 6 996
9/5/2017 7 990
9/4/2017 9 983
9/3/2017 9 974
9/2/2017 10 965
9/1/2017 10 956
8/31/2017 10 946
8/30/2017 9 936
8/29/2017 10 928
8/28/2017 10 918
8/27/2017 10 908
8/26/2017 9 898
8/25/2017 9 888
8/24/2017 7 879
8/23/2017 6 872
8/22/2017 9 866
8/21/2017 8 858
8/20/2017 10 849
8/19/2017 10 839
8/18/2017 10 829
8/17/2017 10 819
8/16/2017 10 810
8/15/2017 10 800
8/14/2017 10 790
8/13/2017 10 781
8/12/2017 10 771
8/11/2017 9 761
8/10/2017 9 752
8/9/2017 9 742
8/8/2017 10 733
8/7/2017 10 724
8/6/2017 9 714
8/5/2017 9 705
8/4/2017 9 696
8/3/2017 9 687
8/2/2017 8 678
8/1/2017 10 670
7/31/2017 9 660
7/30/2017 10 650
7/29/2017 10 641
7/28/2017 10 631
7/27/2017 10 621
7/26/2017 10 611
7/25/2017 10 601
7/24/2017 10 591
7/23/2017 10 581
7/22/2017 9 571
7/21/2017 10 562
7/20/2017 10 552
7/19/2017 9 543
7/18/2017 9 533
7/17/2017 10 524
7/16/2017 10 514
7/15/2017 10 504
7/14/2017 10 494
7/13/2017 9 484
7/12/2017 9 475
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 417
7/5/2017 10 407
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 9 322
6/25/2017 6 313
6/24/2017 4 308
6/23/2017 7 303
6/22/2017 8 297
6/21/2017 9 288
6/20/2017 8 280
6/19/2017 7 271
6/18/2017 7 264
6/17/2017 7 257
6/16/2017 8 250
6/15/2017 9 242
6/14/2017 9 233
6/13/2017 9 224
6/12/2017 9 215
6/11/2017 10 205
6/10/2017 10 196
6/9/2017 10 186
6/8/2017 10 176
6/7/2017 9 166
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 90
5/29/2017 2 84
5/28/2017 5 81
5/27/2017 8 76
5/26/2017 8 68
5/25/2017 7 60
5/24/2017 8 52
5/23/2017 7 44
5/22/2017 5 37
5/21/2017 3 31
5/20/2017 7 28
5/19/2017 4 22
5/18/2017 0 17
5/17/2017 1 17
5/16/2017 8 17
5/15/2017 9 9