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
CACHED false
EXECUTIONTIME 0
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
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