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.5728 2017-06-05 00:00:00.0 8.5728 471
2 18.3642 2017-06-06 00:00:00.0 9.7914 471
3 28.0943 2017-06-07 00:00:00.0 9.7301 471
4 38.0208 2017-06-08 00:00:00.0 9.9265 471
5 47.7958 2017-06-09 00:00:00.0 9.7750 471
6 57.4769 2017-06-10 00:00:00.0 9.6811 471
7 66.9866 2017-06-11 00:00:00.0 9.5097 471
8 75.7616 2017-06-12 00:00:00.0 8.7750 471
9 84.7284 2017-06-13 00:00:00.0 8.9668 471
10 93.7406 2017-06-14 00:00:00.0 9.0122 471
11 102.1406 2017-06-15 00:00:00.0 8.4000 471
12 109.6406 2017-06-16 00:00:00.0 7.5000 471
13 116.8467 2017-06-17 00:00:00.0 7.2061 471
14 123.8998 2017-06-18 00:00:00.0 7.0531 471
15 131.3279 2017-06-19 00:00:00.0 7.4281 471
16 139.7845 2017-06-20 00:00:00.0 8.4566 471
17 148.1268 2017-06-21 00:00:00.0 8.3423 471
18 156.1018 2017-06-22 00:00:00.0 7.9750 471
19 162.6712 2017-06-23 00:00:00.0 6.5694 471
20 167.1528 2017-06-24 00:00:00.0 4.4816 471
21 173.1115 2017-06-25 00:00:00.0 5.9587 471
22 181.5681 2017-06-26 00:00:00.0 8.4566 471
23 191.3640 2017-06-27 00:00:00.0 9.7959 471
24 201.1171 2017-06-28 00:00:00.0 9.7531 471
25 210.3411 2017-06-29 00:00:00.0 9.2240 471
26 218.9615 2017-06-30 00:00:00.0 8.6204 471
27 227.7860 2017-07-01 00:00:00.0 8.8245 471
28 236.6105 2017-07-02 00:00:00.0 8.8245 471
29 246.5977 2017-07-03 00:00:00.0 9.9872 471
30 256.5533 2017-07-04 00:00:00.0 9.9556 471
31 266.4743 2017-07-05 00:00:00.0 9.9210 471
32 276.4694 2017-07-06 00:00:00.0 9.9951 471
33 286.2444 2017-07-07 00:00:00.0 9.7750 471
34 296.2362 2017-07-08 00:00:00.0 9.9918 471
35 306.2112 2017-07-09 00:00:00.0 9.9750 471
36 316.2092 2017-07-10 00:00:00.0 9.9980 471
37 325.6536 2017-07-11 00:00:00.0 9.4444 471
38 334.8776 2017-07-12 00:00:00.0 9.2240 471
39 344.1409 2017-07-13 00:00:00.0 9.2633 471
40 354.1281 2017-07-14 00:00:00.0 9.9872 471
41 364.1031 2017-07-15 00:00:00.0 9.9750 471
42 374.0296 2017-07-16 00:00:00.0 9.9265 471
43 384.0098 2017-07-17 00:00:00.0 9.9802 471
44 393.1098 2017-07-18 00:00:00.0 9.1000 471
45 402.6195 2017-07-19 00:00:00.0 9.5097 471
46 412.2195 2017-07-20 00:00:00.0 9.6000 471
47 422.0721 2017-07-21 00:00:00.0 9.8526 471
48 431.4109 2017-07-22 00:00:00.0 9.3388 471
49 441.2456 2017-07-23 00:00:00.0 9.8347 471
50 451.1851 2017-07-24 00:00:00.0 9.9395 471
51 461.1601 2017-07-25 00:00:00.0 9.9750 471
52 471.1519 2017-07-26 00:00:00.0 9.9918 471
53 481.1321 2017-07-27 00:00:00.0 9.9802 471
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '471') AND ddate < '2017-11-01' ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
7/27/2017 10 481
7/26/2017 10 471
7/25/2017 10 461
7/24/2017 10 451
7/23/2017 10 441
7/22/2017 9 431
7/21/2017 10 422
7/20/2017 10 412
7/19/2017 10 403
7/18/2017 9 393
7/17/2017 10 384
7/16/2017 10 374
7/15/2017 10 364
7/14/2017 10 354
7/13/2017 9 344
7/12/2017 9 335
7/11/2017 9 326
7/10/2017 10 316
7/9/2017 10 306
7/8/2017 10 296
7/7/2017 10 286
7/6/2017 10 276
7/5/2017 10 266
7/4/2017 10 257
7/3/2017 10 247
7/2/2017 9 237
7/1/2017 9 228
6/30/2017 9 219
6/29/2017 9 210
6/28/2017 10 201
6/27/2017 10 191
6/26/2017 8 182
6/25/2017 6 173
6/24/2017 4 167
6/23/2017 7 163
6/22/2017 8 156
6/21/2017 8 148
6/20/2017 8 140
6/19/2017 7 131
6/18/2017 7 124
6/17/2017 7 117
6/16/2017 8 110
6/15/2017 8 102
6/14/2017 9 94
6/13/2017 9 85
6/12/2017 9 76
6/11/2017 10 67
6/10/2017 10 57
6/9/2017 10 48
6/8/2017 10 38
6/7/2017 10 28
6/6/2017 10 18
6/5/2017 9 9