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.9668 2017-05-15 00:00:00.0 8.9668 202
2 16.2479 2017-05-16 00:00:00.0 7.2811 202
3 17.8887 2017-05-17 00:00:00.0 1.6408 202
4 18.4520 2017-05-18 00:00:00.0 0.5633 202
5 22.6107 2017-05-19 00:00:00.0 4.1587 202
6 28.5694 2017-05-20 00:00:00.0 5.9587 202
7 30.7245 2017-05-21 00:00:00.0 2.1551 202
8 33.9771 2017-05-22 00:00:00.0 3.2526 202
9 41.3322 2017-05-23 00:00:00.0 7.3551 202
10 49.3072 2017-05-24 00:00:00.0 7.9750 202
11 57.0848 2017-05-25 00:00:00.0 7.7776 202
12 65.1236 2017-05-26 00:00:00.0 8.0388 202
13 73.4073 2017-05-27 00:00:00.0 8.2837 202
14 78.8027 2017-05-28 00:00:00.0 5.3954 202
15 80.7027 2017-05-29 00:00:00.0 1.9000 202
16 87.1027 2017-05-30 00:00:00.0 6.4000 202
17 95.7757 2017-05-31 00:00:00.0 8.6730 202
18 102.4374 2017-06-01 00:00:00.0 6.6617 202
19 111.3991 2017-06-02 00:00:00.0 8.9617 202
20 121.3201 2017-06-03 00:00:00.0 9.9210 202
21 131.0262 2017-06-04 00:00:00.0 9.7061 202
22 141.0262 2017-06-05 00:00:00.0 10.0000 202
23 150.8484 2017-06-06 00:00:00.0 9.8222 202
24 160.5785 2017-06-07 00:00:00.0 9.7301 202
25 170.5657 2017-06-08 00:00:00.0 9.9872 202
26 180.3188 2017-06-09 00:00:00.0 9.7531 202
27 190.1714 2017-06-10 00:00:00.0 9.8526 202
28 199.9673 2017-06-11 00:00:00.0 9.7959 202
29 209.0673 2017-06-12 00:00:00.0 9.1000 202
30 217.9403 2017-06-13 00:00:00.0 8.8730 202
31 227.2791 2017-06-14 00:00:00.0 9.3388 202
32 235.9521 2017-06-15 00:00:00.0 8.6730 202
33 243.9271 2017-06-16 00:00:00.0 7.9750 202
34 250.9021 2017-06-17 00:00:00.0 6.9750 202
35 258.0322 2017-06-18 00:00:00.0 7.1301 202
36 265.0853 2017-06-19 00:00:00.0 7.0531 202
37 273.4853 2017-06-20 00:00:00.0 8.4000 202
38 281.8276 2017-06-21 00:00:00.0 8.3423 202
39 290.1113 2017-06-22 00:00:00.0 8.2837 202
40 296.5965 2017-06-23 00:00:00.0 6.4852 202
41 300.5348 2017-06-24 00:00:00.0 3.9383 202
42 305.0164 2017-06-25 00:00:00.0 4.4816 202
43 313.3587 2017-06-26 00:00:00.0 8.3423 202
44 323.0138 2017-06-27 00:00:00.0 9.6551 202
45 332.6419 2017-06-28 00:00:00.0 9.6281 202
46 342.0169 2017-06-29 00:00:00.0 9.3750 202
47 350.5837 2017-06-30 00:00:00.0 8.5668 202
48 359.2041 2017-07-01 00:00:00.0 8.6204 202
49 367.6607 2017-07-02 00:00:00.0 8.4566 202
50 377.5990 2017-07-03 00:00:00.0 9.9383 202
51 387.4990 2017-07-04 00:00:00.0 9.9000 202
52 397.3755 2017-07-05 00:00:00.0 9.8765 202
53 407.3735 2017-07-06 00:00:00.0 9.9980 202
54 417.0796 2017-07-07 00:00:00.0 9.7061 202
55 427.0546 2017-07-08 00:00:00.0 9.9750 202
56 437.0296 2017-07-09 00:00:00.0 9.9750 202
57 447.0168 2017-07-10 00:00:00.0 9.9872 202
58 456.7229 2017-07-11 00:00:00.0 9.7061 202
59 465.3959 2017-07-12 00:00:00.0 8.6730 202
60 474.7347 2017-07-13 00:00:00.0 9.3388 202
61 484.6612 2017-07-14 00:00:00.0 9.9265 202
62 494.5995 2017-07-15 00:00:00.0 9.9383 202
63 504.4689 2017-07-16 00:00:00.0 9.8694 202
64 514.2911 2017-07-17 00:00:00.0 9.8222 202
65 523.5544 2017-07-18 00:00:00.0 9.2633 202
66 532.7381 2017-07-19 00:00:00.0 9.1837 202
67 542.3090 2017-07-20 00:00:00.0 9.5709 202
68 552.0840 2017-07-21 00:00:00.0 9.7750 202
69 561.4228 2017-07-22 00:00:00.0 9.3388 202
70 571.3080 2017-07-23 00:00:00.0 9.8852 202
71 581.2771 2017-07-24 00:00:00.0 9.9691 202
72 591.2587 2017-07-25 00:00:00.0 9.9816 202
73 601.2403 2017-07-26 00:00:00.0 9.9816 202
74 611.1168 2017-07-27 00:00:00.0 9.8765 202
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '202') 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 611
7/26/2017 10 601
7/25/2017 10 591
7/24/2017 10 581
7/23/2017 10 571
7/22/2017 9 561
7/21/2017 10 552
7/20/2017 10 542
7/19/2017 9 533
7/18/2017 9 524
7/17/2017 10 514
7/16/2017 10 504
7/15/2017 10 495
7/14/2017 10 485
7/13/2017 9 475
7/12/2017 9 465
7/11/2017 10 457
7/10/2017 10 447
7/9/2017 10 437
7/8/2017 10 427
7/7/2017 10 417
7/6/2017 10 407
7/5/2017 10 397
7/4/2017 10 387
7/3/2017 10 378
7/2/2017 8 368
7/1/2017 9 359
6/30/2017 9 351
6/29/2017 9 342
6/28/2017 10 333
6/27/2017 10 323
6/26/2017 8 313
6/25/2017 4 305
6/24/2017 4 301
6/23/2017 6 297
6/22/2017 8 290
6/21/2017 8 282
6/20/2017 8 273
6/19/2017 7 265
6/18/2017 7 258
6/17/2017 7 251
6/16/2017 8 244
6/15/2017 9 236
6/14/2017 9 227
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 171
6/7/2017 10 161
6/6/2017 10 151
6/5/2017 10 141
6/4/2017 10 131
6/3/2017 10 121
6/2/2017 9 111
6/1/2017 7 102
5/31/2017 9 96
5/30/2017 6 87
5/29/2017 2 81
5/28/2017 5 79
5/27/2017 8 73
5/26/2017 8 65
5/25/2017 8 57
5/24/2017 8 49
5/23/2017 7 41
5/22/2017 3 34
5/21/2017 2 31
5/20/2017 6 29
5/19/2017 4 23
5/18/2017 1 18
5/17/2017 2 18
5/16/2017 7 16
5/15/2017 9 9