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.8556 2022-06-06 00:00:00.0 4.8556 533
2 10.9897 2022-06-07 00:00:00.0 6.1341 533
3 17.1470 2022-06-08 00:00:00.0 6.1573 533
4 23.4647 2022-06-09 00:00:00.0 6.3177 533
5 32.4104 2022-06-10 00:00:00.0 8.9457 533
6 41.2617 2022-06-11 00:00:00.0 8.8513 533
7 50.4911 2022-06-12 00:00:00.0 9.2294 533
8 58.8840 2022-06-13 00:00:00.0 8.3929 533
9 67.8916 2022-06-14 00:00:00.0 9.0076 533
10 76.1491 2022-06-15 00:00:00.0 8.2575 533
11 84.5097 2022-06-16 00:00:00.0 8.3606 533
12 93.3704 2022-06-17 00:00:00.0 8.8607 533
13 101.7831 2022-06-18 00:00:00.0 8.4127 533
14 106.4454 2022-06-19 00:00:00.0 4.6623 533
15 115.2353 2022-06-20 00:00:00.0 8.7899 533
16 124.0563 2022-06-21 00:00:00.0 8.8210 533
17 132.1199 2022-06-22 00:00:00.0 8.0636 533
18 139.5723 2022-06-23 00:00:00.0 7.4524 533
19 149.2633 2022-06-24 00:00:00.0 9.6910 533
20 156.6841 2022-06-25 00:00:00.0 7.4208 533
21 164.6449 2022-06-26 00:00:00.0 7.9608 533
22 173.1351 2022-06-27 00:00:00.0 8.4902 533
23 181.7192 2022-06-28 00:00:00.0 8.5841 533
24 190.4258 2022-06-29 00:00:00.0 8.7066 533
25 199.7727 2022-06-30 00:00:00.0 9.3469 533
26 207.7541 2022-07-01 00:00:00.0 7.9814 533
27 215.8811 2022-07-02 00:00:00.0 8.1270 533
28 224.7808 2022-07-03 00:00:00.0 8.8997 533
29 234.2388 2022-07-04 00:00:00.0 9.4580 533
30 243.6305 2022-07-05 00:00:00.0 9.3917 533
31 252.2841 2022-07-06 00:00:00.0 8.6536 533
32 261.3818 2022-07-07 00:00:00.0 9.0977 533
33 269.6836 2022-07-08 00:00:00.0 8.3018 533
34 277.6827 2022-07-09 00:00:00.0 7.9991 533
35 286.4133 2022-07-10 00:00:00.0 8.7306 533
36 295.6703 2022-07-11 00:00:00.0 9.2570 533
37 304.9113 2022-07-12 00:00:00.0 9.2410 533
38 313.4098 2022-07-13 00:00:00.0 8.4985 533
39 322.7291 2022-07-14 00:00:00.0 9.3193 533
40 330.6358 2022-07-15 00:00:00.0 7.9067 533
41 338.5192 2022-07-16 00:00:00.0 7.8834 533
42 343.3084 2022-07-17 00:00:00.0 4.7892 533
43 351.4200 2022-07-18 00:00:00.0 8.1116 533
44 360.6844 2022-07-19 00:00:00.0 9.2644 533
45 369.9718 2022-07-20 00:00:00.0 9.2874 533
46 379.0472 2022-07-21 00:00:00.0 9.0754 533
47 387.7697 2022-07-22 00:00:00.0 8.7225 533
48 396.9228 2022-07-23 00:00:00.0 9.1531 533
49 405.5931 2022-07-24 00:00:00.0 8.6703 533
50 414.0840 2022-07-25 00:00:00.0 8.4909 533
51 422.9621 2022-07-26 00:00:00.0 8.8781 533
52 431.2096 2022-07-27 00:00:00.0 8.2475 533
53 439.5990 2022-07-28 00:00:00.0 8.3894 533
54 448.0417 2022-07-29 00:00:00.0 8.4427 533
55 455.3384 2022-07-30 00:00:00.0 7.2967 533
56 464.4589 2022-07-31 00:00:00.0 9.1205 533
57 473.3233 2022-08-01 00:00:00.0 8.8644 533
58 481.2521 2022-08-02 00:00:00.0 7.9288 533
59 490.4467 2022-08-03 00:00:00.0 9.1946 533
60 498.1294 2022-08-04 00:00:00.0 7.6827 533
61 507.4419 2022-08-05 00:00:00.0 9.3125 533
62 515.2241 2022-08-06 00:00:00.0 7.7822 533
63 522.7295 2022-08-07 00:00:00.0 7.5054 533
64 530.2304 2022-08-08 00:00:00.0 7.5009 533
65 539.5679 2022-08-09 00:00:00.0 9.3375 533
66 547.9510 2022-08-10 00:00:00.0 8.3831 533
67 554.6745 2022-08-11 00:00:00.0 6.7235 533
68 563.9786 2022-08-12 00:00:00.0 9.3041 533
69 572.2647 2022-08-13 00:00:00.0 8.2861 533
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '533') 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 8 572
8/12/2022 9 564
8/11/2022 7 555
8/10/2022 8 548
8/9/2022 9 540
8/8/2022 8 530
8/7/2022 8 523
8/6/2022 8 515
8/5/2022 9 507
8/4/2022 8 498
8/3/2022 9 490
8/2/2022 8 481
8/1/2022 9 473
7/31/2022 9 464
7/30/2022 7 455
7/29/2022 8 448
7/28/2022 8 440
7/27/2022 8 431
7/26/2022 9 423
7/25/2022 8 414
7/24/2022 9 406
7/23/2022 9 397
7/22/2022 9 388
7/21/2022 9 379
7/20/2022 9 370
7/19/2022 9 361
7/18/2022 8 351
7/17/2022 5 343
7/16/2022 8 339
7/15/2022 8 331
7/14/2022 9 323
7/13/2022 8 313
7/12/2022 9 305
7/11/2022 9 296
7/10/2022 9 286
7/9/2022 8 278
7/8/2022 8 270
7/7/2022 9 261
7/6/2022 9 252
7/5/2022 9 244
7/4/2022 9 234
7/3/2022 9 225
7/2/2022 8 216
7/1/2022 8 208
6/30/2022 9 200
6/29/2022 9 190
6/28/2022 9 182
6/27/2022 8 173
6/26/2022 8 165
6/25/2022 7 157
6/24/2022 10 149
6/23/2022 7 140
6/22/2022 8 132
6/21/2022 9 124
6/20/2022 9 115
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 50
6/11/2022 9 41
6/10/2022 9 32
6/9/2022 6 23
6/8/2022 6 17
6/7/2022 6 11