Physiological Days

  • DAILY
  • TOTAL
Pdays Forrest Carberry Wawanesa Glenboro Glenora Treherne Holland Gladstone Portage East High Bluff Oakland Elm Creek Carman Winkler Kuhl Farm Morris St.Adolphe Steinbach Selkirk Shilo Rivers Somerset Reinland Altona Starbuck St.Pierre Winkler Kane Brunkild Austin Bagot Elie Kenton Neepawa St. Claude


query
RESULTSET
query
  ACCUPDAY DDATE PDAY TSTNID
1 4.2028 2022-06-06 00:00:00.0 4.2028 239
2 9.7695 2022-06-07 00:00:00.0 5.5667 239
3 16.1463 2022-06-08 00:00:00.0 6.3768 239
4 22.5743 2022-06-09 00:00:00.0 6.4280 239
5 31.1012 2022-06-10 00:00:00.0 8.5269 239
6 39.7287 2022-06-11 00:00:00.0 8.6275 239
7 49.0695 2022-06-12 00:00:00.0 9.3408 239
8 58.4413 2022-06-13 00:00:00.0 9.3718 239
9 67.3488 2022-06-14 00:00:00.0 8.9075 239
10 74.5443 2022-06-15 00:00:00.0 7.1955 239
11 82.9153 2022-06-16 00:00:00.0 8.3710 239
12 90.9023 2022-06-17 00:00:00.0 7.9870 239
13 98.0194 2022-06-18 00:00:00.0 7.1171 239
14 102.1596 2022-06-19 00:00:00.0 4.1402 239
15 111.2410 2022-06-20 00:00:00.0 9.0814 239
16 120.5178 2022-06-21 00:00:00.0 9.2768 239
17 128.8089 2022-06-22 00:00:00.0 8.2911 239
18 135.9724 2022-06-23 00:00:00.0 7.1635 239
19 145.3007 2022-06-24 00:00:00.0 9.3283 239
20 152.6259 2022-06-25 00:00:00.0 7.3252 239
21 160.3944 2022-06-26 00:00:00.0 7.7685 239
22 168.4622 2022-06-27 00:00:00.0 8.0678 239
23 176.7257 2022-06-28 00:00:00.0 8.2635 239
24 184.6794 2022-06-29 00:00:00.0 7.9537 239
25 193.6385 2022-06-30 00:00:00.0 8.9591 239
26 200.7839 2022-07-01 00:00:00.0 7.1454 239
27 208.2234 2022-07-02 00:00:00.0 7.4395 239
28 216.2781 2022-07-03 00:00:00.0 8.0547 239
29 225.7386 2022-07-04 00:00:00.0 9.4605 239
30 235.1528 2022-07-05 00:00:00.0 9.4142 239
31 243.6351 2022-07-06 00:00:00.0 8.4823 239
32 252.6937 2022-07-07 00:00:00.0 9.0586 239
33 261.0707 2022-07-08 00:00:00.0 8.3770 239
34 268.7347 2022-07-09 00:00:00.0 7.6640 239
35 277.4207 2022-07-10 00:00:00.0 8.6860 239
36 286.7878 2022-07-11 00:00:00.0 9.3671 239
37 295.7205 2022-07-12 00:00:00.0 8.9327 239
38 304.0836 2022-07-13 00:00:00.0 8.3631 239
39 313.5369 2022-07-14 00:00:00.0 9.4533 239
40 322.1649 2022-07-15 00:00:00.0 8.6280 239
41 330.5248 2022-07-16 00:00:00.0 8.3599 239
42 336.4022 2022-07-17 00:00:00.0 5.8774 239
43 344.8782 2022-07-18 00:00:00.0 8.4760 239
44 354.4606 2022-07-19 00:00:00.0 9.5824 239
45 363.7592 2022-07-20 00:00:00.0 9.2986 239
46 372.4503 2022-07-21 00:00:00.0 8.6911 239
47 380.7643 2022-07-22 00:00:00.0 8.3140 239
48 389.7911 2022-07-23 00:00:00.0 9.0268 239
49 397.7327 2022-07-24 00:00:00.0 7.9416 239
50 405.6562 2022-07-25 00:00:00.0 7.9235 239
51 414.3714 2022-07-26 00:00:00.0 8.7152 239
52 422.1967 2022-07-27 00:00:00.0 7.8253 239
53 430.1821 2022-07-28 00:00:00.0 7.9854 239
54 438.1140 2022-07-29 00:00:00.0 7.9319 239
55 445.3456 2022-07-30 00:00:00.0 7.2316 239
56 454.3435 2022-07-31 00:00:00.0 8.9979 239
57 463.0284 2022-08-01 00:00:00.0 8.6849 239
58 470.6636 2022-08-02 00:00:00.0 7.6352 239
59 479.1993 2022-08-03 00:00:00.0 8.5357 239
60 486.4782 2022-08-04 00:00:00.0 7.2789 239
61 495.7352 2022-08-05 00:00:00.0 9.2570 239
62 503.5583 2022-08-06 00:00:00.0 7.8231 239
63 510.0465 2022-08-07 00:00:00.0 6.4882 239
64 517.5927 2022-08-08 00:00:00.0 7.5462 239
65 526.2361 2022-08-09 00:00:00.0 8.6434 239
66 533.3624 2022-08-10 00:00:00.0 7.1263 239
67 540.0730 2022-08-11 00:00:00.0 6.7106 239
68 549.4830 2022-08-12 00:00:00.0 9.4100 239
69 558.8930 2022-08-13 00:00:00.0 9.4100 239
CACHED false
EXECUTIONTIME 16
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '239') AND ddate BETWEEN {d '2022-06-06'} AND {d '2022-08-13'} ORDER BY ddate ASC


TOTAL P-Days from to is

Date P-Days Start End
Daily Total
8/13/2022 9 559
8/12/2022 9 549
8/11/2022 7 540
8/10/2022 7 533
8/9/2022 9 526
8/8/2022 8 518
8/7/2022 6 510
8/6/2022 8 504
8/5/2022 9 496
8/4/2022 7 486
8/3/2022 9 479
8/2/2022 8 471
8/1/2022 9 463
7/31/2022 9 454
7/30/2022 7 445
7/29/2022 8 438
7/28/2022 8 430
7/27/2022 8 422
7/26/2022 9 414
7/25/2022 8 406
7/24/2022 8 398
7/23/2022 9 390
7/22/2022 8 381
7/21/2022 9 372
7/20/2022 9 364
7/19/2022 10 354
7/18/2022 8 345
7/17/2022 6 336
7/16/2022 8 331
7/15/2022 9 322
7/14/2022 9 314
7/13/2022 8 304
7/12/2022 9 296
7/11/2022 9 287
7/10/2022 9 277
7/9/2022 8 269
7/8/2022 8 261
7/7/2022 9 253
7/6/2022 8 244
7/5/2022 9 235
7/4/2022 9 226
7/3/2022 8 216
7/2/2022 7 208
7/1/2022 7 201
6/30/2022 9 194
6/29/2022 8 185
6/28/2022 8 177
6/27/2022 8 168
6/26/2022 8 160
6/25/2022 7 153
6/24/2022 9 145
6/23/2022 7 136
6/22/2022 8 129
6/21/2022 9 121
6/20/2022 9 111
6/19/2022 4 102
6/18/2022 7 98
6/17/2022 8 91
6/16/2022 8 83
6/15/2022 7 75
6/14/2022 9 67
6/13/2022 9 58
6/12/2022 9 49
6/11/2022 9 40
6/10/2022 9 31
6/9/2022 6 23
6/8/2022 6 16
6/7/2022 6 10