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.1423 2017-05-15 00:00:00.0 9.1423 203
2 15.5423 2017-05-16 00:00:00.0 6.4000 203
3 17.4423 2017-05-17 00:00:00.0 1.9000 203
4 17.8663 2017-05-18 00:00:00.0 0.4240 203
5 21.8046 2017-05-19 00:00:00.0 3.9383 203
6 26.9046 2017-05-20 00:00:00.0 5.1000 203
7 28.2822 2017-05-21 00:00:00.0 1.3776 203
8 30.9353 2017-05-22 00:00:00.0 2.6531 203
9 37.9103 2017-05-23 00:00:00.0 6.9750 203
10 46.1940 2017-05-24 00:00:00.0 8.2837 203
11 54.3573 2017-05-25 00:00:00.0 8.1633 203
12 63.0818 2017-05-26 00:00:00.0 8.7245 203
13 71.5384 2017-05-27 00:00:00.0 8.4566 203
14 76.6384 2017-05-28 00:00:00.0 5.1000 203
15 78.7935 2017-05-29 00:00:00.0 2.1551 203
16 84.7522 2017-05-30 00:00:00.0 5.9587 203
17 93.1522 2017-05-31 00:00:00.0 8.4000 203
18 103.1338 2017-06-01 00:00:00.0 9.9816 203
19 111.7894 2017-06-02 00:00:00.0 8.6556 203
20 121.4734 2017-06-03 00:00:00.0 9.6840 203
21 131.2484 2017-06-04 00:00:00.0 9.7750 203
22 141.2402 2017-06-05 00:00:00.0 9.9918 203
23 150.9624 2017-06-06 00:00:00.0 9.7222 203
24 160.8318 2017-06-07 00:00:00.0 9.8694 203
25 170.7456 2017-06-08 00:00:00.0 9.9138 203
26 180.5206 2017-06-09 00:00:00.0 9.7750 203
27 190.4058 2017-06-10 00:00:00.0 9.8852 203
28 200.2910 2017-06-11 00:00:00.0 9.8852 203
29 209.0660 2017-06-12 00:00:00.0 8.7750 203
30 218.0328 2017-06-13 00:00:00.0 8.9668 203
31 227.6037 2017-06-14 00:00:00.0 9.5709 203
32 236.1159 2017-06-15 00:00:00.0 8.5122 203
33 244.5725 2017-06-16 00:00:00.0 8.4566 203
34 252.0725 2017-06-17 00:00:00.0 7.5000 203
35 259.3536 2017-06-18 00:00:00.0 7.2811 203
36 266.9245 2017-06-19 00:00:00.0 7.5709 203
37 275.2668 2017-06-20 00:00:00.0 8.3423 203
38 283.6091 2017-06-21 00:00:00.0 8.3423 203
39 292.0091 2017-06-22 00:00:00.0 8.4000 203
40 298.8249 2017-06-23 00:00:00.0 6.8158 203
41 303.3065 2017-06-24 00:00:00.0 4.4816 203
42 307.8937 2017-06-25 00:00:00.0 4.5872 203
43 315.8039 2017-06-26 00:00:00.0 7.9102 203
44 325.3748 2017-06-27 00:00:00.0 9.5709 203
45 334.7850 2017-06-28 00:00:00.0 9.4102 203
46 343.9687 2017-06-29 00:00:00.0 9.1837 203
47 352.5891 2017-06-30 00:00:00.0 8.6204 203
48 360.9314 2017-07-01 00:00:00.0 8.3423 203
49 368.9702 2017-07-02 00:00:00.0 8.0388 203
50 378.8049 2017-07-03 00:00:00.0 9.8347 203
51 388.4481 2017-07-04 00:00:00.0 9.6432 203
52 398.4283 2017-07-05 00:00:00.0 9.9802 203
53 408.4234 2017-07-06 00:00:00.0 9.9951 203
54 418.0234 2017-07-07 00:00:00.0 9.6000 203
55 427.9372 2017-07-08 00:00:00.0 9.9138 203
56 437.8862 2017-07-09 00:00:00.0 9.9490 203
57 447.8127 2017-07-10 00:00:00.0 9.9265 203
58 457.7617 2017-07-11 00:00:00.0 9.9490 203
59 466.4862 2017-07-12 00:00:00.0 8.7245 203
60 475.1066 2017-07-13 00:00:00.0 8.6204 203
61 484.8367 2017-07-14 00:00:00.0 9.7301 203
62 494.7750 2017-07-15 00:00:00.0 9.9383 203
63 504.6097 2017-07-16 00:00:00.0 9.8347 203
64 514.5097 2017-07-17 00:00:00.0 9.9000 203
65 523.8485 2017-07-18 00:00:00.0 9.3388 203
66 532.9051 2017-07-19 00:00:00.0 9.0566 203
67 542.4760 2017-07-20 00:00:00.0 9.5709 203
68 552.4433 2017-07-21 00:00:00.0 9.9673 203
69 561.8877 2017-07-22 00:00:00.0 9.4444 203
70 571.7224 2017-07-23 00:00:00.0 9.8347 203
71 581.6434 2017-07-24 00:00:00.0 9.9210 203
72 591.6388 2017-07-25 00:00:00.0 9.9954 203
73 601.5975 2017-07-26 00:00:00.0 9.9587 203
CACHED false
EXECUTIONTIME 2
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '203') 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 602
7/25/2017 10 592
7/24/2017 10 582
7/23/2017 10 572
7/22/2017 9 562
7/21/2017 10 552
7/20/2017 10 542
7/19/2017 9 533
7/18/2017 9 524
7/17/2017 10 515
7/16/2017 10 505
7/15/2017 10 495
7/14/2017 10 485
7/13/2017 9 475
7/12/2017 9 466
7/11/2017 10 458
7/10/2017 10 448
7/9/2017 10 438
7/8/2017 10 428
7/7/2017 10 418
7/6/2017 10 408
7/5/2017 10 398
7/4/2017 10 388
7/3/2017 10 379
7/2/2017 8 369
7/1/2017 8 361
6/30/2017 9 353
6/29/2017 9 344
6/28/2017 9 335
6/27/2017 10 325
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 8 284
6/20/2017 8 275
6/19/2017 8 267
6/18/2017 7 259
6/17/2017 8 252
6/16/2017 8 245
6/15/2017 9 236
6/14/2017 10 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 181
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 112
6/1/2017 10 103
5/31/2017 8 93
5/30/2017 6 85
5/29/2017 2 79
5/28/2017 5 77
5/27/2017 8 72
5/26/2017 9 63
5/25/2017 8 54
5/24/2017 8 46
5/23/2017 7 38
5/22/2017 3 31
5/21/2017 1 28
5/20/2017 5 27
5/19/2017 4 22
5/18/2017 0 18
5/17/2017 2 17
5/16/2017 6 16
5/15/2017 9 9