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.3750 2017-05-15 00:00:00.0 9.3750 243
2 16.5051 2017-05-16 00:00:00.0 7.1301 243
3 17.8827 2017-05-17 00:00:00.0 1.3776 243
4 18.8577 2017-05-18 00:00:00.0 0.9750 243
5 23.6531 2017-05-19 00:00:00.0 4.7954 243
6 29.7021 2017-05-20 00:00:00.0 6.0490 243
7 31.3429 2017-05-21 00:00:00.0 1.6408 243
8 34.4776 2017-05-22 00:00:00.0 3.1347 243
9 41.8327 2017-05-23 00:00:00.0 7.3551 243
10 50.1750 2017-05-24 00:00:00.0 8.3423 243
11 58.2765 2017-05-25 00:00:00.0 8.1015 243
12 66.9495 2017-05-26 00:00:00.0 8.6730 243
13 75.2332 2017-05-27 00:00:00.0 8.2837 243
14 80.4327 2017-05-28 00:00:00.0 5.1995 243
15 82.3327 2017-05-29 00:00:00.0 1.9000 243
16 88.4710 2017-05-30 00:00:00.0 6.1383 243
17 97.0378 2017-05-31 00:00:00.0 8.5668 243
18 103.5699 2017-06-01 00:00:00.0 6.5321 243
19 111.3921 2017-06-02 00:00:00.0 7.8222 243
20 121.1501 2017-06-03 00:00:00.0 9.7580 243
21 130.9848 2017-06-04 00:00:00.0 9.8347 243
22 140.9058 2017-06-05 00:00:00.0 9.9210 243
23 150.3614 2017-06-06 00:00:00.0 9.4556 243
24 160.2466 2017-06-07 00:00:00.0 9.8852 243
25 170.2282 2017-06-08 00:00:00.0 9.9816 243
26 180.1772 2017-06-09 00:00:00.0 9.9490 243
27 190.1155 2017-06-10 00:00:00.0 9.9383 243
28 200.0538 2017-06-11 00:00:00.0 9.9383 243
29 209.0660 2017-06-12 00:00:00.0 9.0122 243
30 218.4410 2017-06-13 00:00:00.0 9.3750 243
31 227.8854 2017-06-14 00:00:00.0 9.4444 243
32 236.5058 2017-06-15 00:00:00.0 8.6204 243
33 244.7298 2017-06-16 00:00:00.0 8.2240 243
34 252.0109 2017-06-17 00:00:00.0 7.2811 243
35 259.2920 2017-06-18 00:00:00.0 7.2811 243
36 266.7201 2017-06-19 00:00:00.0 7.4281 243
37 275.4446 2017-06-20 00:00:00.0 8.7245 243
38 284.0114 2017-06-21 00:00:00.0 8.5668 243
39 292.1129 2017-06-22 00:00:00.0 8.1015 243
40 298.9287 2017-06-23 00:00:00.0 6.8158 243
41 303.4103 2017-06-24 00:00:00.0 4.4816 243
42 308.3083 2017-06-25 00:00:00.0 4.8980 243
43 316.4098 2017-06-26 00:00:00.0 8.1015 243
44 326.1629 2017-06-27 00:00:00.0 9.7531 243
45 335.7338 2017-06-28 00:00:00.0 9.5709 243
46 345.3889 2017-06-29 00:00:00.0 9.6551 243
47 354.2619 2017-06-30 00:00:00.0 8.8730 243
48 362.9349 2017-07-01 00:00:00.0 8.6730 243
49 371.4471 2017-07-02 00:00:00.0 8.5122 243
50 381.4287 2017-07-03 00:00:00.0 9.9816 243
51 391.1127 2017-07-04 00:00:00.0 9.6840 243
52 400.8707 2017-07-05 00:00:00.0 9.7580 243
53 410.8398 2017-07-06 00:00:00.0 9.9691 243
54 420.5459 2017-07-07 00:00:00.0 9.7061 243
55 430.5046 2017-07-08 00:00:00.0 9.9587 243
56 440.5034 2017-07-09 00:00:00.0 9.9988 243
57 450.5022 2017-07-10 00:00:00.0 9.9988 243
58 460.2981 2017-07-11 00:00:00.0 9.7959 243
59 469.0226 2017-07-12 00:00:00.0 8.7245 243
60 478.1226 2017-07-13 00:00:00.0 9.1000 243
61 488.0078 2017-07-14 00:00:00.0 9.8852 243
62 497.9828 2017-07-15 00:00:00.0 9.9750 243
63 507.9211 2017-07-16 00:00:00.0 9.9383 243
64 517.6791 2017-07-17 00:00:00.0 9.7580 243
65 527.0541 2017-07-18 00:00:00.0 9.3750 243
66 536.3174 2017-07-19 00:00:00.0 9.2633 243
67 546.0924 2017-07-20 00:00:00.0 9.7750 243
68 556.0062 2017-07-21 00:00:00.0 9.9138 243
69 565.5159 2017-07-22 00:00:00.0 9.5097 243
70 575.4649 2017-07-23 00:00:00.0 9.9490 243
71 585.2229 2017-07-24 00:00:00.0 9.7580 243
72 595.2045 2017-07-25 00:00:00.0 9.9816 243
73 605.1632 2017-07-26 00:00:00.0 9.9587 243
74 615.1434 2017-07-27 00:00:00.0 9.9802 243
75 624.5459 2017-07-28 00:00:00.0 9.4025 243
76 633.8348 2017-07-29 00:00:00.0 9.2889 243
77 642.1447 2017-07-30 00:00:00.0 8.3099 243
78 650.3620 2017-07-31 00:00:00.0 8.2173 243
79 660.2885 2017-08-01 00:00:00.0 9.9265 243
80 669.1615 2017-08-02 00:00:00.0 8.8730 243
81 678.4248 2017-08-03 00:00:00.0 9.2633 243
82 687.4814 2017-08-04 00:00:00.0 9.0566 243
83 696.8916 2017-08-05 00:00:00.0 9.4102 243
84 706.6217 2017-08-06 00:00:00.0 9.7301 243
85 716.4743 2017-08-07 00:00:00.0 9.8526 243
86 726.2901 2017-08-08 00:00:00.0 9.8158 243
87 735.4324 2017-08-09 00:00:00.0 9.1423 243
88 745.1625 2017-08-10 00:00:00.0 9.7301 243
89 754.7033 2017-08-11 00:00:00.0 9.5408 243
90 764.6171 2017-08-12 00:00:00.0 9.9138 243
91 774.5554 2017-08-13 00:00:00.0 9.9383 243
92 784.5044 2017-08-14 00:00:00.0 9.9490 243
93 794.4631 2017-08-15 00:00:00.0 9.9587 243
94 804.2978 2017-08-16 00:00:00.0 9.8347 243
95 814.0039 2017-08-17 00:00:00.0 9.7061 243
96 823.9304 2017-08-18 00:00:00.0 9.9265 243
97 833.8069 2017-08-19 00:00:00.0 9.8765 243
98 843.7334 2017-08-20 00:00:00.0 9.9265 243
99 851.0885 2017-08-21 00:00:00.0 7.3551 243
100 858.9987 2017-08-22 00:00:00.0 7.9102 243
101 864.3941 2017-08-23 00:00:00.0 5.3954 243
102 871.4472 2017-08-24 00:00:00.0 7.0531 243
103 880.9248 2017-08-25 00:00:00.0 9.4776 243
104 890.2636 2017-08-26 00:00:00.0 9.3388 243
105 900.1162 2017-08-27 00:00:00.0 9.8526 243
106 910.0718 2017-08-28 00:00:00.0 9.9556 243
107 919.5780 2017-08-29 00:00:00.0 9.5062 243
108 929.1489 2017-08-30 00:00:00.0 9.5709 243
109 938.7770 2017-08-31 00:00:00.0 9.6281 243
110 948.3479 2017-09-01 00:00:00.0 9.5709 243
111 957.7923 2017-09-02 00:00:00.0 9.4444 243
112 966.8923 2017-09-03 00:00:00.0 9.1000 243
113 974.6699 2017-09-04 00:00:00.0 7.7776 243
114 981.6449 2017-09-05 00:00:00.0 6.9750 243
115 987.6036 2017-09-06 00:00:00.0 5.9587 243
116 996.4766 2017-09-07 00:00:00.0 8.8730 243
117 1004.3210 2017-09-08 00:00:00.0 7.8444 243
118 1013.8618 2017-09-09 00:00:00.0 9.5408 243
119 1023.4618 2017-09-10 00:00:00.0 9.6000 243
120 1033.2149 2017-09-11 00:00:00.0 9.7531 243
121 1042.8149 2017-09-12 00:00:00.0 9.6000 243
122 1052.4700 2017-09-13 00:00:00.0 9.6551 243
123 1059.7511 2017-09-14 00:00:00.0 7.2811 243
124 1063.5776 2017-09-15 00:00:00.0 3.8265 243
125 1065.0873 2017-09-16 00:00:00.0 1.5097 243
126 1068.2220 2017-09-17 00:00:00.0 3.1347 243
127 1074.6220 2017-09-18 00:00:00.0 6.4000 243
128 1083.3465 2017-09-19 00:00:00.0 8.7245 243
CACHED false
EXECUTIONTIME 44
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '243') 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 1083
9/18/2017 6 1075
9/17/2017 3 1068
9/16/2017 2 1065
9/15/2017 4 1064
9/14/2017 7 1060
9/13/2017 10 1052
9/12/2017 10 1043
9/11/2017 10 1033
9/10/2017 10 1023
9/9/2017 10 1014
9/8/2017 8 1004
9/7/2017 9 996
9/6/2017 6 988
9/5/2017 7 982
9/4/2017 8 975
9/3/2017 9 967
9/2/2017 9 958
9/1/2017 10 948
8/31/2017 10 939
8/30/2017 10 929
8/29/2017 10 920
8/28/2017 10 910
8/27/2017 10 900
8/26/2017 9 890
8/25/2017 9 881
8/24/2017 7 871
8/23/2017 5 864
8/22/2017 8 859
8/21/2017 7 851
8/20/2017 10 844
8/19/2017 10 834
8/18/2017 10 824
8/17/2017 10 814
8/16/2017 10 804
8/15/2017 10 794
8/14/2017 10 785
8/13/2017 10 775
8/12/2017 10 765
8/11/2017 10 755
8/10/2017 10 745
8/9/2017 9 735
8/8/2017 10 726
8/7/2017 10 716
8/6/2017 10 707
8/5/2017 9 697
8/4/2017 9 687
8/3/2017 9 678
8/2/2017 9 669
8/1/2017 10 660
7/31/2017 8 650
7/30/2017 8 642
7/29/2017 9 634
7/28/2017 9 625
7/27/2017 10 615
7/26/2017 10 605
7/25/2017 10 595
7/24/2017 10 585
7/23/2017 10 575
7/22/2017 10 566
7/21/2017 10 556
7/20/2017 10 546
7/19/2017 9 536
7/18/2017 9 527
7/17/2017 10 518
7/16/2017 10 508
7/15/2017 10 498
7/14/2017 10 488
7/13/2017 9 478
7/12/2017 9 469
7/11/2017 10 460
7/10/2017 10 451
7/9/2017 10 441
7/8/2017 10 431
7/7/2017 10 421
7/6/2017 10 411
7/5/2017 10 401
7/4/2017 10 391
7/3/2017 10 381
7/2/2017 9 371
7/1/2017 9 363
6/30/2017 9 354
6/29/2017 10 345
6/28/2017 10 336
6/27/2017 10 326
6/26/2017 8 316
6/25/2017 5 308
6/24/2017 4 303
6/23/2017 7 299
6/22/2017 8 292
6/21/2017 9 284
6/20/2017 9 275
6/19/2017 7 267
6/18/2017 7 259
6/17/2017 7 252
6/16/2017 8 245
6/15/2017 9 237
6/14/2017 9 228
6/13/2017 9 218
6/12/2017 9 209
6/11/2017 10 200
6/10/2017 10 190
6/9/2017 10 180
6/8/2017 10 170
6/7/2017 10 160
6/6/2017 9 150
6/5/2017 10 141
6/4/2017 10 131
6/3/2017 10 121
6/2/2017 8 111
6/1/2017 7 104
5/31/2017 9 97
5/30/2017 6 88
5/29/2017 2 82
5/28/2017 5 80
5/27/2017 8 75
5/26/2017 9 67
5/25/2017 8 58
5/24/2017 8 50
5/23/2017 7 42
5/22/2017 3 34
5/21/2017 2 31
5/20/2017 6 30
5/19/2017 5 24
5/18/2017 1 19
5/17/2017 1 18
5/16/2017 7 17
5/15/2017 9 9