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 5.8854 2022-06-06 00:00:00.0 5.8854 536
2 11.4410 2022-06-07 00:00:00.0 5.5556 536
3 18.1817 2022-06-08 00:00:00.0 6.7407 536
4 24.3960 2022-06-09 00:00:00.0 6.2143 536
5 32.7198 2022-06-10 00:00:00.0 8.3238 536
6 41.8603 2022-06-11 00:00:00.0 9.1405 536
7 50.8679 2022-06-12 00:00:00.0 9.0076 536
8 59.3505 2022-06-13 00:00:00.0 8.4826 536
9 68.1308 2022-06-14 00:00:00.0 8.7803 536
10 76.4740 2022-06-15 00:00:00.0 8.3432 536
11 84.8077 2022-06-16 00:00:00.0 8.3337 536
12 93.3929 2022-06-17 00:00:00.0 8.5852 536
13 101.8456 2022-06-18 00:00:00.0 8.4527 536
14 106.4588 2022-06-19 00:00:00.0 4.6132 536
15 114.0246 2022-06-20 00:00:00.0 7.5658 536
16 121.7784 2022-06-21 00:00:00.0 7.7538 536
17 129.2685 2022-06-22 00:00:00.0 7.4901 536
18 137.1285 2022-06-23 00:00:00.0 7.8600 536
19 146.1960 2022-06-24 00:00:00.0 9.0675 536
20 153.6903 2022-06-25 00:00:00.0 7.4943 536
21 161.6601 2022-06-26 00:00:00.0 7.9698 536
22 169.6291 2022-06-27 00:00:00.0 7.9690 536
23 176.8958 2022-06-28 00:00:00.0 7.2667 536
24 183.2729 2022-06-29 00:00:00.0 6.3771 536
25 191.6004 2022-06-30 00:00:00.0 8.3275 536
26 197.5524 2022-07-01 00:00:00.0 5.9520 536
27 205.2299 2022-07-02 00:00:00.0 7.6775 536
28 213.8628 2022-07-03 00:00:00.0 8.6329 536
29 222.9637 2022-07-04 00:00:00.0 9.1009 536
30 232.3095 2022-07-05 00:00:00.0 9.3458 536
31 241.4752 2022-07-06 00:00:00.0 9.1657 536
32 250.5330 2022-07-07 00:00:00.0 9.0578 536
33 259.1700 2022-07-08 00:00:00.0 8.6370 536
34 267.3483 2022-07-09 00:00:00.0 8.1783 536
35 276.7095 2022-07-10 00:00:00.0 9.3612 536
36 286.1394 2022-07-11 00:00:00.0 9.4299 536
37 294.8832 2022-07-12 00:00:00.0 8.7438 536
38 302.9842 2022-07-13 00:00:00.0 8.1010 536
39 312.2456 2022-07-14 00:00:00.0 9.2614 536
40 320.4664 2022-07-15 00:00:00.0 8.2208 536
41 329.7310 2022-07-16 00:00:00.0 9.2646 536
42 336.3780 2022-07-17 00:00:00.0 6.6470 536
43 344.7144 2022-07-18 00:00:00.0 8.3364 536
44 354.5045 2022-07-19 00:00:00.0 9.7901 536
45 363.4753 2022-07-20 00:00:00.0 8.9708 536
46 371.8716 2022-07-21 00:00:00.0 8.3963 536
47 380.4543 2022-07-22 00:00:00.0 8.5827 536
48 389.0621 2022-07-23 00:00:00.0 8.6078 536
49 396.8761 2022-07-24 00:00:00.0 7.8140 536
50 403.4416 2022-07-25 00:00:00.0 6.5655 536
51 411.7963 2022-07-26 00:00:00.0 8.3547 536
52 419.4634 2022-07-27 00:00:00.0 7.6671 536
53 427.0893 2022-07-28 00:00:00.0 7.6259 536
54 434.3985 2022-07-29 00:00:00.0 7.3092 536
55 441.6075 2022-07-30 00:00:00.0 7.2090 536
56 449.7360 2022-07-31 00:00:00.0 8.1285 536
57 457.4484 2022-08-01 00:00:00.0 7.7124 536
58 465.6542 2022-08-02 00:00:00.0 8.2058 536
59 474.0001 2022-08-03 00:00:00.0 8.3459 536
60 481.5199 2022-08-04 00:00:00.0 7.5198 536
61 490.5964 2022-08-05 00:00:00.0 9.0765 536
62 498.0364 2022-08-06 00:00:00.0 7.4400 536
63 503.1759 2022-08-07 00:00:00.0 5.1395 536
64 510.6960 2022-08-08 00:00:00.0 7.5201 536
65 519.6030 2022-08-09 00:00:00.0 8.9070 536
66 527.5440 2022-08-10 00:00:00.0 7.9410 536
67 533.5597 2022-08-11 00:00:00.0 6.0157 536
68 542.4037 2022-08-12 00:00:00.0 8.8440 536
69 551.2477 2022-08-13 00:00:00.0 8.8440 536
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '536') 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 551
8/12/2022 9 542
8/11/2022 6 534
8/10/2022 8 528
8/9/2022 9 520
8/8/2022 8 511
8/7/2022 5 503
8/6/2022 7 498
8/5/2022 9 491
8/4/2022 8 482
8/3/2022 8 474
8/2/2022 8 466
8/1/2022 8 457
7/31/2022 8 450
7/30/2022 7 442
7/29/2022 7 434
7/28/2022 8 427
7/27/2022 8 419
7/26/2022 8 412
7/25/2022 7 403
7/24/2022 8 397
7/23/2022 9 389
7/22/2022 9 380
7/21/2022 8 372
7/20/2022 9 363
7/19/2022 10 355
7/18/2022 8 345
7/17/2022 7 336
7/16/2022 9 330
7/15/2022 8 320
7/14/2022 9 312
7/13/2022 8 303
7/12/2022 9 295
7/11/2022 9 286
7/10/2022 9 277
7/9/2022 8 267
7/8/2022 9 259
7/7/2022 9 251
7/6/2022 9 241
7/5/2022 9 232
7/4/2022 9 223
7/3/2022 9 214
7/2/2022 8 205
7/1/2022 6 198
6/30/2022 8 192
6/29/2022 6 183
6/28/2022 7 177
6/27/2022 8 170
6/26/2022 8 162
6/25/2022 7 154
6/24/2022 9 146
6/23/2022 8 137
6/22/2022 7 129
6/21/2022 8 122
6/20/2022 8 114
6/19/2022 5 106
6/18/2022 8 102
6/17/2022 9 93
6/16/2022 8 85
6/15/2022 8 76
6/14/2022 9 68
6/13/2022 8 59
6/12/2022 9 51
6/11/2022 9 42
6/10/2022 8 33
6/9/2022 6 24
6/8/2022 7 18
6/7/2022 6 11