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.2240 2017-05-15 00:00:00.0 9.2240 222
2 16.1199 2017-05-16 00:00:00.0 6.8959 222
3 17.8908 2017-05-17 00:00:00.0 1.7709 222
4 18.7296 2017-05-18 00:00:00.0 0.8388 222
5 23.2112 2017-05-19 00:00:00.0 4.4816 222
6 28.1092 2017-05-20 00:00:00.0 4.8980 222
7 29.3536 2017-05-21 00:00:00.0 1.2444 222
8 32.4883 2017-05-22 00:00:00.0 3.1347 222
9 39.6944 2017-05-23 00:00:00.0 7.2061 222
10 47.7332 2017-05-24 00:00:00.0 8.0388 222
11 55.5108 2017-05-25 00:00:00.0 7.7776 222
12 64.0776 2017-05-26 00:00:00.0 8.5668 222
13 72.5342 2017-05-27 00:00:00.0 8.4566 222
14 78.3092 2017-05-28 00:00:00.0 5.7750 222
15 80.4643 2017-05-29 00:00:00.0 2.1551 222
16 86.6908 2017-05-30 00:00:00.0 6.2265 222
17 95.5638 2017-05-31 00:00:00.0 8.8730 222
18 105.5128 2017-06-01 00:00:00.0 9.9490 222
19 114.3264 2017-06-02 00:00:00.0 8.8136 222
20 123.6153 2017-06-03 00:00:00.0 9.2889 222
21 133.5536 2017-06-04 00:00:00.0 9.9383 222
22 143.5487 2017-06-05 00:00:00.0 9.9951 222
23 153.3709 2017-06-06 00:00:00.0 9.8222 222
24 163.2847 2017-06-07 00:00:00.0 9.9138 222
25 173.2842 2017-06-08 00:00:00.0 9.9995 222
26 183.1842 2017-06-09 00:00:00.0 9.9000 222
27 193.1225 2017-06-10 00:00:00.0 9.9383 222
28 203.0715 2017-06-11 00:00:00.0 9.9490 222
29 212.4465 2017-06-12 00:00:00.0 9.3750 222
30 221.5888 2017-06-13 00:00:00.0 9.1423 222
31 231.0664 2017-06-14 00:00:00.0 9.4776 222
32 239.9394 2017-06-15 00:00:00.0 8.8730 222
33 248.8124 2017-06-16 00:00:00.0 8.8730 222
34 256.7874 2017-06-17 00:00:00.0 7.9750 222
35 264.4282 2017-06-18 00:00:00.0 7.6408 222
36 272.5915 2017-06-19 00:00:00.0 8.1633 222
37 281.2119 2017-06-20 00:00:00.0 8.6204 222
38 289.7241 2017-06-21 00:00:00.0 8.5122 222
39 298.8241 2017-06-22 00:00:00.0 9.1000 222
40 306.0302 2017-06-23 00:00:00.0 7.2061 222
41 310.5118 2017-06-24 00:00:00.0 4.4816 222
42 316.0990 2017-06-25 00:00:00.0 5.5872 222
43 324.7720 2017-06-26 00:00:00.0 8.6730 222
44 334.2164 2017-06-27 00:00:00.0 9.4444 222
45 343.5552 2017-06-28 00:00:00.0 9.3388 222
46 352.9302 2017-06-29 00:00:00.0 9.3750 222
47 361.8032 2017-06-30 00:00:00.0 8.8730 222
48 370.4236 2017-07-01 00:00:00.0 8.6204 222
49 378.9904 2017-07-02 00:00:00.0 8.5668 222
50 388.9042 2017-07-03 00:00:00.0 9.9138 222
51 398.4585 2017-07-04 00:00:00.0 9.5543 222
52 408.1807 2017-07-05 00:00:00.0 9.7222 222
53 417.9721 2017-07-06 00:00:00.0 9.7914 222
54 427.7879 2017-07-07 00:00:00.0 9.8158 222
55 437.7435 2017-07-08 00:00:00.0 9.9556 222
56 447.7237 2017-07-09 00:00:00.0 9.9802 222
57 457.7237 2017-07-10 00:00:00.0 10.0000 222
58 467.6910 2017-07-11 00:00:00.0 9.9673 222
59 476.4155 2017-07-12 00:00:00.0 8.7245 222
60 485.5992 2017-07-13 00:00:00.0 9.1837 222
61 495.3951 2017-07-14 00:00:00.0 9.7959 222
62 505.3869 2017-07-15 00:00:00.0 9.9918 222
63 515.2563 2017-07-16 00:00:00.0 9.8694 222
64 525.1069 2017-07-17 00:00:00.0 9.8506 222
65 534.7620 2017-07-18 00:00:00.0 9.6551 222
66 543.8186 2017-07-19 00:00:00.0 9.0566 222
67 553.5247 2017-07-20 00:00:00.0 9.7061 222
68 563.5063 2017-07-21 00:00:00.0 9.9816 222
69 573.0772 2017-07-22 00:00:00.0 9.5709 222
70 582.9466 2017-07-23 00:00:00.0 9.8694 222
71 592.9420 2017-07-24 00:00:00.0 9.9954 222
72 602.9374 2017-07-25 00:00:00.0 9.9954 222
73 612.9190 2017-07-26 00:00:00.0 9.9816 222
74 622.8746 2017-07-27 00:00:00.0 9.9556 222
75 632.7252 2017-07-28 00:00:00.0 9.8506 222
76 642.5474 2017-07-29 00:00:00.0 9.8222 222
77 651.5795 2017-07-30 00:00:00.0 9.0321 222
78 660.1523 2017-07-31 00:00:00.0 8.5728 222
79 670.0661 2017-08-01 00:00:00.0 9.9138 222
80 678.4084 2017-08-02 00:00:00.0 8.3423 222
81 687.4650 2017-08-03 00:00:00.0 9.0566 222
82 696.7665 2017-08-04 00:00:00.0 9.3015 222
83 706.1053 2017-08-05 00:00:00.0 9.3388 222
84 715.4068 2017-08-06 00:00:00.0 9.3015 222
85 725.3206 2017-08-07 00:00:00.0 9.9138 222
86 735.1364 2017-08-08 00:00:00.0 9.8158 222
87 744.2364 2017-08-09 00:00:00.0 9.1000 222
88 753.8645 2017-08-10 00:00:00.0 9.6281 222
89 763.3421 2017-08-11 00:00:00.0 9.4776 222
90 773.1579 2017-08-12 00:00:00.0 9.8158 222
91 782.9926 2017-08-13 00:00:00.0 9.8347 222
92 792.8452 2017-08-14 00:00:00.0 9.8526 222
93 802.6799 2017-08-15 00:00:00.0 9.8347 222
94 812.4549 2017-08-16 00:00:00.0 9.7750 222
95 821.9957 2017-08-17 00:00:00.0 9.5408 222
96 831.9095 2017-08-18 00:00:00.0 9.9138 222
97 841.8651 2017-08-19 00:00:00.0 9.9556 222
98 851.6998 2017-08-20 00:00:00.0 9.8347 222
99 859.7386 2017-08-21 00:00:00.0 8.0388 222
100 868.0223 2017-08-22 00:00:00.0 8.2837 222
101 873.9810 2017-08-23 00:00:00.0 5.9587 222
102 881.0341 2017-08-24 00:00:00.0 7.0531 222
103 890.3356 2017-08-25 00:00:00.0 9.3015 222
104 899.5596 2017-08-26 00:00:00.0 9.2240 222
105 909.2897 2017-08-27 00:00:00.0 9.7301 222
106 919.2699 2017-08-28 00:00:00.0 9.9802 222
107 929.1909 2017-08-29 00:00:00.0 9.9210 222
108 938.4542 2017-08-30 00:00:00.0 9.2633 222
109 947.7930 2017-08-31 00:00:00.0 9.3388 222
110 957.3639 2017-09-01 00:00:00.0 9.5709 222
111 966.8083 2017-09-02 00:00:00.0 9.4444 222
112 976.3180 2017-09-03 00:00:00.0 9.5097 222
113 984.4195 2017-09-04 00:00:00.0 8.1015 222
114 991.2353 2017-09-05 00:00:00.0 6.8158 222
115 997.1940 2017-09-06 00:00:00.0 5.9587 222
116 1006.3777 2017-09-07 00:00:00.0 9.1837 222
117 1013.8777 2017-09-08 00:00:00.0 7.5000 222
118 1023.3553 2017-09-09 00:00:00.0 9.4776 222
119 1033.0775 2017-09-10 00:00:00.0 9.7222 222
120 1043.0591 2017-09-11 00:00:00.0 9.9816 222
121 1052.6591 2017-09-12 00:00:00.0 9.6000 222
122 1062.2300 2017-09-13 00:00:00.0 9.5709 222
123 1069.8708 2017-09-14 00:00:00.0 7.6408 222
124 1073.9198 2017-09-15 00:00:00.0 4.0490 222
125 1075.6907 2017-09-16 00:00:00.0 1.7709 222
126 1079.5172 2017-09-17 00:00:00.0 3.8265 222
127 1085.2922 2017-09-18 00:00:00.0 5.7750 222
128 1094.2590 2017-09-19 00:00:00.0 8.9668 222
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '222') 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 9 1094
9/18/2017 6 1085
9/17/2017 4 1080
9/16/2017 2 1076
9/15/2017 4 1074
9/14/2017 8 1070
9/13/2017 10 1062
9/12/2017 10 1053
9/11/2017 10 1043
9/10/2017 10 1033
9/9/2017 9 1023
9/8/2017 8 1014
9/7/2017 9 1006
9/6/2017 6 997
9/5/2017 7 991
9/4/2017 8 984
9/3/2017 10 976
9/2/2017 9 967
9/1/2017 10 957
8/31/2017 9 948
8/30/2017 9 938
8/29/2017 10 929
8/28/2017 10 919
8/27/2017 10 909
8/26/2017 9 900
8/25/2017 9 890
8/24/2017 7 881
8/23/2017 6 874
8/22/2017 8 868
8/21/2017 8 860
8/20/2017 10 852
8/19/2017 10 842
8/18/2017 10 832
8/17/2017 10 822
8/16/2017 10 812
8/15/2017 10 803
8/14/2017 10 793
8/13/2017 10 783
8/12/2017 10 773
8/11/2017 9 763
8/10/2017 10 754
8/9/2017 9 744
8/8/2017 10 735
8/7/2017 10 725
8/6/2017 9 715
8/5/2017 9 706
8/4/2017 9 697
8/3/2017 9 687
8/2/2017 8 678
8/1/2017 10 670
7/31/2017 9 660
7/30/2017 9 652
7/29/2017 10 643
7/28/2017 10 633
7/27/2017 10 623
7/26/2017 10 613
7/25/2017 10 603
7/24/2017 10 593
7/23/2017 10 583
7/22/2017 10 573
7/21/2017 10 564
7/20/2017 10 554
7/19/2017 9 544
7/18/2017 10 535
7/17/2017 10 525
7/16/2017 10 515
7/15/2017 10 505
7/14/2017 10 495
7/13/2017 9 486
7/12/2017 9 476
7/11/2017 10 468
7/10/2017 10 458
7/9/2017 10 448
7/8/2017 10 438
7/7/2017 10 428
7/6/2017 10 418
7/5/2017 10 408
7/4/2017 10 398
7/3/2017 10 389
7/2/2017 9 379
7/1/2017 9 370
6/30/2017 9 362
6/29/2017 9 353
6/28/2017 9 344
6/27/2017 9 334
6/26/2017 9 325
6/25/2017 6 316
6/24/2017 4 311
6/23/2017 7 306
6/22/2017 9 299
6/21/2017 9 290
6/20/2017 9 281
6/19/2017 8 273
6/18/2017 8 264
6/17/2017 8 257
6/16/2017 9 249
6/15/2017 9 240
6/14/2017 9 231
6/13/2017 9 222
6/12/2017 9 212
6/11/2017 10 203
6/10/2017 10 193
6/9/2017 10 183
6/8/2017 10 173
6/7/2017 10 163
6/6/2017 10 153
6/5/2017 10 144
6/4/2017 10 134
6/3/2017 9 124
6/2/2017 9 114
6/1/2017 10 106
5/31/2017 9 96
5/30/2017 6 87
5/29/2017 2 80
5/28/2017 6 78
5/27/2017 8 73
5/26/2017 9 64
5/25/2017 8 56
5/24/2017 8 48
5/23/2017 7 40
5/22/2017 3 32
5/21/2017 1 29
5/20/2017 5 28
5/19/2017 4 23
5/18/2017 1 19
5/17/2017 2 18
5/16/2017 7 16
5/15/2017 9 9