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.1301 2017-05-15 00:00:00.0 7.1301 233
2 13.0888 2017-05-16 00:00:00.0 5.9587 233
3 13.0888 2017-05-17 00:00:00.0 0.0000 233
4 13.0888 2017-05-18 00:00:00.0 0.0000 233
5 15.9847 2017-05-19 00:00:00.0 2.8959 233
6 21.8520 2017-05-20 00:00:00.0 5.8673 233
7 24.6270 2017-05-21 00:00:00.0 2.7750 233
8 29.8265 2017-05-22 00:00:00.0 5.1995 233
9 36.5612 2017-05-23 00:00:00.0 6.7347 233
10 43.9893 2017-05-24 00:00:00.0 7.4281 233
11 49.8566 2017-05-25 00:00:00.0 5.8673 233
12 55.2520 2017-05-26 00:00:00.0 5.3954 233
13 61.3010 2017-05-27 00:00:00.0 6.0490 233
14 65.9928 2017-05-28 00:00:00.0 4.6918 233
15 69.1275 2017-05-29 00:00:00.0 3.1347 233
16 74.7147 2017-05-30 00:00:00.0 5.5872 233
17 83.3351 2017-05-31 00:00:00.0 8.6204 233
18 91.8228 2017-06-01 00:00:00.0 8.4877 233
19 101.4228 2017-06-02 00:00:00.0 9.6000 233
20 111.3228 2017-06-03 00:00:00.0 9.9000 233
21 120.8004 2017-06-04 00:00:00.0 9.4776 233
22 130.7269 2017-06-05 00:00:00.0 9.9265 233
23 139.9106 2017-06-06 00:00:00.0 9.1837 233
24 148.9672 2017-06-07 00:00:00.0 9.0566 233
25 158.7203 2017-06-08 00:00:00.0 9.7531 233
26 167.3407 2017-06-09 00:00:00.0 8.6204 233
27 176.5647 2017-06-10 00:00:00.0 9.2240 233
28 185.1315 2017-06-11 00:00:00.0 8.5668 233
29 193.2330 2017-06-12 00:00:00.0 8.1015 233
30 201.1432 2017-06-13 00:00:00.0 7.9102 233
31 208.7840 2017-06-14 00:00:00.0 7.6408 233
32 215.8371 2017-06-15 00:00:00.0 7.0531 233
33 223.4080 2017-06-16 00:00:00.0 7.5709 233
34 229.9774 2017-06-17 00:00:00.0 6.5694 233
35 236.3774 2017-06-18 00:00:00.0 6.4000 233
36 243.2733 2017-06-19 00:00:00.0 6.8959 233
37 250.9830 2017-06-20 00:00:00.0 7.7097 233
38 259.4396 2017-06-21 00:00:00.0 8.4566 233
39 266.6457 2017-06-22 00:00:00.0 7.2061 233
40 271.3375 2017-06-23 00:00:00.0 4.6918 233
41 274.5901 2017-06-24 00:00:00.0 3.2526 233
42 279.8881 2017-06-25 00:00:00.0 5.2980 233
43 287.6657 2017-06-26 00:00:00.0 7.7776 233
44 297.1101 2017-06-27 00:00:00.0 9.4444 233
45 306.8162 2017-06-28 00:00:00.0 9.7061 233
46 315.4892 2017-06-29 00:00:00.0 8.6730 233
47 323.3336 2017-06-30 00:00:00.0 7.8444 233
48 331.6759 2017-07-01 00:00:00.0 8.3423 233
49 339.8999 2017-07-02 00:00:00.0 8.2240 233
50 349.8382 2017-07-03 00:00:00.0 9.9383 233
51 359.8370 2017-07-04 00:00:00.0 9.9988 233
52 369.7135 2017-07-05 00:00:00.0 9.8765 233
53 379.7007 2017-07-06 00:00:00.0 9.9872 233
54 389.3558 2017-07-07 00:00:00.0 9.6551 233
55 399.3553 2017-07-08 00:00:00.0 9.9995 233
56 409.3140 2017-07-09 00:00:00.0 9.9587 233
57 419.3135 2017-07-10 00:00:00.0 9.9995 233
58 428.6150 2017-07-11 00:00:00.0 9.3015 233
59 437.5354 2017-07-12 00:00:00.0 8.9204 233
60 446.7191 2017-07-13 00:00:00.0 9.1837 233
61 456.5885 2017-07-14 00:00:00.0 9.8694 233
62 466.4737 2017-07-15 00:00:00.0 9.8852 233
63 476.3431 2017-07-16 00:00:00.0 9.8694 233
64 486.2569 2017-07-17 00:00:00.0 9.9138 233
65 494.7135 2017-07-18 00:00:00.0 8.4566 233
66 503.8558 2017-07-19 00:00:00.0 9.1423 233
67 513.3002 2017-07-20 00:00:00.0 9.4444 233
68 523.0303 2017-07-21 00:00:00.0 9.7301 233
69 532.2936 2017-07-22 00:00:00.0 9.2633 233
70 542.0467 2017-07-23 00:00:00.0 9.7531 233
71 552.0269 2017-07-24 00:00:00.0 9.9802 233
72 561.3657 2017-07-25 00:00:00.0 9.3388 233
73 571.2657 2017-07-26 00:00:00.0 9.9000 233
74 581.2645 2017-07-27 00:00:00.0 9.9988 233
75 591.1151 2017-07-28 00:00:00.0 9.8506 233
76 601.0842 2017-07-29 00:00:00.0 9.9691 233
77 610.5904 2017-07-30 00:00:00.0 9.5062 233
78 620.1904 2017-07-31 00:00:00.0 9.6000 233
79 629.7613 2017-08-01 00:00:00.0 9.5709 233
80 637.1164 2017-08-02 00:00:00.0 7.3551 233
81 645.7368 2017-08-03 00:00:00.0 8.6204 233
82 655.0756 2017-08-04 00:00:00.0 9.3388 233
83 664.2179 2017-08-05 00:00:00.0 9.1423 233
84 673.2301 2017-08-06 00:00:00.0 9.0122 233
85 682.7077 2017-08-07 00:00:00.0 9.4776 233
86 691.9317 2017-08-08 00:00:00.0 9.2240 233
87 700.0332 2017-08-09 00:00:00.0 8.1015 233
88 709.1332 2017-08-10 00:00:00.0 9.1000 233
89 718.6108 2017-08-11 00:00:00.0 9.4776 233
90 728.0210 2017-08-12 00:00:00.0 9.4102 233
91 737.7960 2017-08-13 00:00:00.0 9.7750 233
92 747.5710 2017-08-14 00:00:00.0 9.7750 233
93 756.7950 2017-08-15 00:00:00.0 9.2240 233
94 766.4231 2017-08-16 00:00:00.0 9.6281 233
95 775.7246 2017-08-17 00:00:00.0 9.3015 233
96 785.4996 2017-08-18 00:00:00.0 9.7750 233
97 795.4812 2017-08-19 00:00:00.0 9.9816 233
98 804.3542 2017-08-20 00:00:00.0 8.8730 233
99 812.6965 2017-08-21 00:00:00.0 8.3423 233
100 820.9205 2017-08-22 00:00:00.0 8.2240 233
101 827.4899 2017-08-23 00:00:00.0 6.5694 233
102 834.6960 2017-08-24 00:00:00.0 7.2061 233
103 844.2057 2017-08-25 00:00:00.0 9.5097 233
104 853.2179 2017-08-26 00:00:00.0 9.0122 233
105 862.8730 2017-08-27 00:00:00.0 9.6551 233
106 872.8730 2017-08-28 00:00:00.0 10.0000 233
107 882.8403 2017-08-29 00:00:00.0 9.9673 233
108 891.6153 2017-08-30 00:00:00.0 8.7750 233
109 901.3454 2017-08-31 00:00:00.0 9.7301 233
110 911.2306 2017-09-01 00:00:00.0 9.8852 233
111 920.3306 2017-09-02 00:00:00.0 9.1000 233
112 929.5546 2017-09-03 00:00:00.0 9.2240 233
113 936.6847 2017-09-04 00:00:00.0 7.1301 233
114 941.4801 2017-09-05 00:00:00.0 4.7954 233
115 948.9801 2017-09-06 00:00:00.0 7.5000 233
116 956.8903 2017-09-07 00:00:00.0 7.9102 233
117 964.3184 2017-09-08 00:00:00.0 7.4281 233
118 973.3306 2017-09-09 00:00:00.0 9.0122 233
119 983.2571 2017-09-10 00:00:00.0 9.9265 233
120 992.4811 2017-09-11 00:00:00.0 9.2240 233
121 1002.2342 2017-09-12 00:00:00.0 9.7531 233
122 1010.4582 2017-09-13 00:00:00.0 8.2240 233
123 1015.1500 2017-09-14 00:00:00.0 4.6918 233
124 1017.1781 2017-09-15 00:00:00.0 2.0281 233
125 1017.4618 2017-09-16 00:00:00.0 0.2837 233
126 1018.0251 2017-09-17 00:00:00.0 0.5633 233
127 1022.5067 2017-09-18 00:00:00.0 4.4816 233
128 1028.4654 2017-09-19 00:00:00.0 5.9587 233
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '233') 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 1028
9/18/2017 4 1023
9/17/2017 1 1018
9/16/2017 0 1017
9/15/2017 2 1017
9/14/2017 5 1015
9/13/2017 8 1010
9/12/2017 10 1002
9/11/2017 9 992
9/10/2017 10 983
9/9/2017 9 973
9/8/2017 7 964
9/7/2017 8 957
9/6/2017 8 949
9/5/2017 5 941
9/4/2017 7 937
9/3/2017 9 930
9/2/2017 9 920
9/1/2017 10 911
8/31/2017 10 901
8/30/2017 9 892
8/29/2017 10 883
8/28/2017 10 873
8/27/2017 10 863
8/26/2017 9 853
8/25/2017 10 844
8/24/2017 7 835
8/23/2017 7 827
8/22/2017 8 821
8/21/2017 8 813
8/20/2017 9 804
8/19/2017 10 795
8/18/2017 10 785
8/17/2017 9 776
8/16/2017 10 766
8/15/2017 9 757
8/14/2017 10 748
8/13/2017 10 738
8/12/2017 9 728
8/11/2017 9 719
8/10/2017 9 709
8/9/2017 8 700
8/8/2017 9 692
8/7/2017 9 683
8/6/2017 9 673
8/5/2017 9 664
8/4/2017 9 655
8/3/2017 9 646
8/2/2017 7 637
8/1/2017 10 630
7/31/2017 10 620
7/30/2017 10 611
7/29/2017 10 601
7/28/2017 10 591
7/27/2017 10 581
7/26/2017 10 571
7/25/2017 9 561
7/24/2017 10 552
7/23/2017 10 542
7/22/2017 9 532
7/21/2017 10 523
7/20/2017 9 513
7/19/2017 9 504
7/18/2017 8 495
7/17/2017 10 486
7/16/2017 10 476
7/15/2017 10 466
7/14/2017 10 457
7/13/2017 9 447
7/12/2017 9 438
7/11/2017 9 429
7/10/2017 10 419
7/9/2017 10 409
7/8/2017 10 399
7/7/2017 10 389
7/6/2017 10 380
7/5/2017 10 370
7/4/2017 10 360
7/3/2017 10 350
7/2/2017 8 340
7/1/2017 8 332
6/30/2017 8 323
6/29/2017 9 315
6/28/2017 10 307
6/27/2017 9 297
6/26/2017 8 288
6/25/2017 5 280
6/24/2017 3 275
6/23/2017 5 271
6/22/2017 7 267
6/21/2017 8 259
6/20/2017 8 251
6/19/2017 7 243
6/18/2017 6 236
6/17/2017 7 230
6/16/2017 8 223
6/15/2017 7 216
6/14/2017 8 209
6/13/2017 8 201
6/12/2017 8 193
6/11/2017 9 185
6/10/2017 9 177
6/9/2017 9 167
6/8/2017 10 159
6/7/2017 9 149
6/6/2017 9 140
6/5/2017 10 131
6/4/2017 9 121
6/3/2017 10 111
6/2/2017 10 101
6/1/2017 8 92
5/31/2017 9 83
5/30/2017 6 75
5/29/2017 3 69
5/28/2017 5 66
5/27/2017 6 61
5/26/2017 5 55
5/25/2017 6 50
5/24/2017 7 44
5/23/2017 7 37
5/22/2017 5 30
5/21/2017 3 25
5/20/2017 6 22
5/19/2017 3 16
5/18/2017 0 13
5/17/2017 0 13
5/16/2017 6 13
5/15/2017 7 7