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.2240 2017-05-15 00:00:00.0 8.2240 246
2 14.2730 2017-05-16 00:00:00.0 6.0490 246
3 14.2730 2017-05-17 00:00:00.0 0.0000 246
4 14.2730 2017-05-18 00:00:00.0 0.0000 246
5 16.9261 2017-05-19 00:00:00.0 2.6531 246
6 21.7215 2017-05-20 00:00:00.0 4.7954 246
7 22.2848 2017-05-21 00:00:00.0 0.5633 246
8 25.3006 2017-05-22 00:00:00.0 3.0158 246
9 31.7006 2017-05-23 00:00:00.0 6.4000 246
10 38.9067 2017-05-24 00:00:00.0 7.2061 246
11 45.5593 2017-05-25 00:00:00.0 6.6526 246
12 51.7858 2017-05-26 00:00:00.0 6.2265 246
13 58.6817 2017-05-27 00:00:00.0 6.8959 246
14 62.6200 2017-05-28 00:00:00.0 3.9383 246
15 64.1297 2017-05-29 00:00:00.0 1.5097 246
16 68.5047 2017-05-30 00:00:00.0 4.3750 246
17 76.8470 2017-05-31 00:00:00.0 8.3423 246
18 86.7608 2017-06-01 00:00:00.0 9.9138 246
19 95.8608 2017-06-02 00:00:00.0 9.1000 246
20 105.8526 2017-06-03 00:00:00.0 9.9918 246
21 115.4235 2017-06-04 00:00:00.0 9.5709 246
22 125.4051 2017-06-05 00:00:00.0 9.9816 246
23 135.3051 2017-06-06 00:00:00.0 9.9000 246
24 144.1781 2017-06-07 00:00:00.0 8.8730 246
25 154.0475 2017-06-08 00:00:00.0 9.8694 246
26 163.5572 2017-06-09 00:00:00.0 9.5097 246
27 173.0016 2017-06-10 00:00:00.0 9.4444 246
28 182.4460 2017-06-11 00:00:00.0 9.4444 246
29 190.9026 2017-06-12 00:00:00.0 8.4566 246
30 199.1863 2017-06-13 00:00:00.0 8.2837 246
31 207.5286 2017-06-14 00:00:00.0 8.3423 246
32 215.1694 2017-06-15 00:00:00.0 7.6408 246
33 223.3934 2017-06-16 00:00:00.0 8.2240 246
34 230.1281 2017-06-17 00:00:00.0 6.7347 246
35 236.2664 2017-06-18 00:00:00.0 6.1383 246
36 243.3965 2017-06-19 00:00:00.0 7.1301 246
37 250.8246 2017-06-20 00:00:00.0 7.4281 246
38 259.5491 2017-06-21 00:00:00.0 8.7245 246
39 266.9772 2017-06-22 00:00:00.0 7.4281 246
40 272.7522 2017-06-23 00:00:00.0 5.7750 246
41 275.2823 2017-06-24 00:00:00.0 2.5301 246
42 279.7639 2017-06-25 00:00:00.0 4.4816 246
43 286.9700 2017-06-26 00:00:00.0 7.2061 246
44 296.4144 2017-06-27 00:00:00.0 9.4444 246
45 306.2302 2017-06-28 00:00:00.0 9.8158 246
46 315.1970 2017-06-29 00:00:00.0 8.9668 246
47 323.2358 2017-06-30 00:00:00.0 8.0388 246
48 331.3373 2017-07-01 00:00:00.0 8.1015 246
49 338.9781 2017-07-02 00:00:00.0 7.6408 246
50 348.7939 2017-07-03 00:00:00.0 9.8158 246
51 358.4371 2017-07-04 00:00:00.0 9.6432 246
52 368.4260 2017-07-05 00:00:00.0 9.9889 246
53 378.4010 2017-07-06 00:00:00.0 9.9750 246
54 387.8454 2017-07-07 00:00:00.0 9.4444 246
55 397.7837 2017-07-08 00:00:00.0 9.9383 246
56 407.7327 2017-07-09 00:00:00.0 9.9490 246
57 417.7077 2017-07-10 00:00:00.0 9.9750 246
58 427.5771 2017-07-11 00:00:00.0 9.8694 246
59 435.3547 2017-07-12 00:00:00.0 7.7776 246
60 443.5180 2017-07-13 00:00:00.0 8.1633 246
61 453.3527 2017-07-14 00:00:00.0 9.8347 246
62 463.0828 2017-07-15 00:00:00.0 9.7301 246
63 472.7639 2017-07-16 00:00:00.0 9.6811 246
64 482.7195 2017-07-17 00:00:00.0 9.9556 246
65 491.6863 2017-07-18 00:00:00.0 8.9668 246
66 500.6067 2017-07-19 00:00:00.0 8.9204 246
67 510.0511 2017-07-20 00:00:00.0 9.4444 246
68 519.8669 2017-07-21 00:00:00.0 9.8158 246
69 529.0092 2017-07-22 00:00:00.0 9.1423 246
70 538.6092 2017-07-23 00:00:00.0 9.6000 246
71 548.6043 2017-07-24 00:00:00.0 9.9951 246
72 558.4569 2017-07-25 00:00:00.0 9.8526 246
73 568.3263 2017-07-26 00:00:00.0 9.8694 246
74 578.2646 2017-07-27 00:00:00.0 9.9383 246
75 588.2641 2017-07-28 00:00:00.0 9.9995 246
76 598.2621 2017-07-29 00:00:00.0 9.9980 246
77 608.0535 2017-07-30 00:00:00.0 9.7914 246
78 617.3424 2017-07-31 00:00:00.0 9.2889 246
79 626.9975 2017-08-01 00:00:00.0 9.6551 246
80 633.8934 2017-08-02 00:00:00.0 6.8959 246
81 642.2934 2017-08-03 00:00:00.0 8.4000 246
82 651.2138 2017-08-04 00:00:00.0 8.9204 246
83 659.7806 2017-08-05 00:00:00.0 8.5668 246
84 668.2372 2017-08-06 00:00:00.0 8.4566 246
85 677.6474 2017-08-07 00:00:00.0 9.4102 246
86 687.1250 2017-08-08 00:00:00.0 9.4776 246
87 695.2883 2017-08-09 00:00:00.0 8.1633 246
88 704.1613 2017-08-10 00:00:00.0 8.8730 246
89 713.1281 2017-08-11 00:00:00.0 8.9668 246
90 722.2281 2017-08-12 00:00:00.0 9.1000 246
91 731.6031 2017-08-13 00:00:00.0 9.3750 246
92 741.1128 2017-08-14 00:00:00.0 9.5097 246
93 750.2128 2017-08-15 00:00:00.0 9.1000 246
94 759.8128 2017-08-16 00:00:00.0 9.6000 246
95 769.1143 2017-08-17 00:00:00.0 9.3015 246
96 778.8204 2017-08-18 00:00:00.0 9.7061 246
97 788.8076 2017-08-19 00:00:00.0 9.9872 246
98 797.9076 2017-08-20 00:00:00.0 9.1000 246
99 805.2627 2017-08-21 00:00:00.0 7.3551 246
100 812.9035 2017-08-22 00:00:00.0 7.6408 246
101 818.7708 2017-08-23 00:00:00.0 5.8673 246
102 826.0519 2017-08-24 00:00:00.0 7.2811 246
103 835.3907 2017-08-25 00:00:00.0 9.3388 246
104 844.7657 2017-08-26 00:00:00.0 9.3750 246
105 854.2433 2017-08-27 00:00:00.0 9.4776 246
106 864.2249 2017-08-28 00:00:00.0 9.9816 246
107 874.2229 2017-08-29 00:00:00.0 9.9980 246
108 883.0959 2017-08-30 00:00:00.0 8.8730 246
109 892.9117 2017-08-31 00:00:00.0 9.8158 246
110 902.8989 2017-09-01 00:00:00.0 9.9872 246
111 912.4086 2017-09-02 00:00:00.0 9.5097 246
112 921.9183 2017-09-03 00:00:00.0 9.5097 246
113 929.6280 2017-09-04 00:00:00.0 7.7097 246
114 935.2152 2017-09-05 00:00:00.0 5.5872 246
115 942.1902 2017-09-06 00:00:00.0 6.9750 246
116 950.6468 2017-09-07 00:00:00.0 8.4566 246
117 957.7769 2017-09-08 00:00:00.0 7.1301 246
118 967.4320 2017-09-09 00:00:00.0 9.6551 246
119 977.4122 2017-09-10 00:00:00.0 9.9802 246
120 987.0933 2017-09-11 00:00:00.0 9.6811 246
121 997.0489 2017-09-12 00:00:00.0 9.9556 246
122 1005.6157 2017-09-13 00:00:00.0 8.5668 246
123 1011.4830 2017-09-14 00:00:00.0 5.8673 246
124 1013.3830 2017-09-15 00:00:00.0 1.9000 246
125 1013.3830 2017-09-16 00:00:00.0 0.0000 246
126 1014.4932 2017-09-17 00:00:00.0 1.1102 246
127 1019.6927 2017-09-18 00:00:00.0 5.1995 246
128 1027.3335 2017-09-19 00:00:00.0 7.6408 246
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '246') 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 1027
9/18/2017 5 1020
9/17/2017 1 1014
9/16/2017 0 1013
9/15/2017 2 1013
9/14/2017 6 1011
9/13/2017 9 1006
9/12/2017 10 997
9/11/2017 10 987
9/10/2017 10 977
9/9/2017 10 967
9/8/2017 7 958
9/7/2017 8 951
9/6/2017 7 942
9/5/2017 6 935
9/4/2017 8 930
9/3/2017 10 922
9/2/2017 10 912
9/1/2017 10 903
8/31/2017 10 893
8/30/2017 9 883
8/29/2017 10 874
8/28/2017 10 864
8/27/2017 9 854
8/26/2017 9 845
8/25/2017 9 835
8/24/2017 7 826
8/23/2017 6 819
8/22/2017 8 813
8/21/2017 7 805
8/20/2017 9 798
8/19/2017 10 789
8/18/2017 10 779
8/17/2017 9 769
8/16/2017 10 760
8/15/2017 9 750
8/14/2017 10 741
8/13/2017 9 732
8/12/2017 9 722
8/11/2017 9 713
8/10/2017 9 704
8/9/2017 8 695
8/8/2017 9 687
8/7/2017 9 678
8/6/2017 8 668
8/5/2017 9 660
8/4/2017 9 651
8/3/2017 8 642
8/2/2017 7 634
8/1/2017 10 627
7/31/2017 9 617
7/30/2017 10 608
7/29/2017 10 598
7/28/2017 10 588
7/27/2017 10 578
7/26/2017 10 568
7/25/2017 10 558
7/24/2017 10 549
7/23/2017 10 539
7/22/2017 9 529
7/21/2017 10 520
7/20/2017 9 510
7/19/2017 9 501
7/18/2017 9 492
7/17/2017 10 483
7/16/2017 10 473
7/15/2017 10 463
7/14/2017 10 453
7/13/2017 8 444
7/12/2017 8 435
7/11/2017 10 428
7/10/2017 10 418
7/9/2017 10 408
7/8/2017 10 398
7/7/2017 9 388
7/6/2017 10 378
7/5/2017 10 368
7/4/2017 10 358
7/3/2017 10 349
7/2/2017 8 339
7/1/2017 8 331
6/30/2017 8 323
6/29/2017 9 315
6/28/2017 10 306
6/27/2017 9 296
6/26/2017 7 287
6/25/2017 4 280
6/24/2017 3 275
6/23/2017 6 273
6/22/2017 7 267
6/21/2017 9 260
6/20/2017 7 251
6/19/2017 7 243
6/18/2017 6 236
6/17/2017 7 230
6/16/2017 8 223
6/15/2017 8 215
6/14/2017 8 208
6/13/2017 8 199
6/12/2017 8 191
6/11/2017 9 182
6/10/2017 9 173
6/9/2017 10 164
6/8/2017 10 154
6/7/2017 9 144
6/6/2017 10 135
6/5/2017 10 125
6/4/2017 10 115
6/3/2017 10 106
6/2/2017 9 96
6/1/2017 10 87
5/31/2017 8 77
5/30/2017 4 69
5/29/2017 2 64
5/28/2017 4 63
5/27/2017 7 59
5/26/2017 6 52
5/25/2017 7 46
5/24/2017 7 39
5/23/2017 6 32
5/22/2017 3 25
5/21/2017 1 22
5/20/2017 5 22
5/19/2017 3 17
5/18/2017 0 14
5/17/2017 0 14
5/16/2017 6 14
5/15/2017 8 8